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
manuel.wetze
Level 5
manuel.wetzeLevel 5
asked in Process Analysis
Variant Explorer: Add custom KPIs

Hi all I am wondering how to best add a custom KPI defintion to the Variant Explorer.Mainly I want to add my custom process specific defintion of a througphuttime. Me and my endusers don’t care about the default End2End TPT that Celonis always uses as default but rather the time between two specific activities.Instead of (or at least additionally to) the “Avg TPT” Column in the selection panel I would like to use my Metric “Median CustomProcesstime”.Does anyone know if this panel can be changed? Maybe via YAML?  

190
manuel.wetze
Level 5
emil.vakhi12
Level 3
emil.vakhi12Level 3
asked in Process Analysis
SAP FI-CA model for Accounts Payable

Hi, has anyone created a data model for Accounts Payable using SAP FI-CA data?Could you please advise on its parameters - what do you take as case ID, which additional tables your add, which activities do you extract, etc.?

272
emil.vakhi12
Level 3
michael.kohlm
Level 2
michael.kohlmLevel 2
asked in Process Analysis
Assign Costs, depending on the predecessor

Hello,I am quite new to PQL and I tried to assign costs to spesific activities depending on the predecessor.When B is followed by C, only C should be assigned with certain costs. When A is followed by C, again C should be assigned with costs, but with a different value. The result should look like this:CaseID Time Activity Costs 150488 07:34 A   150488 08:30 B   150488 09:23 C 0,84 150488 09:45 D   150488 10:34 A   150488 11:45 C 1,56 150488 v E     I tried this with the following code: CASE  WHEN "ActivityTable"."Activity" = 'C'   AND MATCH_PROCESS_REGEX (    "ActivityTable"."Activity",    'A' >> 'C'   ) = 1  THEN 1.56 WHEN "ActivityTable"."Activity" = 'C'    AND MATCH_PROCESS_REGEX (    "ActivityTable"."Activity",    'B' >> 'C'    ) = 1   THEN 0.84 ELSE 0END Unfortunately the table looks like that, so it assigns the wrong costs: CaseID Time Activity Costs 150488 07:34 A   150488 08:30 B   150488

10
michael.kohlm
Level 2
Saba
Level 4
SabaLevel 4
asked in Process Analysis
Sorting

Hey People,I need help sorting a coloumn in a table where each item number appears twice with a corresponding "Potential Savings" value. My goal is to sort the "Potential Savings" coloumn in descending order while keeping duplicate Item Numbers together (as shown in the current table). However, when I try to sort "Potential Savings," the duplicate entries get separated.Does anyone know how to sort the table in a way that maintains both the descending order of "Potential Savings" and keeps the duplicate items next to each other?Thanks in advance! Vendor Name Business Unit Item Number Commodity Last Order Date Expected Delivery Days Unit Price Potential Savings Alpha Supplies P18 0410390025 I030 2004-01-29 27 10.45 52.66 Beta Industries P20 0410390025 I030 2004-02-09 0 6.90 0.00 Alpha Supplies P18 0437150201 A110 2004-07-31 40 40.67 69.35 Gamma Solutions P20 0437150201 A110 2004-08-26 50 32.00 0.00 Alpha Supplies

212
Saba
Level 4
gauri.pai11
Level 3
gauri.pai11Level 3
asked in Process Analysis
Involve business user with task - unable to find record in task list

Hi team,I was trying to follow as per below screenshot.But i am not able to find a record in task list although added in knowledge model(Attached screenshot below of task list component and knowledge model respectively)Can someone please guide me on this?Thank you in advance!

203
jonas.hess
Level 3
amey.punek12
Level 3
amey.punek12Level 3
asked in Process Analysis
Issue with Skills (Manual Selection)

We have created a OLAP table which we have connected to a skill.In the skill we have created Manual Sensor and enabled the manual selection option but it is not working correctly.In the OLAP table we have also added URL in "Allow Data Service Link" 

50
amey.punek12
Level 3
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

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

382
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: 

70
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

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

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

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

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

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

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

241
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

542
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  

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

160
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

261
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 

462
filki
Level 2

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