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.

  • 663 Topics
  • 1,674 Replies
663 Topics
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!

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

161
bennita.dutoi12
Level 4
PhuongBHN
Level 3
PhuongBHNLevel 3
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)

1702
PhuongBHN
Level 3
PhuongBHN
Level 3
PhuongBHNLevel 3
asked in Process Analysis
Updating a Variable in Celonis Studio when Date Filter Changes

Hello everyone,I am facing an issue while working with Celonis Studio. I have created a variable as follows:YEAR(ADD_MONTHS(ROUND_MONTH(MAX("view_meviy"."timestamp")), -1)) ||MONTH(ADD_MONTHS(ROUND_MONTH(MAX("view_meviy"."timestamp")), -1))Now, I want this variable to respond to the date filter in my report. Specifically, I want the variable to update its value to reflect the previous month based on the selected date in the filter.I would appreciate any assistance and guidance from the community on how to properly set this up.

250
PhuongBHN
Level 3
anusuya.ponnu
Level 3
anusuya.ponnuLevel 3
asked in Process Analysis
Does Celonis have prebuilt apps for Tax reconciliation based on General Ledgers

Hi Team, Has anyone built solution for Tax reconciliation analysis based on General Ledgers for Indirect Tax. We are trying to automate tax reconciliation which will have analysis basis documents types, credit, debits for each GL account. Any suggestion on the SAP tables, logic are welcome.

613
S
Level 3
manuel.wetze
Level 5
manuel.wetzeLevel 5
asked in Process Analysis
Filtered Cases: Ring Chart-> Pie-Chart Update ?

Hi all,I was wondering about a minor style change of the platform I noticed yesterday.Next to all the applied filters where there is the a small visual indicating how many cases (in % and absolut by hovering over it) are currently selected. This was for a long time a Ring chart. Suddenly it became a pie chart yesterday. Introducing the added problem, that the % number in the middle is poorly visible if the background is split in half into darkblue/light grey by the pie cutting trough it.For a colleague of mine the change was already present yesterday. For me only today.I haven’t about any release plans about this and am wondering about it.My Question is if I as an Analyst can influence that or if it is tied to the user account, of if it is just a given by the platform and we have to accept it. 

101
abhishek.chatu14
Level 7
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

744
prek
Level 2
mateusz.skurz
Level 2
mateusz.skurzLevel 2
asked in Process Analysis
How to open a filter bar from the view that was opened in overlay?

Hi all,In my View analysis I added the filters into the ‘Show Filter Bar’ that resided on the right side of the view. However, once the same view is opened in overlay, the ‘Show Filter Bar’ is not visible - hence I have no access to the filters.  Is there a way to include a Filter Bar into a view opened in overlay? Thanks and kind regards,Mateusz

371
abhishek.chatu14
Level 7
kandi.naidu
Level 4
kandi.naiduLevel 4
asked in Process Analysis
How to write pql for this tables.

Hi Team, I am trying to create a column chart where I am using  2 tables custody and activity_table .However I am end up with no common table error. The joining in the datamodel as follows:custody(N) ← MCA_CA_ID_NEW(1) → Line_table(N) ← Head_table(1) → Activity_table(N).How I can write the pql statement for this .  

400
kandi.naidu
Level 4
utkarsh.rasto11
Level 2
utkarsh.rasto11Level 2
asked in Process Analysis
How to create OLAP Tables with sub-categories?

As evident from the above image, there are further sub categories in the metrics column. Can we create an OLAP table in similar fashion? 

471
abhishek.chatu14
Level 7
Mst11
Level 3
Mst11Level 3
asked in Process Analysis
Changing the color of the textbox

Hi, in the legacy view there was possible to change background color of textbox, buttons etc. but I cannot find a way how to do it within the new views. I tried to do it through the YAML but it’s not working. So if someone has an idea it would be awesome!

1001
abhishek.chatu14
Level 7
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?  

460
bennita.dutoi12
Level 4
bunyod.sap
Level 4
bunyod.sapLevel 4
asked in Process Analysis
Dropdown Filter in New Views

Dear all, I have in one view two OLAP tables(with complex calculations and predefined conditions) for which I want to create independent dropdown filters. The reason for that is that one should be filtered based on date type “received entries” and the other one based on date type “processed entries”. I was wondering if you maybe came across such an issue or if you have maybe some tips & tricks or solution for me? In advance thanks for your help. Best, Bunyod

464
bunyod.sap
Level 4
kailash.potha12
Level 5
kailash.potha12Level 5
asked in Process Analysis
Excel Or CSV Exports

Hello,Is there an effective method to restrict exports to specific users or groups of users in Old Views?

320
kailash.potha12
Level 5
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 ?   

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

502
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

855
jan.tran
Level 4
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

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

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

701
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  

182
raman.silot11
Level 3
tomo.tsuka
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.

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

370
koert.kritz11
Level 3
Akshay Haridas
Level 3
Akshay HaridasLevel 3
asked in Process Analysis
Analysis date dropdown sorting

Hi All,I have created one column Month_Year in one of my tables which I am using for creating the analysis dashboard. The Month_Year column is of type Varchar and so when I am creating a drop-down component in the analysis rather than getting the Month_Year column in date order I am getting it in alphabetical order. Sure I know there would be answers to this query saying to change the datatype to date and then do the to_date function in the front end but in that scenario, I am getting unwanted things like day, time, hour, seconds and all. I only want the month and year to be displayed in the dropdown and that to in date order. Can anyone please help me on this query

292
Akshay Haridas
Level 3

Badge Winners

  • Qualified to Manage Change and Scale Adoption
    Pablo MChas earned the badge Qualified to Manage Change and Scale Adoption
  • Value Assessment Expert
    Pablo MChas earned the badge Value Assessment Expert
  • Qualified to Create and Deliver Demos
    Pablo MChas earned the badge Qualified to Create and Deliver Demos
  • Qualified to Prove Celonis Value
    Pablo MChas earned the badge Qualified to Prove Celonis Value
  • Qualified to Identify and Drive Opportunities
    Pablo MChas earned the badge Qualified to Identify and Drive Opportunities
VIEW ALL
Community Code of Conduct