General Q&A - TO REMOVE

When to build an extractor from scratch and when to use uplink connections differentiate?

Error while transforming Data - Quickstart P2P Hello, is there any way to gain further insights while using the quickstart P2P mode? Im having an error while transforming the data and would like to see the reasons for this. Thanks!

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 @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

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

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

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?

I was thinking on using something like Name Mappings, but you can't. ​The idea was to have something in your _CEL_ACTIVITIES likeACTIVITY = '1.1'ACTIVITY_EN = "Receive Order"ACTIVITY_ES = "Recepción de Pedido" and then use only ACTIVITY for all the PQL codes I could need But the user will see the activities names in their selected language

Data not visible even though I get a status 200

Anstehendes Webinar im Bereich Order ManagementLiebes Volkswagen Team, am 14. Juni findet ein spannendes Webinar zum Thema "Process Excellence in Order Management" statt. Hierfür können Sie sich unter folgendem Link anmelden: https://www.celonis.com/webinar/doculabs-usg/ Wir freuen uns, Sie bei dem Webinar begrüßen zu dürfen,Alena Romahn & Ihr Celonis Team

does celonis has a unit4 connector?

Hi, How do I filter on a column chart?  I want to only see data on 'Fallouts' and exclude anything that has the name 'NULL'.Thanks,Terence

How to calculate the lost and possible cash discounts. Please share the relevant fields and logic?

How to pass an existing variable from button dropdown to OLAP table dimension in Celonis?

Is it possible to set Activity color in Process / Variant Explorer by formula? ...or by activity table field? It will be usefull in multilog scenario. Thanks, Alex.

When creating the simulation, the following question came up with me.Could you please answer the questions?​1：When setting up Degital Twin, should I enter actual business hours for the From and To fields of Incoming Cases? Or, should I set the time when the process is running as configured in Degital Twin?​2：When setting up Degital Twin, what does the Incoming Cases case per day value mean?​3：When creating a Simulation scenario, is it sufficient to enter actual business hours in the From and To fields of Incoming Cases? Or should I set the time when the process is actually running?​4：​When creating a Simulation scenario, what does the value of Case per day in Incoming Cases mean?​

As you can see below we have Ticket On Hold as always the starting point (with diff event time) and need to calculate the time diff. with the next following activities that can ONLY be - Ticket in Progress / Ticket - Waiting for Issue / Ticket Resolved (first one to occur after starting activity) As you can see from the example below we have to calculate 4 time differences:1) From Start 1 Ticket On Hold to End 1 - Ticket in Process2) From Start 2 Ticket On Hold to End 2 - Waiting for issue3) From Start 3 Ticket On Hold to End 3 - Ticket in Process4) From Start 4 Ticket On Hold to End 4 - Ticket Resolved 

Is there any document available for On Premise to EMS Migration?

i want to create a dual axis chart in view but 1st will be bar chart and 2nd will be the line chart , and i want the bar chart value constant it should not get changed according to line chart filter , how can i do that . Thankyou

I wish to appear for the Solution Professional Exam. Can somebody guide me on a> How I can enrol for the exam? b> where i can find the relevant track(s)/ module ? c> Prerequistes

Hi, I am currently using the Machine Learning Platform on Celonis to read a csv file using pd.read_csv which has been working perfectly until I had to update it with a new csv file.  There's a weird problem where, when I read_csv the file in the Jupyter environment all the data is thrown into one column. It's even more odd because if I view the csv file directly on Excel or by opening it on another tab in Celonis Machine Learning, all the data seems to be formatted correctly into a table.  So, I'm not sure why it's suddenly reading everything into one column. Thanks,Terence

Hello,I would like to create a benchmark exactly as it is done in the Accounts Payable analysis (found in both the training and the Sandbox), but instead of comparing the Companies (or other attributes) I would like to define two different time intervals. Ideally, I would like to insert two Date Pickers, one for the left part of the sheet and one for the right part, and therefore be able to define two different periods. Thanks to anyone who will give me some advice or best practices for my question

I'm creating the column chart and I'd like to change the intervals between numbers on the vertical axis. Could you please tell me the way?