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.

  • 562 Topics
  • 1,521 Replies
560 Topics
bennita.dutoi12
Level 4
bennita.dutoi12Level 4
asked in Process Analysis
KPI's with filters

Hi everyone I need to add 3 kpi’s together (new views) each with their own filters. Here is an example of one. How can I add these KPIs together without having to build these filters into my PQL. If you save the  KPI it does not save the filters with it. Can I maybe let it write to a variable with the filters? Or is the only way building the filters into the PQL with Case when or PU function?  

80
bennita.dutoi12
Level 4
shaif
Level 3
shaifLevel 3
asked in Process Analysis
Doubt on OCPM process explorer - Not all objects appearing in process explorer

Dear Experts , I have a doubt here, on what logic does the objects appear on scroll bar in Process explorer like shown in snapshots attached. Are they dependent on number of objects i defined or events or relationships ?   

334
shaif
Level 3
omar.elmou
Level 3
omar.elmouLevel 3
asked in Process Analysis
Throughput calculation

Dear i am puzzled that the calculated throughput time in Celonis is different from the source (excel) data. For example order  O4892 has a throughput time of 12 minutes (according to the raw data in Excel). However the output in Celonis is 1M (1 month?). . Could you please assist by advising on this difference.Below you can see a screenshot of the data set and output in Celonis.Many thanks!     

222
omar.elmou
Level 3
david.stefa13
Level 3
david.stefa13Level 3
asked in Process Analysis
Action Flow - Microsoft Outlook 365 Question re CSV attachment plus Queried data available

I have successfully set up an Action Flow to output my Celonis Query in an Outlook 365 email. I use The Celonis Query Data module  → CSV module (create CSV) → Tools module to compose a String for the CSV file to be inserted as a file attachment in Outlook → MS 365 Email Outlook module to Create and Send an email. (see image below).This all works great and we filter to output specific customer data. Today, we manually fill in the customer email contact info.However, we would like to use the Customer Contact data from the Query (name/email_address) to automatically populate the MS 365 Email Recipient. I have observed that the Tools module is limiting what data flows into the Outlook module and within the Outlook module I do not have access to all of the individual Data values from the Celonis Query.When I remove the Tools module, all of the Celonis Query Data module data is readily available for use in the Microsoft 365 Email Outlook module. (but I don’t have the CSV file formatted the w

435
jan.tran
Level 3
rebeca.ruipé
Level 2
rebeca.ruipéLevel 2
asked in Process Analysis
extract data from Datapool without updating the Data Model in an Action Flow

Hello, How can I extract data from a field from a datapool table without updating the Data Model in an Action Flow?Is it Possible? Thanks

141
matt.witty13
Level 5
Nivedita
Level 2
NiveditaLevel 2
asked in Process Analysis
Report process KPI via Email

Hi all,I am working on this project where I need to process KPI via email. I have taken CSV file as a data model.But I am unable to perform iterations on my data. Please help me on this part

100
Nivedita
Level 2
mona.nagha
Level 2
mona.naghaLevel 2
asked in Process Analysis
Creation of Line chart ( Dimension Month and KPISpecific Activity avg Throuput times)

Hi I am trying to create a line chart to compare avg throuput time between two activities how it fluctuates between different months. My Dimesion is this formula: ROUND_MONTH("AE_process_dataset_with_realistic_time_variabilities"."TIMESTAMP") My KPI formula is : PU_AVG (DOMAIN_TABLE ("AE_process_dataset_with_realistic_time_variabilities_CASES"."CASE ID" ), (  CALC_THROUGHPUT (    FIRST_OCCURRENCE [ 'Arrival at A&E' ]    TO    LAST_OCCURRENCE [ 'Initial Assessment' ] ,    REMAP_TIMESTAMPS (      "AE_process_dataset_with_realistic_time_variabilities"."TIMESTAMP" ,     MINUTES    )  ))) But I only get a graph for the first month:  Please can someone advise what I am doing wrong?

150
mona.nagha
Level 2
omar.elmou
Level 3
omar.elmouLevel 3
posted in Process Analysis
KPI average cycle time

H fellow Celonis useri, I am a newbie mainly using the visual editor for creating KPI's. My question is, is it possible to create a KPI for calculating the average cycle time of orders with only the visual editor (no PQL). A screenshot of the date is attached. Hope you can help, thanks! 

311
ayushi.chakr11
Level 2
raman.silot11
Level 3
raman.silot11Level 3
asked in Process Analysis
Runtime variable plain text not visible in analysis

Hello, While creating plain text runtime variable, it is not visible in the analysis filters. Even after publishing the package it is not appearing. Is there any recent changes done to runtime variables in Celonis ? Thank You Usually the runtime variables used to be mentioned on the left panel  

152
raman.silot11
Level 3
T
Level 1
tomo.tsukaLevel 1
asked in Process Analysis
Conformation between “Cycle Time” and “Throughput time”

Hello. Id like to confirm significant between cycle time and throughput time in Celonis. Would you tell me correct answers If I misunderstand it below. Cycle Time It means the time spent the whole workflow (ex. P2P, O2C, etc) 2.Throuput time It means the time about detail each workflows. (Ex. activity, case, another dimensions etc.) best regards.

102
michalCelonisNewbie
Level 2
koert.kritz11
Level 3
koert.kritz11Level 3
asked in Process Analysis
Currency Conversion Common table error

Hi all, I am trying to convert my currencies to ZAR using CURRENCY_CONVERT. Here is my code: CURRENCY_CONVERT ("o_celonis_SalesOrderItem"."NetAmount", FROM ( "o_celonis_SalesOrderItem"."Currency" ), TO ('ZAR'),"o_celonis_SalesOrderItem"."CreationTime" ,"o_celonis_CurrencyConversion", "o_celonis_CurrencyConversion"."ExchangeRateType", "o_celonis_CurrencyConversion"."SourceSystemInstance" )But it does not work.  

150
koert.kritz11
Level 3
yuyao.wang13
Level 2
yuyao.wang13Level 2
asked in Process Analysis
Inquiry on Best Practices for Building an Overview View with Data from Multiple Data Models

Dear all,I am currently working on building a view for the management team to track KPIs across the entire organization. The organization consists of multiple entities, each using different systems (e.g., SAP, MSSQL, etc.), and as a result, we have multiple data models in the backend.In the overview view, we want to visualize data from these different models in a single interface. I have created a space that contains one view and multiple knowledge models. I would like to confirm whether this approach aligns with best practices and if it is possible to achieve my goal with this setup.Looking forward to your insights.Thank you,Yuyao

597
bunyod.sap
Level 4
bennita.dutoi12
Level 4
bennita.dutoi12Level 4
asked in Process Analysis
snapshot

Hi There, does anyone know if Celonis can take snapshots of values? We determine inventory but its always the newest and latest figures and I cant find a proper data to use for a timeline graph of inventory. So I was wondering if its possible for Celonis to take a daily snapshot of a figure for use in a graph. 

213
bunyod.sap
Level 4
marcus.sturs11
Level 2
marcus.sturs11Level 2
asked in Process Analysis
Calculate Average Activites for similar cases

Hello all,I am struggling to calculate the average count of activities for similar cases. The calculation returns a wrong result. It doesn’t matter if I use PU_COUNT on the activity table or CALC_REWORK. Example DataCase ID Parameter Number of Activities in Activity table 1 A 10 2 A 10 3 A 20 4 B 15  I would like to know the amount (count) of process steps (activities) on average for cases with a certain parameter.Expected ResultParameter Average activities count A 13.33 ((10+10+20)/3) B 15 (15/1)  What I getDimension: ParameterKPI:  AVG(CALC_REWORK())Parameter Average activities A 15 B 15  It does consider the ‘10’ activities for case 1 and 2 only once. So if the number of activities is the same for multiple cases (which might very well be the case), the calculation is wrong. If I remove the Dimension, I get the correct overall result of 13.75. But as soon as I add the Parameter as a dimension (which I need), the result is not correct anymore

130
marcus.sturs11
Level 2
johannes.mayr12
Level 2
johannes.mayr12
asked in Process Analysis
Combine two similiar objects to simplify analysis

Hey community, Is it possible to combine two ocpm objects with each individual eventlog to combine into on object & eventog?My szenario is that i have two objects for two different type of documents. They have the same structure and events but they are not named same as each event ends with they name of their type.And i want to perform on both the same analysis and i am looking for a way instead of duplicating all analysis and adapting the kpi to simply my it. So both less duplicate work for me and easier for the enduser to work with. Is there like a “union” function to join them or is it possible with a parameter to switch the object/eventlog in a view? Thanks in advance 

221
S
Level 3