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.

  • 667 Topics
  • 1,675 Replies
667 Topics
NHARNIS
Level 3
NHARNISLevel 3
asked in Process Analysis
Using Pu functions instead of Aggregates to be able to Filter KPIs

Hello Celopeers, im new to Celonis and have created a view. There i use a Kpi which drops a lot of zero values. When trying to filter them out i always get the error that aggregated functions can not be used in combination with the FILTER function, and that i should try PU functions. The KPI i'm using is this:SUM( CASE  WHEN round_day("o_custom_KnotenpunktAuftrag"."AusgangForecast") = round_day("o_custom_KnotenpunktFuellstand"."Date")  THEN 1  ELSE 0 END)or alternetively this : COUNT(DISTINCTcase when round_day("o_custom_KnotenpunktAuftrag"."AusgangForecast") =round_day("o_custom_KnotenpunktFuellstand"."Date") then  "o_custom_KnotenpunktFuellstand"."KnotenpunktAuftrag_ID"end) is simply want to calculate for each KnotenpunktFuellstand.Date, how many Order.IDs i have where the filter condition is met.So i can have a table where im using the date plus KPI to see, how many outgoing orders i can except for each date. How can i have a row-count, based on a condition formulated as a PU functi

562
NHARNIS
Level 3
deeksha.r12
Level 4
deeksha.r12Level 4
asked in Process Analysis
Accessing and Configuring Scheduled Reports

The reports section is intended for viewing scheduled reports, we do not see any option to configure them. 

191
matthias.gielk11
Level 3
ritesh3719
Level 3
ritesh3719Level 3
asked in Process Analysis
How to Capture User Inputs in Studio Views and Store Them in Backend SQL Table

Hi Community,I'm working on a use case in Celonis Studio where I want to take inputs from users directly via Studio Views  — such as dropdown selections, text inputs, or button clicks — and then store those inputs in a backend SQL table (in a Celonis data pool).What are the recommended ways to capture user inputs from Studio Views (e.g., via Input Controls or custom components)?

393
matthias.gielk11
Level 3
ritesh3719
Level 3
ritesh3719Level 3
asked in Process Analysis
How to send dynamic email content in Action Flow based on status

Hi Community,I’m building an Action Flow that sends email alerts based on a flag column (e.g., Alert_Status = 'Yes').The email subject and body should change dynamically based on the record’s status (like Pending, Approved, Rejected).I have a config table that maps each status to a subject and body template.Appreciate any suggestions!

423
S
Celonaut
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.?

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

213
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

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

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

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

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

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

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

501
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

90
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

Badge Winners

  • Qualified to Build Views
    Pablo MChas earned the badge Qualified to Build Views
  • Qualified to Build Views
    amanpreet.sethihas earned the badge Qualified to Build Views
  • Qualified to Build Analyses
    pandiri.ravishas earned the badge Qualified to Build Analyses
  • Celonis Technical Expert
    Marlijnhas earned the badge Celonis Technical Expert
  • Qualified to Write PQL Queries
    Marlijnhas earned the badge Qualified to Write PQL Queries
VIEW ALL
Community Code of Conduct