Product Q&A

Dear all, trying to establish intelligent automation by and therefore looking for Integration options between Celonis and... Blue Prism Axon Ivy Power Platform Symbio GB-Tec SMAP One LUIS Cognigy AI Any ideas, connectors or Workarounds?

I understand, that I can't use the t("xyz") notation in PQL - neither directly nor as parameter - because it's YAML. But I must assume that there is a way, because of the first sentence after the note in the documentation: Analysts can enable App Translations and provide a translation Map for user-generated content like Knowledge Models, Views, etc. This feature is a Package setting, and changes are available when published.https://docs.celonis.com/en/translating-studio-apps.html

Dear Community,  does anyone have any idea on how to create a chart in a view with running sum logic, that means for: January 24: i would like to display the sum of purchase order value of the last 12 months from Jan 23 till end December 23 February 24: the sum of purchase order value (for example) from February 23 till end january 24 March 24: the sum of purchase order value ((for example) from March 23 till end February 24 and so on for the coming months. I can imagine that i have to build the logic in the KPI itself. Furthermore, i would like also to create a chart in a view with YTD Logic: January 24: Data, like purchase order value, just from January 24February 24: Sum of purchase order value of January & February 24March 24: Sum of purchase order value of January & February & March 24...... Thank you so much!

Hi all, I just found this cool functionality in a try celonis case and would like to know how I can show and hide this filter bar. Do you know how to do this? Unfortunately this try celonis case does not show the studio area. Thanks and best regards,Sarina

When I save PQL formulas in the new Studio, they are not assigned to a record as an attribute in the Knowledge Model, but each time as a KPI.  Again, custom records and attributes are not displayed for selection in the new Studio. 

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! 😊