Product Q&A

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"

Hi Team, Can you please help me with the code to extract Knowledge Mode Record information using Py Celonis.I checked the PyCelonis documentation but was not able to get the same. Thank You in advance. Regards,JB

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

is it possible to use crop selection to filter the activities within range in Views? the similar function is available in the Analysis module out of box.

Hi can anyone help me in how touse EMS platform of celonis since i am very new to this platform and i want to upload a dataset and try this platform

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

Dear Experts, I recently created an app and realized that i need to add one more table into data model. Is it possible to go ahead uploading my table and loading data model without disturbing everything i created ( like views , PQL formulas etc )

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