General Product Q&A

Have you ever used EKKO as a case table? What is the EKKO's activity table ?

I need to check for a value (eg. 'COMPLETED') of a table column from Celonis transformation. The action flow needs to check for the status of the column like every 15 minutes and once it finds the 'COMPLETED' status, the Celonis action module needs to execute the corresponding data model. Appreciate the ideas/logic.

I would like to create an OLAP table containing the following KPIs.Could you please provide me with the formulas for the following four PQLs? Number of cases passing through a particular activityNumber of cases that do not pass a specific activityThe number of cases coming from a specific activity to a specific activityThe number of cases that go from a specific activity to a specific activity

2. FTE in Cash Payment involved in the process - when I am adding the FTE as per the estimated weekly workload the tool gives an error and on putting a value of FTE much more significant than that there is no error.  What does Simulation duration denote? On adding the Simulation duration of 400 Days, the simulation runs for 800 cases while the total number of cases is only 100. Can you explain this? Please find the attached screenshots for the same.

Hello i'm looking for the replay of the ABB x Celonis Webinar. could you please help Regards

Hello, i trying to check if a item on a delivery note was created manually or by a bot. however my lips table is not retrieving data from deliveries that are not LF (final product) or LR(Returns) leaving out in house transfers that appear on SAP.

I have to integrate Celonis and BPM tool so that i can do conformance analysis seamlessly . Please advise ?

How to remove filters from button dropdown menu (load entries)? I created a button dropdown menu with load entries. When I select one value in the dropdown menu, there is no option to simply remove the filter and show all the values again.

Is there a simple way of triggering a Python script within an Action Flow?

Hello all, is there a way to install the R package tidyvers in the ML Workbench. I have tried two possibilities which unfortunately run into an error (see screenshots). Thanks for your answers in advance. With kind regards  Christoph In R on ML Workbench In Py on ML Workbench 

Error: There is no data left in this ResultSet Can someone please let me know to resolve this issue

Good morning community, I'm trying to perform an extraction on a sizeable SAP table (AUSP) by linking it to another table (MCH1). These tables are linked through a field that is not quite the same on both tables. In AUSP, this field will be a value like '000000000000003641', whereas on MCH1 this value will be '3641' Since I don't know if I can use any formulas to add X amount of '0' characters (this would be using something like repeat character '0' 18-Length(3641) times), I want to convert '000000000000003641' to Integer. I have tried a number of variations of the following join: But I always get this error: Can anyone point me to what I'm doing wrong? Is Datatype Conversion perhaps not available for SAP ECC? Does anyone have any other ideas? This is the Celonis Documentation I am following    Thank you in advance!!!

Hi folks! I know I can use a module to get data from a data model in an action flow, but can I get data from a component in analysis for example an OLAP table in an action flow?

Hello, I am building a use case and I need to calculate several variables and show aggregared data in a form of 'SUM' vaue. I do have a lot of data for the dimension I am using and I would like to limit those according to the 'SUM" value. Is there any way that I could place aggegated filter?E.g. SUM(A+B)>5  I am not able able to use the Pull-Up function here. I would not prefer to Limit the rows or use First K Rows.Ideally I am looking for an Option which would work in similar way as "Having" works in SQL.  Will be grateful for any answers/ hints.Best regards, Krzysztof  

How can we arrange filter value in order in Button Dropdown using load entries? Options under button dropdown should be of order. - Committed Case- Violated Case- Others But the 'Others' option is listed 2nd as per alphabetical order. Code:CASE WHENPU_COUNT ("A", "B"."caseid" ) > 0THEN 'Committed Case'WHEN  PU_COUNT ("A", "C"."_CASE_KEY", "C"."CHANGED_TO" IN ('In Progress') AND "C"."CHANGED_FROM" NOT IN ('New')) > 0THEN 'Violated Case'ELSE'Others'END Other than rephrasing the options and numbering the options, is there any default logic to order the options as we like.

I registered using guest but need to change it to partner

Dear Celopeers, I would like to save the third largest Count of Order Items per country as a variable.E.g.:DE - 7000EN - 12000IT - 9500...Variable: 7000I only have access to these functions: https://help.celonis.de/display/PQL47/PQL+Function+Library+-+CPM+4.7 Thank you in advance!

Why is the export of data pool available in JSON format only?

Hi everyone, we are currently running into the limitations of action flows. Namely runtime. Use-Case: We want to create 2000 PDF Reports from Analysis sheets and send them to different people. Creating one PDF Report takes aprox. 40 seconds. Therefore after only 80 reports, we already reached the runtime limit. Did someone already encounter this issue? Possible Solutions that I already had in mind:Skill to trigger parallel executions of that action flow (I don't think this works because I can't even execute an action flow while it is already running)Duplicate the action flow like 40 times (I don't think this can even be considered a solution) Thankfull for any help that someone might provide!Thanks in advance. Best regardsPatrick

Is data stored in AWS or Azure? (There's one post that says its hosted in AWS and another that says its hosted in Azure)

I have created dropdown but unable to build or cant find any option where I build select all checkbox.

when constructing an activty in data transformations, we use insert into, select, where, from. but how we will know we will put some joins in "where"? to sum up, how we can construct an activity?

Hello,  I'm attempting to create a data connection via .xlsx file on my computer. I created a space and then made the data pool connection alias. However, once i select "Connect to Data Source" and successfully connect my data, it does not proceed to make the connection.  Can you please help and or instruct me on the correct method to complete the next steps? (See images below)  Once I selected Esc, the remains equivalent to image one, any help is greatly appreciated.  Thanks!!

How to change the activity order?

Hello, I have a excel database where there is a date column. I try to change the format of this column using this function :CAST( column_name AS timestamp) But it shows me a lot of empty value and its not supposed to... For some raws its working but not all of themDo you have an idea ?