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.

  • 660 Topics
  • 1,665 Replies
658 Topics
Bharath
Level 3
BharathLevel 3
asked in Process Analysis
Process flow analysis

PROCESS FLOWNeed some assistance, I have a CaseID, Activity and Timestamp. I need to get all the cases where the activity flow is A to B to C. (NOTE: the activities don't have to be directly followed by) I cannot use MATCH_PROCESS_REGEX or any other commads. I need to used CASE WHEN, AND, ACTIVITY_LEAD etc... to solve this. Please help me out. My approachCASE WHEN "tab"."Activity" = 'A'AND ACTIVITY_LEAD(CASE WHEN "tab"."Activity" = 'A' THEN "tab"."Activity" END) = 'B' AND ACTIVITY_LEAD(CASE WHEN "tab"."Activity" = 'B' THEN "tab"."Activity" END) = 'C'  THEN CaseIDEND

364
Bharath
Level 3
ritesh3719
Level 3
ritesh3719Level 3
asked in Process Analysis
Enable/Disable or hide/unhide functionality in Studio View

Is it possible to enable/disable or hide/unhide a button in Celonis Studio Views. Basically i want to enable the button on certain conditions applied in the filter dropdown inputs.

312
ritesh3719
Level 3
koert.kritz11
Level 3
koert.kritz11Level 3
asked in Process Analysis
PAM Event log Error

Hi I, I am configuring my PAM but keep running into these errors.  ErrorSupport Id: faafa039-b13e-47e6-88cd-7e64c7f898e6PQL Error during operation: Events - Count. Repeating the request will always result in error. Fix this by changing the current asset state. If the error persists, please contact support. ErrorThere are event logs in your selection which are no longer available or valid:EL_CUSTOM_OTTPAYMENT__ACTIVITYI created a second eventlog with the required names for my activities and this works when I use it for process explorers and case explorers, but when I try and use it for my PAM I get the error messages. Here are my eventlogs: 

60
koert.kritz11
Level 3
tushar.konde
Level 3
tushar.kondeLevel 3
posted in Process Analysis
Filter View data with user login into celonis

I am working on use case where i want to filter the view when user log in into celonis .user has two types one general buyer and second tactical buyer so when general buyer login he should access only general buyer data and when tactical buyer log in he should access only tactical buyer data so i need help to create this filter if its possible how i build it in celonis Thanks in advance

361
janpeter.van.d
Level 8
Sony Shrestha
Level 3
Sony ShresthaLevel 3
asked in Process Analysis
Check if last occurrence of A directly follows B

I am aware of PQL that checks if activity A directly follows B. Can someone help me with PQL to check if first/last occurrence of A directly follows first/last occurrence of B?

281
janpeter.van.d
Level 8
Sony Shrestha
Level 3
Sony ShresthaLevel 3
asked in Process Analysis
Get number of instances of object type O1 which is related to n instances of object type O2

I want to write PQL that gives me number of instances of object type O1 which is related to n instances of object type O2. Ex: Number of Purchase Order which is related to 2 instances of payment. There is no 1:N relation between these table. In this scenario, is it still possible to get number of instances of one object based on how many times it is related to other object type?

162
Sony Shrestha
Level 3
Bharath
Level 3
BharathLevel 3
asked in Process Analysis
OLAP Tables and Tables

I am new to Celonis. I have this dilemma on ‘Why do tables exists when we have OLAP tables’.What is the purpose of two of them existing?I know tables are present only in views while OLAP tables in analysis.What are all the differences or things we can do with tables and OLAP tables seperately? 

483
Bharath
Level 3
charan.rajum
Level 2
charan.rajumLevel 2
asked in Process Analysis
setup scale picked based on annotation value of line chart

How to setup scale picked based on annotation value of line chart,I have three annotations lines upperlimit,lower limit and average if the average comes as 95% i want the scale to be displayed from 91,92,93... to 100,I know we can configure manually in component settings but is there any other way ?

80
charan.rajum
Level 2
Bharath
Level 3
BharathLevel 3
asked in Process Analysis
Views and Analysis

I have some confusion as to why analysis and views exist as separate entity. When both of them serve the same purpose despite the differences in availability of some features.

1212
Bharath
Level 3
ritesh3719
Level 3
ritesh3719Level 3
asked in Process Analysis
Adding a checkbox or a button against each record in view table dashboard which will set the value of the column of that table in a variable.

I want to add a button or a checkbox against each record in a table component in view studio. This button or checkbox will dynamically set the value of a column in variable which will be used for filtering purpose in another view in same package. 

242
ritesh3719
Level 3
Saba
Level 4
SabaLevel 4
asked in Process Analysis
Filter Date in PU

Hi,How can i filter it to show the values from last year?PU_LAST("o_celonis_MaterialMasterPlant", "O_celonis_PurchaseOrderItem"."NetUnitPrice")Thanks!

341
abhishek.chatu14
Level 7
Saba
Level 4
SabaLevel 4
asked in Process Analysis
Duplicate

Is there a way to remove duplicate values in a coloumn ? 

221
Sverre Klein
Level 6
Saba
Level 4
SabaLevel 4
asked in Process Analysis
Compare

Hi,Is there a way to compare the value of the 2 row and return the one that is smaller and then sum all the smaller values together ?Sampleid 1 = 5id 2 = 20id 3 = 7sum = 5+20+7 = 32

80
Saba
Level 4
robert.ledig
Level 2
robert.ledigLevel 2
asked in Process Analysis
Difference between CASE WHEN and STATIC CASE WHEN and when to use it?

Hello everyone,I hope you can help me understand the difference between the two PQL functions CASE WHEN and STATIC CASE WHEN.I can't find the difference using the documentation, and unfortunately, I couldn't find any content about it in the forum either. I would really appreciate your help and hope someone can explain it.Thank you for your support!Best regards,Robert

532
robert.ledig
Level 2
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!  

424
omar.elmou
Level 3
antonio.figue
Level 2
antonio.figueLevel 2
asked in Process Analysis
Create and send automated PDF reports from Views

Hi, I currently have a dashboard in Studio Analysis for which I built an Action Flow that picks up a distribution list with certain filters so that i can send out automated emails with a pdf attachment (each with different filters). Now I wanted to do the same with a View and this is not possible.50 users should receive an automated pdf of a View on a weekly basis filtered only on their set of Divisions/ Product Groups. What is the best alternative to automate this?BR  

330
antonio.figue
Level 2
Hannah37310
Level 2
Hannah37310Level 2
asked in Process Analysis
Bar chart including incomplete quarters

I’m attempting to create a bar graph that shows opportunities created by quarter (Q1, Q2, Q3, Q4). However, I want to include incomplete quarters (ex: Q1 - 2025, but I have no data for March 2025, only Jan 2025 and Feb 2025, but I still want to show this quarter). Is there a way to do this? I’ve tried a bunch of things, but none make the incomplete quarter appear. Thanks!

150
Hannah37310
Level 2
stephan.kosch
Level 2
stephan.koschLevel 2
asked in Process Analysis
Line Break in Tables

Hello everyone, have you thought about integrating line breaks into Tables of the new views? Can you please give us a brief update on this.Thank youStephan

241
A
Celonaut
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 

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

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)

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

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

593
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

Badge Winners

VIEW ALL
Community Code of Conduct