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.

  • 581 Topics
  • 1,555 Replies
579 Topics
J
Level 3
jonas.schei11Level 3
asked in Process Analysis
Sorting calendar week

Hello all, how is it possible that the combination of calendar week and year is sorted correctly on my timeline? Starting with 1-2019, 2-2019, 3-201944-2019, 45-2019 image1338212 24.1 KB Many thanks! Best regards, Jonas

00
J
Level 3
maximilian.hoffm13
Level 3
maximilian.hoffm13Level 3
asked in Process Analysis
Normalize calculation result in table based on another value?

Dear fellow process miners, Im currently struggling implementing a normalization of a result in a table. It seems to be impossible to achieve that an OLAP table in Celonis. Heres my problem: Every case has a list of 0 to N events that affect the duration of the case. Its a simple parent-child relationship in the data model. If no event happened to a case, there will be no record in the child table. Now I created a simple OLAP table with the event category (event.category) as dimension. My two KPI columns so far are The number of events of that category as COUNT(DISTINCT event.key) The sum of delay in the process, caused by that event as SUM(event.delay). Now, I want to normalize the delay to 100 total cases. Say, I have 15 events, causing 15 minutes of delay. In total, I have 250 cases. What Im trying to achieve is the following simple formula: (SUM(delay)/Total number of cases)*100, which should be (15/250)*100 = 6. However, this seems to be impossible to achieve in Celonis as GLOBAL(

70
D
Level 2
C
Level 3
carina.carin11Level 3
asked in Process Analysis
Order to Cash - Formula for selection of customers ordering via a defined order channel

Hi there, I work on an analysis to monitor, which sales order channel our customers use. Therefor I need a button for each order channel, where a viewer can select all customers ordering e.g. via EDI at on click. So the Viewer can analyse all customers with the possibility of ordering via EDI and can identify which other order channel those customers use. At the moment, the viewer has to select via a filter order channel EDI, then select all customers and remove the EDI filter, because otherwise the viewer can see only sales order items received via EDI. Can someone help me with the formula please? Best regards, Carina

40
maximilian.hoffm13
Level 3
J
Level 3
jeroen.jeroeLevel 3
asked in Process Analysis
No common parent for calculating time difference

Hi all, Currently we are doing an analysis on late Goods Receipt (i.e. Invoice receipt happens before Goods receipt). This is done based on the data model below: image.png1032482 32.3 KB However, now we got stuck on the issue how to calculate the time difference between the goods receipt and the invoice receipt. Using DATEDIFF(dd, MSEG.BUDAT_MKPF, RBKP.BUDAT) results in the error that these tables do not have a common parent in the schema. Any ideas on how to link these fields and calculate the delta in days? Thanks!

10
T
Level 3
.
Level 2
.14600809Level 2
asked in Process Analysis
Grouping invoice values as dimension

Dear Celonis community, I wonder if you have an idea how to approach the following question: we want to define an approval limit for vendor invoices.to visualize the current distribution of invoices, we show the invoice numbers and aggregated values by grouped invoice value (as in the following bar chart prepared in MS Excel). Invoice_Value_Grouping.png1130744 35.3 KB Now, we would like to replicate this or a similar view in Celonis directly. Unfortunately, I cannot identify a standard Celonis functionality to group invoice values into n clusters as dimension. (The existing bucketing function is not flexible enough.) Question: did anyone already face a similar question and can share a way how to approach this? Any input would be much appreciated. Thanks, Jochen

00
C
Level 1
N
Level 3
naveen.guptaLevel 3
asked in Process Analysis
Filter on current status or Activity

Dear Team, We are trying to create a dashboard with different KPIs. We have a scenario that we would like to filter in cuirrent status of the order. When we try to use Case ends with then there could be still some activites happening after that status and thus we dont see the results. Also, we would like to filter as an OR condition on multiple activities. FILTER MATCH_ACTIVITIES ( _CEL_O2C_ACTIVITIES.ACTIVITY_EN, NODE_ANY [ CRM Order: Released, CRM Order: Open, CRM Order: In process ] ) = 1; FILTER MATCH_ACTIVITIES ( _CEL_O2C_ACTIVITIES.ACTIVITY_EN, NODE [ CRM Order Item: Contains Errors ] ) = 1; FILTER CRMD_ORDERADM_H.PROCESS_TYPE in (ZTA, ZFD); In nut shell we want all the orders which are in Open, In process or released and contains error for certain process types. We are missing on how to apply filter on activities? Can someone help here? Thanks Naveen Gupta

20
C
Level 1
A
Anonymous
asked in Process Analysis
Throughput times in process overview does not work

Dear all, I would like to measure throughput time between arbitrary two activities. I tried to use standard Process Overview sheet, but it does not work. Below screen is sample of demo environment. I believe I can see histogram of throughput time in the red rectangle area. Is there something tips to use it ? .png1594563 28.6 KB Best regards, Kazuhiko

00
A
J
Level 3
jeroen.jeroeLevel 3
asked in Process Analysis
PU_Sum; aggregation over Sales Order

Hi All, As example reflecting only 1 specific SO, we currently have the following situation: All deliveries/billings from SO line items 10, 20 and 30 have a date in Q1 or Q2, whereas the date of the delivery/billing related to SO line item 40 is in Q3. Only Q1 and Q2 data is loaded in Celonis, so the delivery/billing related to item 40 is not yet loaded. Now wed like to calculate the total billed quantity for this specific Sales Order. As expected, PU_SUM(VBAP, _CEL_O2C_CASES.INVOICE_QTY) returns 40000, 40000 and 31600 for so lines 10, 20 and 30 respectively. However, if we want to aggregate over SO instead of SO line item and use PU_SUM(VBAK, _CEL_O2C_CASES.INVOICE_QTY), it returns 120000 whereas we only expect 111600. Any idea whats causing this sum of 120000 and how it can be solved to show the aggregation on SO level of only the loaded delivery/billing documents? Thanks

10
.
Level 3
M
Level 2
mehdi.bougaLevel 2
asked in Process Analysis
Load Script - with Variable

Hi All I would like to limit the scope of an anylsis by filtering some company codes in a load script. I have create a variable as text replacement in which I have put the list of company code: Variable Name= ShopCC TexT/Replacement= CH01,IT13,FR02,FR08 the load script is FILTER EKPO.BUKRS IN (<%=ShopCCode%>); Unfortunaltly I get an error saying that there iwas a syntax error in the load script. Any Idea please ? thank you

40
D
Level 2
J
Level 2
john.sekutLevel 2
asked in Process Analysis
Floating 90 day date range for a KPI card

In a KPI card, I would like to display only the activities that occurred for that KPI for the last 90 days. I know the below is incorrect but logically it is as close as I can get without help. FILTER _CEL_P2P_ACTIVITIES.EVENTTIME BETWEEN TODAY() AND (TODAY() - 90) The KPI card works so I am looking for the code to tack onto to get the 90 day window. Please advise! Thanks.

20
D
Level 2
R
Level 3
robin.pianeLevel 3
asked in Process Analysis
Stacked bar chart

Hello, Is it possible to create a stacked bar chart with Celonis ? Thank you for your help, Regards Robin

190
B
Level 2
P
Level 2
patrick.flößLevel 2
asked in Process Analysis
Error in Table while PQL Editor Preview shows results

Hello all, In the PQL Editor an output of my formula is shown in the preview. If I then go to Done and want to look at the table, I get the following error message could not find referenced aggregate COUNT(DISTINCT ). Can anyone help me? I use the PQL formula: KMEANS() in its complex form. Best Regards, Patrick 01 Preview.jpg2156449 64 KB 02 result.jpg1383276 20.7 KB

20
P
Level 2
N
Level 3
naveen.guptaLevel 3
asked in Process Analysis
Not able to edit any out of box Analysis

We are not able to edit any out of box analysis like Conformance checker, Social Analysis etc. We would like to use some of the components / formulas from these analysis into our single analysis for the users. How can we achieve the same?

20
N
Level 3
J
Level 2
john.sekutLevel 2
asked in Process Analysis
Opening a document with a button within an analysis

I would like to open a reference document contained in the File Upload Center using a button. I cannot figure out what the Document ID is though. Any variation of ID that I enter results in a 404 error. Where must/can the document be stored for accessing? (I assume its in the file upload of the Event Collection)Where do I find the Document ID?Please advise if I am way off and there is a cleaner way to do this. Thanks!

20
C
Level 1
.
Level 3
.14600836Level 3
asked in Process Analysis
Segregation of Duties

Hi all, We are using a dedicated Segregation of Duties dashboard to analyze cases where two activities are processed by the same person (e.g. Creation of PO and Releasing the PO). In this dashboard, the viewer selects two activities, which shall not be performed by the same user to see in how many cases there is a violation. See here the PQL statement: avg (case when PU_first(EKPO,"_CEL_P2P_ACTIVITIES".USER_NAME, _CEL_P2P_ACTIVITIES.ACTIVITY_EN = <%=From%> AND _CEL_P2P_ACTIVITIES.USER_TYPE <> B) = PU_first(EKPO,"_CEL_P2P_ACTIVITIES".USER_NAME, _CEL_P2P_ACTIVITIES.ACTIVITY_EN = <%=To%>) then 1.0 else 0.0 end) * 100 By checking the violations in detail, Ive recognized that there are cases where Person A creates a PO, Person B approves the PO and afterwards Person A changes some field in the PO (e.g. Net Order Price). Due to this change, the release indicator is AUTOMATICALLY changed from B (release) to R (not released). This case is shown as a viola

60
.
Level 3
.
Level 2
.14600772Level 2
asked in Process Analysis
Celonis mobile view

Hello Celonis Team, is it possible to use celonis on iphone or ipad? Could you give me some information about the mobile view from celonis. Many thanks

100
C
Level 1
L
Level 3
laura.lauraLevel 3
asked in Process Analysis
Differents currency in “units”

Hi, I would not use VBAP.NETWR_CONVERTED and have the Net Value Order in the Document Currency. When I insert as KPI VBAP. NEWTR, I would like to insert in Units the Document Currency. I tried with: VBAP.WAERS<%=VBAP.WAERS%>a variable : VBAP.WAERSa variable : {VBAP.WAERS } But it is not working. Any idea ? Thank you

00
L
Level 3
L
Level 3
laura.lauraLevel 3
asked in Process Analysis
Count Variants by company code

Hello, I would like to create a table with a count of variants by Company Code but when I use the standard KPI Number of process variants, the number not corresponding to the total I have on the Variant Explorer. Is it exist a simple formule to count the variants? Thank you

00
L
Level 3
R
Level 2
rakesh.paul12Level 2
asked in Process Analysis
Process Mining for Application monitoring tools

Hi All, Do we have any use cases for Application Monitoring tools such as Dynatrace. Can we get a process-level view with metrics of applications to see which application/interface is down because of which the process has stopped ( in real-time ). Regards, Rakesh Paul

00
V
Level 1
T
Level 3
thomas.nagel11Level 3
asked in Process Analysis
Calculation of average cases per user in a number component

Hello, I am trying to calculate the average number of posted invoices per user in a number component in the AP data model. The basic code of the KPI looks as follows: COUNT(BKPF.USNAM) / COUNT(DISTINCT(BKPF.USNAM)) The current KPI however does not yet show the real performace of the AP department because many invoices are posted via batch files or batch users and some invoices are posted by users that are doing an internship or an apprencticeship and these users do not post more than for example 100 invoices. In order to get rid of the cases which were posted by batch users, I used a component filter which works fine. But for the second issue (exclusion of cases which were posted by users that have not posted more than 100 invoices in the selected time range) I have not yet found a solution. I have tried several case when statements and also worked with ABC clusters to exclude the cases of these users, but nothing worked. Does anybody of you have an idea how this could be solved? I am

00
T
Level 3
J
Level 2
jelmer.bodeLevel 2
asked in Process Analysis
Graph - Changing activity at certain date

Hi all, We have implemented a new system, which has different activities names. I would like to have one graph, where the graph shows the data from one activity, and after a certain date (01-09-2019 (dd-mm-yyyy)) from an other activity. Using now the following formula in two different graphs, but I would like to combine them. AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[Ontvang Factuur] TO LAST_OCCURRENCE[Valideren Factuur], REMAP_TIMESTAMPS(XXCEL_AP_ACTIVITIES.EVENTTIME, HOURS))) AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[XXAIMG: Ontvangen in APRO Imaging] TO LAST_OCCURRENCE[Valideren Factuur], REMAP_TIMESTAMPS(XXCEL_AP_ACTIVITIES.EVENTTIME, HOURS))) Is this possible? Hope you can help me. Kind regards, Jelmer

00
J
Level 2
M
Level 2
maximilian.heilmLevel 2
asked in Process Analysis
Dimension combining calendar week and year

Hello all, I wonder if there is a way of combining the CALENDAR_WEEK() format with the YEAR() format similar to the way the statement ROUND_MONTH does for exmaple. The problem I have with the calendar week as the dimension is that in case of a dataset that includes data from more than one year, the KPIs do always calculate the data of all years for each calendar week while I would like them do distinguish between the weeks of the particular years. Best regards, Maximilian

00
M
Level 2
S
Level 3
sasan.babaz12Level 3
asked in Process Analysis
Match ID’s from two different tables

Hello, I got a question again I try to do an OLAP table where I need to combine data from different tables. I try to explain the case as good as I can. In my table T052U_BSEG I got the column named TEXT1 (here is a description in each column) and the column ZTERM (here i an ID which is unique for each different description, but a description can come up multiple time). On the other hand I got the table PB_CLAR where I got two columns with the IDs from ZTERM in it. I want to create a column in an OLAP table that the ID in PB_CLAR look up the ID in the T052U_BSEG and pull the right description from TEXT1 Thank you guys in advance

40
C
Level 1
.
Level 3
.14600836Level 3
asked in Process Analysis
Pull function –> how many PO items are created for one PR

Hi all, Id like to analyse the number of PO items which have been created for one and the same PR, e.g. PR 12341234 is related to 5 PO items. I tried using the pull function but always when combining PO item data with PR data from table EBAN I get following error message: Undefined exception occured. Table EBAN is not a parent of EKPO. Use non pull up function instead. I guess this should be an easy formula but unfortunately didnt figure out how to achieve the result Im looking for. Any ideas? Thanks, Oli

10
.
Level 3
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

Badge winners

  • First Post
    Sababihas earned the badge First Post
  • Celonis Certified Data Analyst
    subhayu.monda12has earned the badge Celonis Certified Data Analyst
  • Qualified to Deliver Business Value with Celonis
    verena.schwo12has earned the badge Qualified to Deliver Business Value with Celonis
  • Qualified to Manage Change and Scale Adoption
    verena.schwo12has earned the badge Qualified to Manage Change and Scale Adoption
  • Qualified to Build Analyses
    hemalatha.d11has earned the badge Qualified to Build Analyses
Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Center arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2025