General Product Q&A

I want to create a process map for my data. Therefore, I tried to load my data using Quickstart CSV. But during 'Generate analysis at the final step 'Creating your Analysis' ' I got an error: "The export failed: Table contains more rows than the allowed maximum per table of 100000 Please reduce the number of rows.". I want to keep more than 100000 rows for statistic purposes.

Hello everyone!​I have the code below:​AVG(   CALC_THROUGHPUT(    ALL_OCCURRENCE['Process Start'] TO FIRST_OCCURRENCE['Incident assigned to a new operator'],     REMAP_TIMESTAMPS("activity"."SYS_CREATED_ON", SECONDS)   ) / 60 /60  )​which calculates averate throughput time until activity "Incident assigned to a new operator" occurs. I have however changed the data transformation script, so that this activity can now either be "Incident assigned to an operator by service desk" OR "Incident claimed by operator from incident pool"Obviously this change broke my KPI, as what used to be one activity can now be either one of the two. I was hoping it would be possible to pass two strings to FIRST_OCCURRENCE[] (such as FIRST_OCCURRENCE['Activity A','Activity B']), indicating I want to measure time until occurence of either "activity A" or "activity B", similarly to NODE_ALL[] vs NODE[], but unf

I am getting error while uploading a file in Data Integration On Premises. The error is : File Upload failed: cloud.celonis.integration.services.datamodel.file.DataPushJobException: ["2023-04-11T04:17:23 - Starting execution, status set to RUNNING"]

How to write a if/else statement for runtime variable?

Hi,In one of the Apps, I got the logic for the KPI -3-way match. But when I tried to fix I am getting the error as below- Can you please help me? Please find the error first and then the logic I used - Error: Syntax error near [<] after reading [ (((1.0*"EKPO"."MENGE") - (1.0*PU_SUM("EKPO","EKBE"."MENGE","EKBE"."VGABE"='1' AND "EKBE"."SHKZG" = 'S'))) >= (-1*((1.0*"EKPO"."MENGE") *(] at line 21. Please refer to PQL documentation for available syntax. Logic: 100*(1.0*COUNT( DISTINCT CASE  -- No quantity match if order quantity is 0 WHEN "EKPO"."MENGE" = 0 THEN NULL WHEN -- Quantity match     --Order Quantity = GR Quantity   (((1.0*"EKPO"."MENGE") - (1.0*PU_SUM("EKPO","EKBE"."MENGE","EKBE"."VGABE"='1' AND "EKBE"."SHKZG" = 'S'))) >=

Is it possible to visualize graphs such as scatter plots, correlation plots, box plots, etc. in Celonis?

How to find your celopeer at the platform? I want to find my Celopeer. Eventhough I wrote her name in the search button I cannot find.

Can we add filters to variables?

How to define restrictions for user by company code?

Is there a syntax in PQL that is equivalent to Groupby~Having in SQL?

What is the difference between comparative and predictive process mining?

I want to show a graph with 5 Top Vendors according to the value (which is the sum of complex calculation values with few cases embedded). I am good with using First K Rows. However I do not want to show "Others" as it destroys the view, as "Others" has much bigger values than individual Top 5.  Is there any way to actually show Top 5 without others? Will be grateful for any answers  Best regards, Krzysztof

Hi All,I want to create a view where different KPIs are listed/displayed. According to the value of the KPI, a different background color is shown (with the help of a display rule). However, I would like to click on the KPIs, showing me more information. I can't find this possibility, since it seems that KPI elements don't have clickable functions, and buttons don't have the possibility to display a value with a display rule. Any ideas? 

I want to add an index to the leftmost column of an OLAPtable that displays row numbers. What procedure should I follow to set this up?

Hey guys,We are trying to export tables from SAP Ariba via API SOURCING, but we are receiving the return below in Celonis extract. I understand that SAP Ariba has an extraction limiter for this API regarding the number of daily requests. Has anyone experienced this problem in this extraction? Is there any filter in this extraction that could be done to extract only what is needed? I believe the problem is in the number of rows in the Audit Entry table. Has anyone had this problem and could help me? Reached Job Submission API limit waiting for 3420 seconds. Current rate limits are;---X-RateLimit-Limit-day: "150"X-RateLimit-Remaining-day: "45"X-RateLimit-Limit-hour: "8"X-RateLimit-Remaining-hour: "0"X-RateLimit-Limit-minute: "2"X-RateLimit-Remaining-minute: "0"X-RateLimit-Limit-second: "1"X-RateLimit-Remaining-second: "0"

Hi, I have created an application, authorised it and created a custom extractor which uses the Login History API to load the login history into a data pool. Unfortunately, this data is very limited and I don't know how to specify the parameters to load a larger period and analyse it afterwards. Is it possible to include a date filter in the endpoint or in the extraction, so that all data since a certain date is loaded? 

Hi all,​I have a problem about how to write PQL, please check following conditions and please let me know how to write it.​My process flow like thisProcess start(some activities here)work startwork start of A taskwork start of B taskwork start of C task(some activities here)Process end​and what I concern is #3 workstart, that has some branch and it might be in no particular order and combination is exist, so it might move 3-1 to 3-3 or 3-2 to 3-1, and I would like to get firstest work start time of work start. So I think it might be work if I can filter in specific activity name, then sort the date ascending and select distinct of its value but I don't know how to do it in PQL. Can anybody let me know how to do it?

Hi all, I'm looking for way to copy data pool with its data, I found copy function of data pool but if I push that it only contains data connection, data job, and data model, not its uploaded data. Is it able to include original data to copy environment?

Can someone suggest best way to add colour to the KPI in views based on another KPI value

Dear all, I am trying to embed process explorer inside views to create my analysis. But The scroll bar to increase activities and links is not appearing . Could you suggest any work around . Attaching my snapshot for you for reference

Hello,i don't manage to log in the Infor M3 connector with OAuth2 authentification (ionapi file).How can i connect this?The M3 Cloud is a multitenant version.thanks in advance

How should the number of cases that do not go through a particular activity be coded in the PQL?

Hi,I would like to calculate SUM of two KPIs and display it in the views( using text box or kpi card etc.) Currently, i am trying to update the variable with KPI value using Onclick update variable option. But it seems to only store id, name and metadata of variable. I cannot access the value of KPI using Metadata object. I can only add KPI reference in any component using ".id" property of metadata object. SUM is not possible with ID references.Kindly suggest on how to achieve this.Thank you :) Best Regards,Shravya B

Hi Expert,  Does anybody know how to export data model technical document as same as dashboard? I just would like to share how to connecting SAP add-on table to business side but there I don't found any connection export way other than json. (business side don't know tech except SAP so I need something natural language one is better.)  Do we have something way to export data model?

(The info is available for 3 years back)  It is currently only showing 1 year (Jan22-Dec22)Thank you!