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.

  • 645 Topics
  • 1,633 Replies
643 Topics
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

40
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

90
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 2
marco.muencLevel 2
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 2
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
.
Level 3
.14600836Level 3
asked in Process Analysis
Date picker - conditional formatting

Hi all, We use the date picker quite frequently in our dashboards; however since we are still loading data manually it is quite important for our users to see what the most current data available is. The date picker already formats the days until data is available dark grey whereas the color is light grey for dates where no data was loaded. Unfortunately, we have different countries with different data sets available (e.g. Data for Germany might be loaded until 15th of March 2019 whilst Bulgaria is available until 1st of April 2019). The date picker shows, in this case, per default always every day until 1st of April 2019 in dark grey, even when the user selects Germany (data only available until 15th of March). In order to not confuse users which date is the most current available data set Id like to add a color coding based on the selection of the country (so that when selecting Germany the last dark grey date is the 15th of March 2019). Any ideas how to do that? And, if not possible

10
.
Level 3
D
Level 2
david.karweLevel 2
asked in Process Analysis
Chaining PQL Queries

Hi Celonis Community, Ive recently started working in PM and am faced with my first real challenges. To answer complex questions of the process owner I would need to execute more complex calculations in Celonis. Im unsure to which extent this is supported. Ive read through the functions documented in the help section and functions highlighted here but could not find any that provide what Im looking for. Is it possible to base a calculation in Celonis on a previously calculated column? An equivalent of what Im trying to achieve might be subqueries in SQL. Im unable to go give insight into the process and will provide a much simplified example. My activity table looks like this: grafik.png886138 2.98 KB Based on this I can calculate a new table with the automation rate per CASE In the following I want to use the calculated column, to base further calculations on it. Like: OR I hope this is understandable enough. Im also positive, that there might be an easier way to achieve this,

10
D
Level 2
.
Level 4
.14600775Level 4
asked in Process Analysis
OLAP table presentation

Hello, I am building a OLAP table. I was wondering if there was a way to re-structure the table so instead of the single KPI information flowing vertical, it can flow horizontal? I have thought about using a pivot table, however because the data set is so large, it does not seem to be a suitable option. Please let me know. Cheers, Anna

20
V
Level 1
V
Level 3
vaclav.juren12Level 3
asked in Process Analysis
RCALL or RAGG in Celonis

Hello, can someone please tell me how to put R code in Celonis? It is working in RStudio, but when I put it in RCALL or RAGG it gives me errors I do not understand. Can someone please explain to me how exactly RCALL or RAGG works? Thanks Vaclav Juren

00
D
Level 2
C
Level 2
carlo.ruggiLevel 2
asked in Process Analysis
Activity Selection in PQL Syntax

Hello, I don`t know what is the correct PQL Syntax for this Activity Selection for my KPI Component option (see screenshot). Thanks in advance for your responses :o)) image.png1061476 22.5 KB

50
C
Level 2

Badge Winners

  • Qualified to Build Views
    ebru.ulashas earned the badge Qualified to Build Views
  • Qualified to Build Views
    irem.dinçhas earned the badge Qualified to Build Views
  • First Post
    Akshay Hhas earned the badge First Post
  • First Post
    Damianhas earned the badge First Post
  • Qualified to Deliver Business Value with Celonis
    Graham Holmeshas earned the badge Qualified to Deliver Business Value with Celonis
VIEW ALL
Community Code of Conduct