Skip to main content

Process Analysis

In the Process Analysis topic, you can ask questions and start discussions about systematically examining workflows to identify inefficiencies, capture value opportunities, and get recommendations for improvements using Process Mining and AI.

  • 667 Topics
  • 1,678 Replies
667 Topics
C
Level 3
cristian.cristLevel 3
asked in Process Analysis
Write the results of KPI to a variable

Dears, We have created a list of KPIs that are visualized in a world map. The user select using the buttons the KPI they are interested and the map is updated accordingly. (screen 1) Tolerances are setup manually, using variable assignments (screen 2) Our problem is that we want to Generate dynamic thresholds based on KPIs results. For example, the result of the select KPI for all records is 0.513% and I would like to use this value to set it up as the upper tolerance, when user selects Automatic Thresholds , I tried different ways but I always get the variables place holders are writing using Text and not with the value of the KPI. (Screen 3) Is it possible to write the results of KPI to a variable? 11581611 236 KB 21475594 97.3 KB 31342577 96.8 KB Thanks in advance, Cristian

32
C
Level 3
.
Level 2
.14600820Level 2
asked in Process Analysis
How to enable Master data actvities in IBC. for ECC transformation to S/4 HANA?

Continuing the discussion from Master data analysis: Can you please send me the documentation about how to enable Master data actvities in IBC.? Scenario: I am from SAP America and customer already bought Celonis licence and we are trying to leverage Celonis for Master data convergence from 14 SAP ECC/ERP into a single ECC with SAP Master Data Governance tool for Master data Maintenance .

11
V
Level 1
.
Level 2
.14600823Level 2
asked in Process Analysis
Custom KPI/Dimension Name in OLAP Table/Column Chart

Hi dears, I am not really sure how to custom field name in OLAP table. I guess its syntax maybe likes activity name >= 100 as Custom field name But I could not find a correct syntax to achieve this. Could anyone give me some examples? Thanks a lot. Louis

52
.
Level 2
L
Level 3
laura.lauraLevel 3
asked in Process Analysis
Filter component count

Hello everyone, I would like to filter a table where COUNT(ACTIVITIES) >=5 but the filter load give me errore. I also tried directly in the KPI : CASE WHEN COUNT(INCIDENT_ACTIVITIES.ACTIVITY_EN) >=5 THEN COUNT(INCIDENT_ACTIVITIES.ACTIVITY_EN) ELSE NULL END But in the table I have the line with NULL I do not want. Thanks Laura

33
J
Level 1
C
Level 3
cristian.cristLevel 3
asked in Process Analysis
Use Variable as Column Header

Dears, Is it possible to use a variable to as a column header? In the example below , Variable Visualization_KRI_Main_title , contains the name of the selected KPI (i.e. Ratio of XXX) , we want to use this variable as a header. screen1076720 64.7 KB Can you please advise? Thanks!

81
J
Level 1
.
Level 3
.14600898Level 3
asked in Process Analysis
Temporal Dimension for KPIs like Change Rate, Automation Rate etc

Hi together, I have a general question regarding your approach for the temporal dimension of KPIs. If you take for example in the O2C process the SO Creation Date as dimension for the automation rate the KPI will change retroactive because over time there will be more and more activities for a sales order. This makes it really complicated to report those numbers. Same applies for the change rate. Due to that fact we applied for some KPIs a background filter which filters on orders which are finished for example where there goods are already shipped. Doing that you wont have the problem with retroactive changes over time but your KPIs might differ from some KPIs you can show for example in the process explorer. What are your thoghts on that? Do you have any recommendations? Best regards Friedemann

71
B
Level 2
R
Level 2
ren.renLevel 2
asked in Process Analysis
Formula on double posting of invoice

Hello, I struggle with a the creation of a formula to determine double postings. (in this cases potential double vendor invoices posted.) My check is to see all case ID (invoice items) with the same invoice reference field (text field) and the same amount. Out put of the formula should be number of cases where this duplication appears. Anyone who has an idea how to create such a formula? Thanks! Kind regards, Ren

03
R
Level 2
L
Level 3
laura.lauraLevel 3
asked in Process Analysis
Difference / number of days between 2 dates

Hi all, I would like to know the day between 2 dates but using the PQL DAYS_BETWEEN it is not working. I need to know how many day passed between a creation of anagrafic vendor (LFA1.ERDAT) and creation PO (EKKO.AEDAT), an between creation of anagrafic vendor (LFA1.ERDAT) and invoice (RBKP.CPUDT). Thank you Laura

134
L
Level 3
P
Level 4
paul.velthLevel 4
asked in Process Analysis
Conformance Checker Gateway parallel symbel

Hello, I see that the mine process for the conformance checker can create the Parallel symbol. If I create the process from scratch, I do not see how to add such a parallel symbol. Any help is appreciated :). image61513 2.47 KB

91
D
Level 2
L
Level 3
laura.lauraLevel 3
asked in Process Analysis
Change Price/Quantity

Hi everyone, My client would like to know if the change price or quantity is less or greater than the previous value indicated in the order. The issue is that Change_from and Change_to in the Activities table is an int value and not a number. What formula can I use knowing that > and < can not work? Thank you Laura

412
D
Level 2
S
Level 1
sebastian.seidlLevel 1
asked in Process Analysis
Comparing 2 Table Contents

Hi, I want to Display the Number of Cases that exist in the Cases Table but not in another Table. Celonis_Table_Comparison847184 2.24 KB For example with the data shown in the picture I want to show 2 since Cases 4 and 5 exist in the Cases Table but not in Table 2. Currently my problem is that when I count the total entries of both tables in separate single KPI fields they show the Correct Values: COUNT (DISTINCT (CASES.ID) = 5 and COUNT (DISTINCT (TABLE_2.ID)) = 3 But as soon as I combine both formulas to get the difference as: COUNT (DISTINCT (CASES.ID) - COUNT (DISTINCT (TABLE .ID)) It returns 0 which of course isnt correct as I would expect to get 2 (5 - 3). After some trying I noticed that when I add both values it returns 6 so it seems that the value for the total amount of cases changes from 5 to 3 which also explains the 0 it returns when subtracting. In the Data Modell Cases.ID is connected with Table_2.ID I have also tried solving it with a Case When Statement. COUNT (DISTI

41
D
Level 2
M
Level 3
mara.aderm11Level 3
asked in Process Analysis
Using DAYS_BETWEEN in a Case When statement

Hi all, I want to set a value based on different conditions. If I do Median( case when Eventlog_casestates_GDP_csv.CASE_STATE = running then case when (<%= Durchlaufzeit_Median %> > DAYS_BETWEEN(PU_FIRST(Eventlog_cases_GDP_csv, Eventlog_activities_GDP_csv.TIMESTAMP),TODAY())) then <%= Durchlaufzeit_Median %> else NULL end else CALC_THROUGHPUT(ALL_OCCURRENCE[Process Start] TO ALL_OCCURRENCE[Process End], REMAP_TIMESTAMPS(Eventlog_activities_GDP_csv.TIMESTAMP, DAYS)) end) but actually I want to set the days between as well. So if I do Median( case when Eventlog_casestates_GDP_csv.CASE_STATE = running then case when (<%= Durchlaufzeit_Median %> > DAYS_BETWEEN(PU_FIRST(Eventlog_cases_GDP_csv, Eventlog_activities_GDP_csv.TIMESTAMP),TODAY())) then <%= Durchlaufzeit_Median %> else DAYS_BETWEEN(PU_FIRST(Eventlog_cases_GDP_csv, Eventlog_activities_GDP_csv.TIMESTAMP),TODAY()) end else CALC_THROUGHPUT(ALL_OCCURRENCE[Process Start] TO ALL_OCCURRENCE[Process End], REMA

292
M
Level 3
steven.bernd
Level 3
steven.berndLevel 3
asked in Process Analysis
Filter the Eventtime from the activity I am looking for

Hey @all, I need a filter that looks at the event time of the activity I am looking for. With this filter I can determine my KPI worklist. At the moment i have a filter, but the wrong filter. For Example. image984209 7.49 KB In this picture we can see my Celonis activity table. (ID activity timestemp) In my other table AUFK I have the column ERDAT in which i can see the start date of my order -->(28.Feb.2019 07:51:48) My actually FILTER YEAR(AUFK.ERDAT) = Year(Today()) keeps the Start date of my ID 6254008060 with the activity Erffnet. But I need the timestemp Technisch abgeschlossen for my filter. > FILTER YEAR("timestemp from technisch abgeschlossen) = Year(Today()) On this example the Year is the same, but I have enough IDs where the start Date ist in 2018 and the activitity technisch abgeschlossen is in 2019. That means I could get rid of AUFK.ERDAT and use directly the timestamp of my activity table. But I dont know the Function. Pls can u help me.

12
steven.bernd
Level 3
J
Level 3
jonas.westeLevel 3
asked in Process Analysis
Filter for Cases which flow through a certain activity

Hi Celonis Community, I am currently analysing a P2P process where some orders have just been created, but not been ordered. These orders still have monetary values assigned to them in the Casetable. If I now add up the values to get how much money was spent e.g. on a certain article, these values distort my results, as they are also accounted for, but have not been ordered. Is there a way to restrict e.g. a certain table or sheet or the whole analysis to only values which run through the process step invoice received to only add up cases which have actually been ordered? E.g. with the Component-, Sheet- or Analysis-Filters? Thanks a lot. Best regards Jonas

121
J
Level 1
A
Level 2
ajay.guptaLevel 2
asked in Process Analysis
OLAP Table Row exclude

Hi Team, 1-In OLAP TABLE how to Add Grand Total Row with sum of Numeric value. 2- Let Say in Table - I have 5 Rows , and want to exclude 1 Rows . 1- A - 10 2-B -20 3-C-30 4-D-40 5-Null -50 I want Show olap table as below 1- A - 10 2-B -20 3-C-30 4-D-40 Total - 100

82
A
Level 2
benedikt.burgs11
Level 2
benedikt.burgs11Level 2
asked in Process Analysis
Access current selections in selection bar

Hi everyone, is there a way in IBC to access the current selections displayed in the selection bar via a variable, etc? Wed like to list current selections for example in text components. Best, Benedikt

01
J
Level 1
P
Level 4
paul.velthLevel 4
asked in Process Analysis
Matching percentage when combining tables

We have a question in regards to matching percentages when combining two tables with a one to many relationship. Fig 1. Tables one to many relationship When performing a count on the keys used for joining, we get the correct counts when using two number components. For example: Number Component 1: COUNT( TableA."_case_key") Number Component 2: COUNT( TableB."_case_key") However, when we combine the counts in a single component, and divide them by each other, then we receive the wrong count. So the component 3 is wrong: Number Component 3: COUNT( TableA."_case_key")/COUNT( TableB."_case_key") We suspect the error might be lying in the way the tables are joined. Please guide us in finding a solution, to get the right division.

01
M
Level 1
J
Level 3
jonas.westeLevel 3
asked in Process Analysis
Case Count displays wrong values

Dear Celonis Community, I have a problem with the Casecount of certain items. Attached you find my data-model where I have linked the Casetable to the Masterdata Tables (Articles, Adresses, Projects and Shipments) and the Activitytable. If I now display the Casecount for different features (see file Problem Casecount Article- and Adress-Table), the Casecount is displayed as having a lot of missing data for the Article related features (left third of the Screenshot) and also for Adress related features (right third of the Screenshot). For the Project related Features it works perfectly fine (central third), but all of these three Tables are linked in the same way to the datamodel via a Foreign Key, which is a number, but which I have declared as being a String-Variable, as I do not need to calculate values for these columns. Can you help me find out, where the wrong values for the Article related or Adress related features come from? Thanks a lot and best regards Jonas Data Modell1920

010
J
Level 3
.
Level 2
.14600800Level 2
asked in Process Analysis
I am new in process mining , i need help in one of pql

i have list of activities in my workflow and i want to write the pql for finding list of activities where avg throughput time is more than 1 day. let say the activity A and B has avg throughput time is 1 day and for Activity B and C is more than 1 day. so it should show activity B and C as per pql with their case id

07
D
Level 2
P
Level 4
paul.velthLevel 4
asked in Process Analysis
Aggregation filter for a table with a dimension

Hello, I have a question on how to filter a table with a dimension, and a aggregation. For example I have a olap table with: Dimension A | Count(Dimension) abc | 5 cde | 10 Now I would like to create a filter on top of this olap table and filter out everything that has a count of the dimension lower than 6. From the documentation regarding filtering I understand that I filter will not work, in this post I am looking for an alternative. https://zalando.eu-1.celonis.cloud/help/display/CIBC/FILTER I would appreciate any help on how to do this. Best, Paul

76
D
Level 2
M
Level 2
michael.bergeLevel 2
asked in Process Analysis
Detect loops followed by a specific activity

Hello to everyone who reads this! I think the solution of my problem could be pretty easy, but I dont get it I need to search for loops of each activity in my analysis which are directly followed by an specific activity. Every activity can loop and every activity can be directly followed by the specific activity. Basically the soltion should be something like this: FILTER MATCH_PROCESS_REGEX (Table1.ACTIVITY, variable >> variable+ >> XXX $ ) = 1 An activity (no matter if it is the first activity in the case or not) is followed by one or more occurrences of the same activity and is directly leading to the specific activity XXX. Yes: A - A - XXX Yes: A - A - XXX Yes: A - B - C - C - C - C - XXX Yes: V - W - P - P - P - XXX No: D - D - E - XXX No: F - G - F - G - XXX My problem is, I dont know how to insert a variable or something similar into this formula which is checking each activity in the analysis not only the hard coded one. It would be great to see the number of occur

55
M
Level 2
.
Level 3
.14600906Level 3
asked in Process Analysis
Throughput Average in year (process explorer view)

Is there any way we can calculate average throughput time in the process explorer between activities in YEAR or MONTH I tried creating custom KPI but couldnt go through. Thanks in adv. -Amogh

12
.
Level 3
thorsten.schne
Level 3
thorsten.schneLevel 3
asked in Process Analysis
OLAP Table - Throughput Time between Activities

Hi everyone, I am looking for an OLAP table which can show multiple KPIs (MODUS, MEAN, TRIMMED MEAN, QUANTILE) of the throughput time between activities. The business use case is to have a comprehensive overview of the real throughput time from Celonis in order to compare these values with the current master data settings in the operating system. Celonis - OLAP Table743229 38.2 KB The first row is showing the overall throughput time of the process from the first activity (A) to the last activity (D) (e.g. from customer order is received until product arrived at the customer. In the rows below I want to check the throughput time of the individual process steps. For example, activity A (start pick&pack) to activity B (complete pick&pack)) Question 1: How can I show in the first columns the two activities I am interested in? Question 2: In addition, how can I add an individual line like illustrated as Bottom Up SUM Question 2: How can the MODUS be calculated? There is no PQL fun

51
J
Level 1
S
Level 2
steven.knoblLevel 2
asked in Process Analysis
Scatter Plot / KPIs in both axis

Hi, Im currently looking for a way to create a scatter plot where both axis are representing a KPI. If I do this, only one point is shown, but I want to represent all customer as a point. Is there a way to get this done. Best regards Steven

12
S
Level 2
neil.whita
Level 3
neil.whitaLevel 3
asked in Process Analysis
How to Clear Selections in CPM 4.5

Hi, I have a query relating to saved formula / dropdowns that are derived (i.e. using a CASE WHEN for example). I have an analysis where the dropdown has required updating but when published the updated logic is only applied when the dropdown is reapplied which makes sense. However, this also means that if the selection is made and the user reopens the analysis after the change is made that the view will not show the updated logic unless they manually clear and reapply the selection from the dropdown. A feature that used to exist prior to Celonis 4.5 where Selections could be cleared on opening an analysis either using the Analysis / Tab Load Script Clear Selections;. This forced users to apply filters. This would allow me to ensure that users are always making selections from the latest logic and not just viewing old selections that have not been updated. Despite the help pages suggesting this is possible Help Pages the error message Select is not supported anymore. Use Filter instea

65
D
Level 2

Badge Winners

  • Qualified to Create and Deliver Demos
    miguel.ferna11has earned the badge Qualified to Create and Deliver Demos
  • Qualified to Manage Change and Scale Adoption
    miguel.ferna11has earned the badge Qualified to Manage Change and Scale Adoption
  • Qualified to Manage Implementation Projects
    miguel.ferna11has earned the badge Qualified to Manage Implementation Projects
  • Qualified to Get Data Into Celonis
    syota.aoyaghas earned the badge Qualified to Get Data Into Celonis
  • Qualified to Write PQL Queries
    syota.aoyaghas earned the badge Qualified to Write PQL Queries
VIEW ALL
Community Code of Conduct