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.

  • 568 Topics
  • 1,536 Replies
566 Topics
omar.elmou
Level 3
omar.elmouLevel 3
posted in Process Analysis
How to make selections

Hi fellow Celonis user,For some reason i cant make use of selections ( at the top). In the screenshot below you can see that this option is not available. Also i can't change this in the general settings. Hope someone can help out. Thanks!  

344
omar.elmou
Level 3
filki
Level 2
filkiLevel 2
asked in Process Analysis
Send mail from Celonis in Action Flow

Hello,I’m new to Celonis, currently trying to estabilish Action Flow that sends PDF reports.Is it possible to send “Email from Celonis” from Skill in Action Flow?RegardsFilip Kin 

382
filki
Level 2
roman.stolz
Level 2
roman.stolzLevel 2
asked in Process Analysis
Time between same activity for different cases

Hey,I have an activity that every case has to go through. I would like to know how long the time is between each case. (This is interesting for me because only 1 case can go through the activity at a time and we want to analyze the “empty” time).Does anyone have an idea how to calculate this?Thanks for helping!

312
abhishek.chatu14
Level 7
bennita.dutoi12
Level 4
bennita.dutoi12Level 4
asked in Process Analysis
Filter showing all data in a range but one item is 0

Good dayI want to add a filter to this table that shows only the Functional locations (first column) where one of the Material_IDs has a Physical count of 0. Then it must show all the Materials for that Functional location even if its not 0. So the criteria is 1 or more of the materials in the Functional location must be 0 then that functional locational with its other materials should be shown. Below is an example in yellow: Both functional locations A-IAA-BO4-225-HEC-008’s material id must be shown here since one of them is 0. How can I do that?  

131
bennita.dutoi12
Level 4
PhuongBHN
Level 2
PhuongBHNLevel 2
asked in Process Analysis
The aggregation function MAX cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs

I would like to create a KPI to count the cases of the previous month do a dropdown but I keep getting a message that "The aggregation function MAX cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs.” .Have you got idea how to do it?MY pql: COUNT( DISTINCT CASE WHEN ROUND_MONTH("EKKO"."AEDAT") = MAX(ROUND_MONTH("EKKO"."AEDAT"))THEN "EKKO"."MANDT"END)

152
PhuongBHN
Level 2
prek
Level 2
prekLevel 2
asked in Process Analysis
Data integration - Extractions and Transformations

I would like to create a use case to analyse the throughput times of finished goods flow from one warehouse to another.Unfortunately, there are no pre-existing data connectors available for this particular use where i would be especially looking into goods issue and goods receipt.I did go through the celonis academy trainings but the trainings were basic and i cannot seem to apply what i learnt in the trainings to my use case.Does anybody have any help/ leads?Best RegardsKenny

554
prek
Level 2
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?  

330
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 ?   

464
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!     

282
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

635
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

181
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

130
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?

200
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
Celonaut
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  

162
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.  

160
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

807
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. 

233
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 

351
S
Level 3
lucas.diniz
Level 2
lucas.dinizLevel 2
asked in Process Analysis
How to change data model in Duplicate Checker APP

I extended my duplicate checker perspective, add the objeties what i want, and change my data model variable to my data model extended, but my view warns are records missing, these records have “aug” in the name. Anyone know how to change my data model to my data model extended and create these records missing?my perspective extended:the error when i change my data model:  

70
lucas.diniz
Level 2
rahul.awast12
Level 2
rahul.awast12Level 2
asked in Process Analysis
Select All check box not appearing in filter dropdown option in views YAML

I am working on creating views and created Filter check box with on click option , but  Select All checkbox is not coming at right side.Below is the YAML I am usingid: dropdown-list-60b99e03-3e73-459b-87be-9d51464f35type: dropdown-listsettings:  data:    columns:      - id: c3c70431-d853-4ff1-95ac-50bc70a226ff        order: 100        onClick:          update:            selection: multiple            variables:              - name: target_attribute_name1        attribute: TABLE_1_2.TARGET_ATTRIBUTE_NAME        displayName: ""

270
rahul.awast12
Level 2
preena.nair
Level 2
preena.nairLevel 2
posted in Process Analysis
Process order/Production order

what insights generation can be done for production order

270
preena.nair
Level 2
lucas.fisch12
Level 2
lucas.fisch12Level 2
asked in Process Analysis
PDF Export of View (JAB) does not work

Hi all, The Celonis module that creates PDF's in Action Flows can't find my View. The Connection seem to work with the App Key that also has the right permissions and the View is also published. I always get the error "Something went wrong while handling the request. Please contact Celonis customer support. Celonis Support ID: e9c4bdad-04c3-49ea-b834-0e2dc618323b" from the 'Analysis' dropdown within the module. Does the Module even work with the new Views (JAB) since the next Parameter I need to fill in is 'Sheets' but the new View doesn't have Sheets, it has Tabs?

404
B
Level 2

Badge winners

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