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.

  • 657 Topics
  • 1,660 Replies
655 Topics
T
Level 3
takayoshi.ichikLevel 3
asked in Process Analysis
Always display certain activity in Process Explorer

Hello. I want certain activities always displayed in Process Explorer. Im tackling web access log with Celonis. CVR (user ratio who apply to our service) on our website is lower than 1%, so conversion activity is very rare. When I want to see conversion activity in PE, I must adjust the slider of activity up to almost top. As you know, when I do that, the process view get complicated with other unwanted activities. I want to keep the slider of activity low with arbitrary activity always displayed. Is there any way to do that? Thanks.

20
T
Level 3
R
Level 3
robin.pianeLevel 3
asked in Process Analysis
Throughput time between activities followed directly

Dear all, How can we calculate a throuput time between 2 activities, but only when the activities are directly linked ? An example: I need to calculate the lead-time in orange. With this formula the result is not correct, because there is an other A2 activity later in the process (it could also happen that this additional A2 activity, not directly coming from A1 occurs before in the process) AVG(CASE WHEN (PROCESS EQUALS A1 TO A2) THEN CALC_THROUGHPUT(FIRST_OCCURRENCE[A1] TO LAST_OCCURRENCE[A2], REMAP_TIMESTAMPS("_CEL_ACTIVITIES_NC".EVENTTIME, HOURS)) ELSE NULL END) Thank you for your help, Best Regards Robin Celonis_Help.png87681 1.94 KB

50
P
Level 1
.
Level 3
.14600836Level 3
asked in Process Analysis
Automation rate

Hi all, were currently only considering user types to define which activities have been done automatically (batch user) and which have been processed manual (all other user types): 100.0*AVG(CASE WHEN _CEL_P2P_ACTIVITIES.USER_TYPE IN (<%=auto_user_type%>) THEN 1.0 ELSE 0.0 END) However, for our MRP runs which shall be also considered automated there is always a manual user in SAP. We can identify MRP runs by the doc type (EP) in combination with the PR creation indicator (B). Any suggestions how we can adjust above formula to also consider EP in combination with B as automated? Thanks Oli

60
.
Level 3
N
Level 3
naveen.guptaLevel 3
asked in Process Analysis
Througput time at header level

Dear All, We ahve a througput time caclulated as below CALC_THROUGHPUT(<%=from_occ%>_OCCURRENCE[<%=From%>] TO <%=to_occ%>_OCCURRENCE[<%=To%>], REMAP_TIMESTAMPS("_CEL_O2C_ACTIVITIES".EVENTTIME, <%=unit%>)) THis gives us througput time at line item level (Case key). How can I calculate the same at header level. Say at VBAK level. Thanks Naveen Gupta

30
B
Level 1
.
Level 3
.14600836Level 3
asked in Process Analysis
Amount of price change in Euro

Hi all, When analyzing price changes in Celonis I would like to show in our details tab the Euro amount of the actual price change per PO line. We are already using quite a sophisticated formula to show in a graph the price changes for different thresholds in percentage. I assume I can use this formula partially in order to show the Euro amount of the price change. Following part, I used to do that (which does not work yet): CASE WHEN ISNULL(PU_FIRST(EKPO,"_CEL_P2P_ACTIVITIES".ACTIVITY_EN, _CEL_P2P_ACTIVITIES.ACTIVITY_EN = Change Price)) = 1 THEN No Price Change Activity WHEN PU_FIRST(EKPO, _CEL_P2P_ACTIVITIES.CHANGED_FROM_FLOAT,"_CEL_P2P_ACTIVITIES".ACTIVITY_EN = Change Price) - PU_LAST(EKPO, _CEL_P2P_ACTIVITIES.CHANGED_TO_FLOAT,"_CEL_P2P_ACTIVITIES".ACTIVITY_EN = Change Price) END Any idea how to resolve? Thanks, Oli

20
.
Level 3
N
Level 3
naveen.guptaLevel 3
asked in Process Analysis
Saving my selection and coming back to it when I want to

We are looking for an option to save a selection like a variant. For e.g. Saving Sales Org, Division and Mateial groups selections as a variant. With the possibility to come back to that selection. Any suggestion, how to achieve that?

20
N
Level 3
R
Level 2
rakesh.paul11Level 2
asked in Process Analysis
Hyperlink Issue

Every time an analysis is transported from QA to PROD, old analysis is deleted and a new one is placed in the folder, as a result, the bookmarks are also deleted with transport. How we can get rid of this problem.

30
R
Level 2
.
Level 3
.14600836Level 3
asked in Process Analysis
Threshold values on PO line item amount

Hi all, were using threshold values based on PO header level in order to filter on low or high value items (e.g. below 100 or above 10k). The formula works on PO header level (EKKO table) but should be based on line item level (EKPO) - the formula looks as follows: CASE WHEN PU_SUM(EKKO,EKPO.NETWR_CONVERTED) >= 0 AND PU_SUM(EKKO,EKPO.NETWR_CONVERTED) <= 100 THEN a) 0 - 100 WHEN PU_SUM(EKKO,EKPO.NETWR_CONVERTED) > 100 AND PU_SUM(EKKO,EKPO.NETWR_CONVERTED) <= 500 THEN b) 100 - 500 WHEN PU_SUM(EKKO,EKPO.NETWR_CONVERTED) > 500 AND PU_SUM(EKKO,EKPO.NETWR_CONVERTED) <= 1000 THEN c) 500 - 1.000 WHEN PU_SUM(EKKO,EKPO.NETWR_CONVERTED) > 1000 AND PU_SUM(EKKO,EKPO.NETWR_CONVERTED) <= 10000 THEN d) 1.000 - 10.000 ELSE e) > 10.000 END I tried to exchange EKKO with EKPO to have PU_SUM(EKPO,EKPO.NETWR_CONVERTED) but that didnt work. Any suggestions how to change properly? Thanks, Oli

40
.
Level 3
M
Level 2
michael.johnsLevel 2
asked in Process Analysis
Measure Booking Process by Order Level

I need to measure the number of orders within the booking process: anything between Create Quotation and Create Sales Order Item. For background, the # of Sales Orders using COUNT_TABLE("VBAK") is 200k. Using either of the below formulas continues to give me 200k Sales Orders. I have also attempted it with/without many different component filters: COUNT(DISTINCT CASE WHEN "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" IN ('Create Quotation','Create Sales Order Item') THEN "VBAK"."MANDT" || "VBAK"."VBELN" ELSE NULL END) or COUNT (DISTINCT CASE WHEN (PU_COUNT("VBAK","_CEL_O2C_ACTIVITIES"."USER_TYPE","_CEL_O2C_ACTIVITIES"."USER_TYPE" LIKE '%' AND "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" IN ('Create Quotation','Create Sales Order Item')) = PU_COUNT("VBAK","_CEL_O2C_ACTIVITIES"."USER_TYPE"

00
D
Level 2
S
Level 3
stephanny.hartmLevel 3
asked in Process Analysis
Aligning X & Y Axis at Zero

Hi all, Im creating an Credit note analysis - taking that into consideration all the values of my documents are negative: this causes that my graphs when Im looking at values and quantities look funny since the value 0 is not the aligned as the crossing for the X axis and the primary and secondary Y axis. Is it possible to align the crossing of the X and both of the Y axis to 0? In this case, it will mean that the line will be above of the X axis, and all columns will be below. Thank you!

10
S
Level 3
L
Level 3
laura.lauraLevel 3
asked in Process Analysis
Count Table if request closed

Hi everyone, I would like to add a line with a count all requests with a closed date not null by month on my chart. image.png1215225 17.9 KB I tried with this formulation but it is not working: CASE WHEN name_table.closed_at <> NULL THEN COUNT_TABLE(name_table) ELSE 0 END

20
L
Level 3
L
Level 3
laura.lauraLevel 3
asked in Process Analysis
Count table closed request

Hi everyone, I would like to add a line with the number of the closed request opened in a month. image.png1215225 17.9 KB I tried with this CASE WHEN rm_enhancement.closed_at <> NULL THEN COUNT_TABLE(rm_enhancement) ELSE 0 END but it is not working. Someone had the same issue with a count with a case? Thanks

10
L
Level 3
M
Level 2
michael.johnsLevel 2
asked in Process Analysis
Donut Chart Legend Labels

I created a donut chart modeling the percentage of EDI Orders in VBAK (Dimension is VBAK.ZZEDI_FLAG) Currently it looks as such: Instead of the X featured at the bottom and to the left of 26%, would it be possible to have the label appear as EDI Orders. I tried "VBAK"."ZZEDI_FLAG" AS 'EDI', but that did not work. Any other options available? Thanks

20
D
Level 2
M
Level 2
michael.johnsLevel 2
asked in Process Analysis
Table Configuration Help, Numbers not adding up

Backround: I have produced an OLAP table with the following columns for an Order-to-Cash Dashboard analysis with SAP. image.png70368 2.16 KB The dimension column variable is currently: "VBAP"."MATKL" || ' - ' || "VBAP"."MATKL_TEXT". The formula for Sales Order KPI is: COUNT_TABLE("VBAK") The formula for the EDI Order KPI is:SUM(CASE WHEN "VBAK"."ZZEDI_FLAG" = 'X' THEN 1 ELSE 0 END) The formula for EDI % KPI is: KPI("Ratio", "VBAK"."ZZEDI_FLAG" = 'X') Issue: I have two number KPIs that display metrics for The # of EDI orders within the OTC process SUM(CASE WHEN "VBAK"."ZZEDI_FLAG" = 'X' THEN 1 ELSE 0 END), andThe # of Sales Orders COUNT_TABLE("VBAK") The count for these are around 50k and 200k respectively, as they should be. Yet in the OLAP Table, the sum of the rows in the column for EDI Orders is over 300k, and the column

00
B
Level 1
F
Level 3
francesca.licanLevel 3
asked in Process Analysis
Machine Performance: plan vs actual time. How to create a Pareto Chart

Hello Celonis Community, Celonis 4.5 I need to create a pareto chart showing the Delta hours (planned-actual) for each production phase (e.g. setup, production, breakdown,). Each phase can have different unique activities, for which Ive defined dedicated variables : The actual data are derived from the ACTIVITIES table. The Target data are located in another table: image.png827211 4.92 KB The two tables are not directly linked. The common parent table is the CASE table. image.png1609576 21.6 KB I use the component Column Chart and I add Dimension: KPI(Category), so defined CASE WHEN ACTIVITIES.ACTIVITY_EN IN (A,B,C) THEN Setup WHEN ACTIVITIES.ACTIVITY_EN IN (D,E,F) THEN Production WHEN ACTIVITIES.ACTIVITY_EN IN (G,H,I) THEN Dismantling WHEN ACTIVITIES.ACTIVITY_EN IN (L,M,N) THEN Breakdown ELSE NULL END KPI: CASE WHEN KPI(Category) = Setup THEN SUM(PU_SUM(CASES,PLANNED_TIME.Setup))- SUM(HOURS_BETWEEN(ACTIVITIES.START_TIME,ACTIVITIES.END_TIME)) WHEN KPI(Category) = Dismantling TH

30
B
Level 1
N
Level 3
naveen.guptaLevel 3
asked in Process Analysis
How to copy tabs from one analysis to another

How can I copy the full tab from one analysis and paste into another. Idea is to have power user create there analysis in seperate folders / analysis. Once it reaches a validated stage then to copy the whole tab and paste in Productive / published analysis. Doing component by component is erronus and time consuming. Thanks Naveen Gupta

40
N
Level 3
S
Level 3
stephanny.hartmLevel 3
asked in Process Analysis
Variable Formula shown as title

Hi all, Were using datepickers that are linked to a variable <%=date%> , which at the same time is being defined by different formulas. When looking at the title for the date picker, we have chose the text related to the variable <%=date%> The problem is that when the variable is being defined by a formula, and not a field in a table. this is also the case when we have graphs associated to the dates, in this case, the whole formula is displayed when the users hover over the graph we have tried to save the formula as a KPI, at least just to have the KPI name displayed, but in this case the variable will not be set, and the date picker will not work. Is there any way to avoid showing the whole formula as the title for these cases? Thank you for your help! image.png401673 20 KB image.png617572 36 KB

50
S
Level 3
.
Level 3
.14600836Level 3
asked in Process Analysis
Ratio KPI to show the ratio of eProcurement PO lines

Hi all, I would like to define a new KPI to measure the ratio of eProcurement (EP) orders vs. all other PO doc types. The doc type information comes from the PO header (EKKO), however Id like to show the ratio based on line item level (EKPO). The formula which Ive set-up and which works fine for the ratio on Header looks as follows: 100 * AVG(CASE WHEN EKKO.BSART = EP THEN 1.0 ELSE 0.0 END) Somehow, Ive to bring in one more variable to take line items into account: COUNT_TABLE(EKPO) Any idea how to combine to show the ratio of EP PO items? Thanks, Oli

40
.
Level 3
C
Level 2
chen.leiLevel 2
asked in Process Analysis
Decision Tree in Celonis

Hello Team, I noticed the decision tree function seems not available. Is it true or just the blue color didnt show? Best Regards, Chen Lei

50
C
Level 1
N
Level 3
neel.neelLevel 3
asked in Process Analysis
Need HELP: KPI for Touchless or Manual Intervention or Unknown

HelloI am trying to create a KPI called PO Touch Indicator that will allow me to have a Value of touchless, manual intervention, or unknown based on the activites and User Type per PO.When AT LEAST one UserType = - then unknownWhen ALL UserType = B then TouchlessWhen AT LEAST one UserType = A and rest are B or all are A then Manual interventionEx 1:PO: 12344232 // PO ITEM: 01 // Activity: 1 // UserType: A // KPI "PO Touch Indicator: unknownPO: 12344232 // PO ITEM: 01 // Activity: 2 // UserType: - // KPI "PO Touch Indicator: unknownPO: 12344232 // PO ITEM: 01 // Activity: 3 // UserType: B // KPI "PO Touch Indicator: unknownEx 2:PO: 12344232 // PO ITEM: 01 // Activity: 1 // UserType: B // KPI "PO Touch Indicator: touchlessPO: 12344232 // PO ITEM: 01 // Activity: 2 // UserType: B // KPI "PO Touch Indicator: touchlessPO: 12344232 // PO ITEM: 01 // Activity: 3 // UserType: B // KPI "PO Touch Indicator: touchlessEx 3:PO: 12344232 // PO ITEM: 01 // Activity: 1 //

60
B
Level 1
R
Level 2
rakesh.paul11Level 2
asked in Process Analysis
Custom Sorting of Dimension in Combo Column Chart

Hi Team, We want to make one Column Chart, where X-axis (Dimension) have a data point like (0-3 Days, 4-6 Days, 7-9 Days, 10-16 Days & 17+ Days) and KPI will have such as PO Lines Pending & PO Pending GR Amount. But the issue is sorting not working properly, its sorting randomly. Is there have a way to custom sort the Dimension. Regards, Rakesh Paul

100
V
Level 1
S
Level 3
sasan.babaz12Level 3
asked in Process Analysis
Creating a drop down Button for a specific table

Hello, I try to create a Button drop down component for just a specific table in my analysis. So when I filter with this button, just this specific table is effected. Can anyone help me how to implement this? Best Wishes Sasan

140
S
Level 3
marco.muenc
Level 3
marco.muencLevel 3
asked in Process Analysis
Reference Date view in analysis

Hi, in an Accounting use case we are looking for sales order items, where a goods issue was already booked but no invoice was created yet. That works fine with the process functions and shows always the cases where this situation is currently valid. My question: Is there a possibility to show also the situation at a reference date? So for example that you can display the amount and value of sales order items that have been in this so called ship to bill stock at 04/30/19? Thank you and best regards, Marco

00
marco.muenc
Level 3
S
Level 3
sarah.kraftLevel 3
asked in Process Analysis
Rounding error when dividing

Hello, I was trying to get the Median of a column. But no matter which way he calculates, he just gives me a rounded number. Even if I enter the numbers manually, the correct solution would be 4.54. Anyone have any idea what it is? Rundungsfehler2.png938969 33.4 KB Rundungsfehler.png873927 50.9 KB Thank you in advance

30
S
Level 3
S
Level 3
sarah.kraftLevel 3
asked in Process Analysis
Ignoring the troughput Time of a specific activity

Hello everybody, Im struggeling with the analysis for my thesis of an ITSM process and hope there is a simple solution, which I just overlook. Explanation: A service ticket is considered as solved in RESOLVED status, the status automatically changes to CLOSED status after 10 days, in any way. So, what can I do to deposit in ALL analyses that these 10 days do not flow into the troughput time never? DLZ.jpg848958 62.5 KB Thank you very much in advance

70
S
Level 3

Badge Winners

VIEW ALL
Community Code of Conduct