Product Q&A

We want to highly tailor the demo for our prospect client, is it possible to get the data set and make some customization on desktop?​Thanks!​

This is a standard Accounts receivable data job. it started to get error.  I need to analyz or alter comment to fix it. but it was working as it is (: Other one is this it suddenly started to ignore AUGCP column. but it is still exist. 

Is it possible to customize the mails sent from Action engine? eg: Along with the number of signals(like 23 new signals) I would also like to view the list of the (23)names which has caused the signals, in the mail itself being sent?

hi i am beginner in celonis .i watch (beginner )all videos .i can understand how to make app but i still confused if i make a new app then how can i start... i need someOne help me to make any project process Mining

Hi Guys, i have the following PQL Code "TABLE (COUNT( "AP_BSEG"."ZTERM" ),"AP_BSEG"."ZTERM" );" I want to sort it by the count values, so that the most frequent value is the first one and the least frequent value is the last one. How can i do that?

I am trying to fetch real time information from Oracle EBS and want to use Action flows to send an email if there is any entries being wrongly created. While using EBS Node to connect the DB , it looks for a connection.I created the connection , but the same do not appear in the list. Anyone - Have you ever connected Oracle EBS from Action Flow Node? please Help

In other tools, I would crop the process, export the new event log for the cropped process and import the new event log back as a new process. Is there a smarter way of doing that in Celonis? If not, is there a way to export the adjusted event log from Celonis?   

Hi @all, We have a Data Pool with 2 Data Models: Data Model “ECI Data Model HTD - TABLES - TEST” has been duplicated from the Data Model “ECI Data Model HTD - TABLES”. If we do a “Manual - Complete Reload” of both Data Pools, the load times are very differents: “ECI Data Model HTD – TABLES” --> 34 min “ECI Data Model HTD – TABLES – TEST” --> 21 min  Apparently, the load time of each of the tables is very similar:   If we do a "Manual - Partial Reload" on both Data Pools of a table that only contains 87 records, the load times are also very differents: “ECI Data Model HTD – TABLES” --> 19 min “ECI Data Model HTD – TABLES – TEST” --> 3 min What could be due to these differences? As we said before, the Data Model that has the best times has been duplicated from the previous one. Thanks in advance!

‘On Account Cash’ process is related to Account Receivable only with following business scenario – ‘On Account Cash’ sub-process comes into picture when there is one or multiple invoices issued to customer and customer made partial payment which is NOT equal to cumulative outstanding amount.In this case, say there are three invoices with amounts $20,000; $30,000 & $40,000 that need to be cleared with a partial payment received of $70,000 from customer. This amount received remains as ‘On Account Cash’ on the books until it is manually coordinated with customer and applied in system using SAP TCODE FEBAN.The related SAP tables in SAP I came to know are -BSID – contains information on total outstanding amount for customerBSIS – contains information on balance un-applied (‘On Account Cash’ available to be applied manually) per customer If there was any savings achieved in this area for any of the Celonis clients, it would be great to present as a success stories as required in this a

We are trying to connect Celonis with Microsoft Dynamics 365 on the client side. Is there anyone who can help with this? The online documentation is not very useful as it talks about Action Flows only which comes at a much later stage.

Hello team,It would be great if the steps were guided in the format which gives answer to the question helps us to navigate the process.More appreciated if query is addressed ASAP.Thank you

how to extract data from file which is uploaded from file upload folder and create a data connection in data pool in celonis studio.

When a sales person is alerted by an action flow, can I know what activities the salesperson is doing as a result of the alert? i.e., Can I have a record in Celonis of the activities following the alert?

I wanted to calculate all documents processed by any user per day. Can anyone help with formula or explanation how it can be done​

Hi @janpeter.van.d​ / @Celopeers .​  I need to query Table A and look for all distinct Machinename . After that I need to update Table B, If Machinename exists so ok. If not, need to create new lines in Table B with 'No ID' field at location 

Which training track needs to be completed for BVA certification?

Our use case requires analysis on inventory stock levels, and the unit of measurement for inventory is cases so we would like to reduce the amount of confusion that could arise from this.

SAP Tables for P2P-Process Hello, is there any list where the required SAP Tables for the whole P2P Process are listed? If only the tables of the sample files are included, a lot of information is missing. Best regards!

Hi, Currently I am using the following: filter "tableName.csv"."TASK_TITLE" LIKE 'Condition1' which is filtering on a specific name.  How do I change the syntax so that it takes into account an additional condition? i.e. I want it to filter words that have a full stop in them. (condition 2 = '.') thanks,Terence

I encountered MS 365 connection error (per screenshot) during an auto scheduled refresh today. This auto schedule has been working fine daily for a week​ without any connection error. What could be the possible causes? Thanks.

Hi Team, Please show me how to display the "Allow CSV export of analysis components" setting.  It is displayed in another environment, but not in the specific environment.  I look forward to hearing from you. Best Regards,Satoshi Omachi

The selected Process Connector is not available for your database type. Please contact Celonis support. 

Team - we are supporting a user community that has been using the platform for over two years. As such, they have many apps that have been loaded over the period of time and the majority are not being used. We are looking for a report that shows the list of all the applications and what space they reside. Also, who published it and when and who last used it and when. This could give us a clear picture of what we can archive. Any suggestions or do you have a report to re-use? Thanks.

Scenario - We have 2 sheets - Dashboard and DetailedIn detailed sheet we have an OLAP table (for example) wherein we have company codes as dimension and count of documents as KPI.Question - Now, we want to automate dashboard with a TEXT COMPONENT which only shows me top 3 company code names basis count of volume (in descending order) in the OLAP table in detailed sheet.For Example - If we have 10 rows in OLAP table having 2 columns showing me Co. Code 1, Co. Code 2....Co. Code 10 and there is a value against each co. code.In Dashboard under TEXT component (TOP 3 least performers) - it shows me only those 3 co. codes based on OLAP table...it can be Co. Code 5, Co. Code 7 and Co. Code 10. Any guidance here will be really helpful.  thanks in advance.

Hi All, Is there any way to put data pool parameters for just rolling 12 months so that it can extract data for last 12 months only every time ? Can we define such parameter for extraction and what will be the syntax?