Product Q&A

I'd like to create table. Added a column (A-B FLAG) PQL to the OLAP table on the dashboard that determines A and B. (Not on the data table.) I want to create a pie chart on the Celonis dashboard that counts A and B and the number of each. In that case, what formula should I add for KPI and Dimension, respectively?

Can I arrange the columns in a CSV within an Action Flow? Seems this should be straightforward, but I cannot seem to organize columns as my customer has requested

Dear Experts, i have question here , lets say if i have SAP GRC and all the transformations are being performed inside it and based on some calculations it generates notification. Can we connect on this this notification to Celonis and based on this notification i have to do something on celonis data model ? So the only thing i am trying to interface with notification from external system without interfacing entire data and want to check if this is possible . ?

Hi all,​I'd like to know where can I find prerequisites to use celoinis template in market place, which SAP table is required to use it, for example.should I need to check all SQLs or data connections to know it or do we have something Excel list to know it?

Like what information do we need to define a new non-standard activity, what tables we need to look at for Payment Proposal Creation!

Hi all, is there a possibilty to view and/or edit the formulars of the preconfigrued process explorer KPIs? Thanks in advance! Best,Jonas

Can Celonis be used as a data source to other tools?

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?

Hello everyone, I want to present a KPI using a custom format not available in the default format options. Is it possible to create custom formats somehow? I cannot change the KPI value because it must be used as KPI of a pivot table. Thks!

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?

Hello Community, I do my first steps with Actions Flows and have a scenario where I get stuck. Sending a single E-Mail with a PDF file is no problem, but how to handle this: Creating PDF Reports from Analysis per Customer ID and sending the PDF to the E-Mail of the Customer ID. How can IGetting Customer IDs + E-Mail AddressesCreating x PDFs. One per customer, filter on customer IDSending one E-Mail per customer with the correct attached PDF Maybe anybody has a blueprint for this? Thanks for helpThomas  

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"

Hey guys,I'm getting the return below when performing an ARIBA data extraction and I'm in doubt if this limitation is celonis or ARIBA. I've been trying to do this extraction for days, there are times when it starts and then stops and returns this message.  Reached Job Submission API limit waiting for 60 seconds. Current rate limits are;---X-RateLimit-Limit-day: "150"X-RateLimit-Remaining-day: "53"X-RateLimit-Limit-hour: "8"X-RateLimit-Remaining-hour: "4"X-RateLimit-Limit-minute: "2"X-RateLimit-Remaining-minute: "0"X-RateLimit-Limit-second: "1"X-RateLimit-Remaining-second: "0"