Product Q&A

Access the Order Management demo to answer this question. What are the top three late delivery root causes by case occurrence for customer Wallenquist Organization 11746?

Hi all,I need your ideas for architecture/approach on how to trigger a Machine Learning App every time a Datamodel is loaded.More specifically if there are new rows in a specific table. The Machine Learning App itself is also adding new data (to another table) and then reloads the model again.  My initial ideas where: creating a Trigger + Action Flow.Trigger based on the table which is the input for my ML App. The Action FLow itself is similar to an offical Celonis Example which triggers the App via API.But this has following limitations: limit of 10000 which makes it tricky. Furthermore this triggers for every new row. I only want to run it once. Not thousands of times for each new row. Scheduling by time:I could also run the Action Flow or even the ML App directly via timeschedule and time it so that it is after sufficient time after my new data is fully processed.This however is more unreliable as the normal process of extracting source/Transformations/datamodel load might take long

From the below data I need,1. Total Through put time by STAGES(I have used standard KPI of Total Throughput Time formula and component Filter by STAGE, even though not getting required output) 2.Total Throughput time by TYPE(I have used standard KPI of Total Throughput Time formula and component Filter by TYPE, even though not getting required output) NOTE: Getting total time for the both scenarios after giving the Total throughput time and component filter

Hello everyone, I want to build a worklist in Celonis with exception messages that purchasers should process. New exception messages should be marked with an augmented attribute (Status: NEW). I also have another augmented attribute - Comment field. I now want to store every changes made manually (change status from e.g. NEW to in Clarification or changes in comments) into a table as this table is needed to train an AI model. Is this possible - has anyone made experience with this and is willing to share their experience? Thank you! Best regards,Julia Bauer

  PU_COUNT_DISTINCT ("_CEL_OTT_CASE_TABLE_NWF_DD",FILTER_TO_NULL("_CEL_MERGED_ACTIVITIES"."ACTIVITY"),  "_CEL_MERGED_ACTIVITIES"."ACTIVITY" LIKE 'NWF: Due % & Release'   AND   "_CEL_MERGED_ACTIVITIES"."TEAM_LEADER" = 'Robben Ramatlo'  )

Good day, can someone please share with me the formula that is used in the PI Social to calculate the KPI "Users per case"

I'd like to create a component (dropdown or checkbox), to switch between two data models (let's call them "test", and "prod"), that have the same structure but contain different data.I tried two ways:A runtime variable called "dm" holding the data model variable name. I used this in the knowledge model like this: dataModelId: §{{dm}}A runtime variable holding a boolean value (1 or 0) called "useProd". I used this like follows: dataModelId: §{{useProd==1?prod:test}}Both ways didn't work. Did I just do it wrong or is it impossible?

I have a customer who also uses celonis. We would like to push them tables from our instance into theirs. Of course we could also make the raw tables available and they could extract them directly. But was assuming there was also a capability to share a data pool externally from my instance. Is that a possibility? I could not find any documentation on this...

How do I look at cycle time of mulitple events in my process. I want to know the cycle time of First Occurence of "Change" events 7 different events compared to the initial "Create" event. I can do this easily for each event but I want to look at all 7

Hi, is there is a way in Transformation center how to add a personal email as a recipient for email alerting? We don't need it for a long-term but we are having issues with showing the KPI charts in the emails and need to rule out potential causes.

Hi, how can I achieve a calculation with an OR / INLIST('RESOLVED','RESTORED')This formula is not working. Do I need to construct a case when first? AVG(    CALC_THROUGHPUT(    FIRST_OCCURRENCE['QUEUED']    TO     FIRST_OCCURRENCE['RESOLVED']  OR  FIRST_OCCURRENCE['RESTORED']    ,     REMAP_TIMESTAMPS("eventlog"."TIMESTAMP", HOURS))  ) The part without OR  FIRST_OCCURRENCE['RESTORED'] works fine

Hello, We have developed a Github backup automation in the workbench based on this repo by @simon.klotz​ :https://github.com/celonis/pycelonis-examples/blob/main/pycelonis2/01_example_use_cases/01_use_case_version_control.ipynb The script was adapted to our needs so that analyses, knowledge models, variables, and transformations are assigned to the Celonis project and loaded directly into the corresponding Github repo as a backup zip. The next step is to test import the secured backups using content-cli.Is there a best practice for this?Which content-cli commands are there to upload the assets (analyses, knowledge models, variables, and transformations)? We only know of commands for pushing data pools and packages.Is there a way to import the zipped backup directly? I look forward to your contributions!Best regards,Conny

Hi, can a horizontal scroll option be added to bar/area charts in Views?

Hi all, is it possible to make a dimension in a OLAP table static. So when I click on another dimension it does not affect the value?

Is it possible to transfer the from Sandbox to Prod Environment or One team to another team..?

Example: KPI_A: 0% (weight 1)KPI_B: 90% (weight 2)KPI_C: NULL (weight 1)-> Expected outcome: 60% (2*0,9+1*0)/3 KPI_A: 0% (weight 1)KPI_B: 90% (weight 2)KPI_C: 0%(weight 1)-> Expected outcome: 45% However all I came up with is:((KPI_A*1)+(KP_B*2)+(KPI_C*1))/4 which is resulting in NULL if any of the KPIs is NULL. I could sove is using extensive nested CASE WHENs catching every possible combination but that seems quite cumbersome and hard to read/maintain. Does anyone have a better appraoch or PQL function I am missing? 

Can you explain the main differences between using the FILTER_TO_NULL and not using it in a PU function. I see that the results differ for the following 2 functions:  PU_COUNT_DISTINCT (    Domain_Table("CEL_ACTIVITIES_CMS_COMBINED"."USER_NAME")   , FILTER_TO_NULL("CEL_ACTIVITIES_CMS_COMBINED"."CASE_ID")   , "Grouping_All"."QUERY GROUPING" = '<%= QueryGroup %>' )  And PU_COUNT_DISTINCT (    Domain_Table("CEL_ACTIVITIES_CMS_COMBINED"."USER_NAME")   , "CEL_ACTIVITIES_CMS_COMBINED"."CASE_ID"   , "Grouping_All"."QUERY GROUPING" = '<%= QueryGroup %>'  )     

Hello Everyone,  I am currently facing the problem that after uploading the ABAP reports for the P2P Connector in Celonis i cannot run the transformation.   basically in the training about the ABAP extractor, they advise to run the transformation after uploading the reports. However as soon as i execute the data job for the SAP P2P full transformations I get the following error message.   I have the feling that the JOB does not find the ABAP reports that i uploaded. or i am missing a step here :(  I appreciate a lot your help to solve this matter. Thank you in advance. Omar

Hello everyone, I'm still quite new to Process Mining and PQL.  How can I create the Column chart of the "Rework Selection" as a standalone component for the dashboard? In my process, there is a process flow (loop) that can occur either 0, 1, 2, 3, 4, or 5 times per case. Therefore, on the X-axis, the number of loops should be listed (0, 1, 2, 3, 4, 5), and on the Y-axis, the frequency of occurrence of each number of loops should be shown.  I tried it with this: https://docs.celonis.com/en/calculations-on-activity-sequences.html   And that works well for an OLAP table, but it only provides me with the count of loops per case and not the count of cases for each loop count (0,1,2,3,4,5). However, I cannot or do not know how to access this OLAP table in another component and sum up the counts per loop iteration. Thanks for your help! 😊

Hello, I would like to automate the entire user access process like adding / removing/editing users and then adding users to the user group assigned. Any thoughts or leads if any of you worked on it? Thanks in advance

Hello All,We want to setup a action flow to refresh 1 table from a data model. Is there any way to do it using action flow? Thanks in advance.

What I'm trying to do is apply a filter in a Query Data bubble based on a dynamic variable. The variable is defined in a view, then the Action Flow is called and the idea is to check for a greater value than the variable in the queried data.  I've tried Action Flow Inputs, but those don't seem to be the answer since the variable can only be updated manually once the AF starts. Also, the idea is to execute the AF from the view, which apparently removes the write-in option for the input leaving it always blank. Can this be done?

Hello everyone, this is probably very easy but I'm lacking the syntax that converts the number format. Can somebody please support me on this?Thank you!Best regardsJulia Bauer

Good morning! I want to do a filter like the picture (this are the filters used in Conformance Checking sheet in Celonis Free Plan, in this sheet I can't see the format of the filter or change nothing), I try replicate but I can't do it. Could somebody he