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,678 Replies
667 Topics
asdfg
Level 3
asdfg
posted in Process Analysis
Celonis value realization in real life, tips for a believable delivery?

Hi all,in Celonis sales there’s big focus on value realization yet I find the current approach by tracking value with the Transformation Hub less than ideal. For instance, the Duplicate Invoices App may assume that all identified invoices are saved cash, but in reality vast majority of such invoices could’ve been automatically blocked by ERP anyways.Do you guys have some good examples from real life where you were able to demonstrate significant amount of realized value (in $$$) companies got from Celonis implementations? How much of the value was purely Celonis’ merit and how much was it based on process improvement programs companies were undertaking regardless of Celonis?I think this discussion is needed, especially in smaller markets (I’m based in Norway), as the licensing model is much driven by value realization assumptions.

311
alexander.skars
Celonaut
Saba
Level 4
SabaLevel 4
asked in Process Analysis
Add to Data Model

Hi everyone, How can I add something to the existing data model? Thanks!

222
Saba
Level 4
benene
Level 2
beneneLevel 2
asked in Process Analysis
Custom CALC_THROUGHPUT filter shows different results than built-in Throughput Time Explorer

Hello everyoneI'm relatively new to building custom Celonis components in Studio and I've hit a wall with something that seems like it should be straightforward. Hoping some experienced folks here can point me in the right direction.The issue: I'm trying to replicate the built-in throughput time explorer with a custom component, but I'm getting different results:Built-in explorer: 12k cases (1-day filter) My custom component: 13k cases (same filter)What's confusing me:I exported both results and compared them - all 12k cases from the built-in are in my results My component has ~1k additional cases that seem valid when I check them manually These "extra" cases definitely meet the 1-day criteria, so why does the built-in exclude them?My current filter:FILTER CALC_THROUGHPUT(FIRST_OCCURRENCE [ '${start_activity}' ]TOFIRST_OCCURRENCE [ '${end_activity}' ],REMAP_TIMESTAMPS("TABLE"."EVENTTIME", MILLISECONDS) )/ 86400000.0 BETWEEN ${min_days} AND ${max_days}; Questions:Did I make a mistake in

220
benene
Level 2
Maurits de Vries
Level 2
Maurits de VriesLevel 2
asked in Process Analysis
How can I create a table from the following code?

I have the following lines of code for which I would like to create a table in which we see the total amount of transaction codes, another column with total amount of transaction codes per company code and the amount of transaction codes as a percentage of the total transaction codes, per company code.In the back end I have managed to write these codes, however, because of a lack of the 'Over' function I can't seem to be able to make it work in the front end. These are the codes in question that are currently working in the transformation scripts ( back-end ):select TRANSACTION_CODE,ACTIVITY_EN,Company_code,Count(TRANSACTION_CODE) as count_tcode,SUM(count(TRANSACTION_CODE)) OVER(PARTITION BY Company_code) AS total_per_Company_code,ROUND((count(TRANSACTION_CODE) * 100.0 / NULLIF(total_per_bukrs, 0)), 2) AS percentage_per_Company_codeFROM _CEL_AP_ACTIVITIESGroup by TRANSACTION_CODE,ACTIVITY_EN,Company_codeHow would you go about creating a PQL script that could tackle these lines of code

231
janpeter.van.d
Level 8
marcelo.ferre11
Level 2
marcelo.ferre11Level 2
asked in Process Analysis
How can i send a constant input to an Action Flow?

Hi Team,I’m working on creating a generic Action Flow with a writeback module. Depending on the OLAP table, I need to send different inputs to select the correct table for the writeback.

371
jan.vajse12
Level 3
Robin Böhler
Level 2
Robin BöhlerLevel 2
asked in Process Analysis
Capturing User Filters in Action Flow for Excel Export

We are currently looking for a way to capture the filters applied by a user and include them, along with data from tables, in an Excel export triggered by an Action Flow.However, we are currently unable to access or retrieve the filter information within the flow.Has anyone developed an approach or working solution for this scenario? Any help or guidance would be greatly appreciated.

402
Robin Böhler
Level 2
fabian.altendorfer
Level 3
fabian.altendorferLevel 3
asked in Process Analysis
Is it possible to open link to view with filter in link parameter?

Hi, I would like to link from a dashboard to a View with Process Explorer. In the dashboard, an object is selected and I would like to give the object identifier with the link to celonis, so that I can filter in the process explorer based on that (so that I only see this individual object and it’s event log).Is this possible to achieve with a Celonis View?Many Thanks,

101
julia.bauer
Level 5
michael.kaemp
Level 3
michael.kaempLevel 3
asked in Process Analysis
Concat references

Hi together, there's spaghetti in my head. I have the feeling like it should be possible, but can't figure out how to.I've a table like this A B 0 NULL 1 0 2 1 3 1 4 1 5 1 Column A contains the case key, B can contain a case key as a reference. E.g. case 1 refers to case 0. And the cases 2, 3, 4, and 5 refer to case 1. Now I want to "turn around" the reference so that there is a new column that shows e.g. for case 1 that it's referenced by 2, 3, 4, and 5. The result should look like this: A B C 0 NULL 1 1 0 2, 2, 3, 4 2 1 NULL 3 1 NULL 4 1 NULL 5 1 NULL Any ideas? 

252
michael.kaemp
Level 3
emily.helve
Level 2
emily.helveLevel 2
asked in Process Analysis
Combine ERDAT and ERZET fields into single timestamp

Using PQL in the VBFA table, I need to combine the date and time into a single timestamp.Both the ERDAT (date) and  ERZET (time) fields are formatted as complete timestamps in our data model.I succeeded by converting both fields to strings, combining them, then converting the combined string back to a date.TO_DATE(TO_STRING ("VBFA"."ERDAT" , FORMAT ( '%Y-%m-%d' ) )||' '||TO_STRING("VBFA"."ERZET", format ('%H:%M:%S')), FORMAT ( '%Y-%m-%d %H:%M:%S' ) )Is there a more direct approach I could use to obtain the same result? The conversion to string seems  unnecessary.Thank you.

141
S
Celonaut
louis.forst11
Level 3
louis.forst11Level 3
asked in Process Analysis
Stacked Bar Chart

Hi, i have a Bar chart with the time axis on the x-axis and on the y axis how much the money was. Is there a way to break down the y axis graph into the specific vendor_names, there are around ten. How could i do it in a view.  Thanks in advance

201
N
Celonaut
michael.kaemp
Level 3
michael.kaempLevel 3
asked in Process Analysis
assign date value from an augmented attribute to a variable and use it

Hi together, I'm working with legacy views and can't manage to pass the value of an augmented attribute of type date to a variable to use it as parameter for KPIs. The record containing the augmented attribute  - id: CM_MONTHS    identifier:      id: id      displayName: Id      pql: '"CM_MONTHS"."MONTH"'    attributes: []    newAttributes: []    augmentedAttributes:      - id: late_creation_deadline_date        displayName: "Late Creation: deadline date"        possibleValues: []        columnType: DATE        format: "%Y-%m-%d"        housekeeping: false        type: AUGMENTED_ATTRIBUTE    flags: []    priorities: []    triggers: []    businessRules: []    type: RECORD    origin: PACKAGE The component to update the augmented attribute  type: table  settings:    data:      columns:        - id: 3486adcd-a996-49a5-97e0-af17da07e9af          field: CM_MONTHS.MONTH          order: 100        - id: 10c08937-649f-48a0-88fe-929d3107e824          field: CM_MONTHS.AUGMENTED_late_creation_dead

681
michael.kaemp
Level 3
shane.proct
Level 3
shane.proctLevel 3
asked in Process Analysis
Filtering for last activity of each day.

In an OLAP table, I am looking at sales documents "VBAK"."VBELN".  I only want to see the last change of each day.  How do I filter for the last "_CEL_O2C_ACTIVITIES"."EVENTTIME" of each day?  I’ve experimented with PU_MAX, but I keep getting errors.

252
julia.bauer
Level 5
julia.bauer
Level 5
julia.bauerLevel 5
asked in Process Analysis
Input Button Dropdown in JAB Views

Hello everyone, I’m currently migrating an old view to a JAB view. In the old view I had an input dropdown (made with a custom object “Time Dimension” with the content columns: Year, Year-Month, Quarter, Week, Day). In the new JAB view I now want to implement this as well (filtering charts according to Quarter, Week and so forth). I’m already aware of the Celonis documentation: Configuring user inputs (input box, input dropdown, button), but this is really too intransparent for me.  Can someone give me a step by step guide on how to implement this?I already created a variable as object like this: {"Year": "String","Year-Month": "String","Quarter": "String","Week": "String","Day": "String"} However, within the input dropdown component, I don’t know how to proceed as the dimensions Year, Year-Month, Quarter, Week, Day are not stored in a single attribute/dimension. They are all calculated with the EVENTTIME separately. Thanks in advance! Best regardsJulia Bauer 

120
julia.bauer
Level 5
kandi.naidu
Level 4
kandi.naiduLevel 4
asked in Process Analysis
How to configure input dropdown in views

Hi Team, I’m working on input dropdown where my timestamp should be convert into daily,weekly,monthly and if it is daily I need 8 hrs , for weekly 40 hrs and monthly 173 hrs in one single dropdown. How I can achieve it. Regards,Ajith Naidu.

864
julia.bauer
Level 5
leonardo.spina
Level 3
leonardo.spinaLevel 3
asked in Process Analysis
Change in default display of columns within the Case Explorer

Hi team, I want to know more change the default display of columns within the Case Explorer component of Studio Views, after having added two more attributes.Best regards, Leonardo

303
Gaya Balasubramanian
Celonaut
Yannick Noubissi
Level 2
Yannick NoubissiLevel 2
asked in Process Analysis
How to filter table rows based on aggregated column values in Celonis?

Hi everyone, I’m working on an analysis in Celonis and I have a question regarding filtering table rows.In my case, one of the columns in my table displays a sum of values retrieved from the backend (e.g., SUM("SomeColumn")). I would like to exclude all rows where this sum equals zero, so they don’t appear in the final table.How can I apply such a filter directly in the table configuration or via a filter condition?Thanks in advance for your help!

331
N
Celonaut
phil.cook
Level 3
phil.cookLevel 3
asked in Process Analysis
Identifying the First Instance of an Activity as well as Its Follow-up Activity

HelloIn a scenario where there are multiple instances of “WIP CB IP” activity, I am trying to identify the first instance along with the next activity taken by a user.  I am easily able to identify the first WIP activity (highlighted in blue) using PU_FIRST.  However, when I attempt to identify the next activity following the first WIP, I end up retrieving the activity for the 2nd WIP line (highlighted in yellow and red).   I would like to report on the activity highlighted in green.I have tried wrapping the PU_FIRST within the ACTIVITY_LEAD but the syntax failed indicating that “/IRM/IPCBITM” is not within the Activity table.  I have also attempted to use a CASE WHEN statement but that just generated two WIP lines.  I am only interested in the first instance of WIP.Thanks in advance,Phil  

220
phil.cook
Level 3
christine.gentr
Level 2
christine.gentrLevel 2
asked in Process Analysis
Need Help Fixing PQL script to look for a variable direct after a wildcard search using the LIKE function

Hi,I need help fixing my PQL scriptCASE  WHEN "SHOPPING_DETAILS_DESC" LIKE '%CRIT% 1%' THEN 'Criteria 1'  WHEN "SHOPPING_DETAILS_DESC" LIKE '%CRIT% 3%' THEN 'Criteria 3'  WHEN "SHOPPING_DETAILS_DESC" LIKE '%CRIT% 5%' THEN 'Criteria 5'  ELSE NULLEND I am trying task search in a text field (Shopping_Details_Desc) for cases where ‘%CRIT%’ is identified. I would then like the code to assign a Criteria when the number ‘1’, ‘3’ or ‘5’ follow directly after the we wildcard search. I am pulling errors because there are other numbers in the text description and the code is incorrectly assigning them because it is find any any ‘1’ (as an example) that comes after ‘CRIT’ and then calling it a ‘Criteria 1’, even when it is a Criteria 3.  My issue is that sometimes our operators are miss writing the text so we are trying to capture either CRIT or CRITERIA, or anything in between - which is why I want a wild card.  I was able to write a statement in DAX to be able to look for a number assigned direc

274
christine.gentr
Level 2
julia.betzl
Level 3
julia.betzlLevel 3
asked in Process Analysis
Error message: Calculated attribute ["MARC"."COND_MBEW_COMPL_VPRSV"] cannot be used inside a FILTER because it takes filters into account.

Hi all,  I created an attribute (“MARC”.”cond_mbew_compl_vprsv”) as a boolean with the following formular:CASE WHEN(  ( "MARC"."BESKZ" = 'E' AND ( PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VPRSV")) NOT IN ( 'S' ) OR PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."STPRS")) = 0 ))    OR  ("MARC"."BESKZ" = 'F' AND ( PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VPRSV")) NOT IN ( 'V' ) OR PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VERPR")) = 0)))THEN 1 ELSE 0 END Now I want filter like followed: FILTER "MARC"."cond_mbew_compl_vprsv" = 1 This does not work and I got the following error message: Calculated attribute ["MARC"."COND_MBEW_COMPL_VPRSV"] cannot be used inside a FILTER because it takes filters into account. Can you help me what I should change? Thank you. Regards

232
julia.betzl
Level 3
Ushmita Patil
Level 2
Ushmita PatilLevel 2
asked in Process Analysis
Not Getting Data in Charts or Case Explorer – Shows "You don't have data yet"

I'm facing an issue where my charts and tables show the message "You don't have data yet" even though I have connected them to the data model.When I create a Case Explorer, it only shows 1 row with these columns: Case ID Number of Activities Duration In the table section of the Case Explorer, it only displays CDHDR.CASES.Can someone please help me understand why I’m not getting any data in the charts or other tables I create?Thanks in advance!

282
Ushmita Patil
Level 2
NHARNIS
Level 3
NHARNISLevel 3
asked in Process Analysis
Calculate and Count First and Last Activities

Hello everyone,I'm working with classic process data: Case ID, Activities, and Timestamps.I want to list all first activities and all last activities, and count them by case. This way, I can see which activities my variants start and end with, and how many variants they cover.Ideally, I’d like this in two tables—so I can select a starting activity and see the corresponding ending activities in the other table.I’m assuming it’s fairly easy but i can not manage to do this..Kind regards, Niklas

323
NHARNIS
Level 3
julia.betzl
Level 3
julia.betzlLevel 3
asked in Process Analysis
Change Year in Fiscal Year in a KPI

Hello all,I used this formular to get the average time of late payment:AVG((DAYS_BETWEEN(PU_FIRST("BSEG", "_CEL_AR_ACTIVITIES"."EVENTTIME","_CEL_AR_ACTIVITIES"."ACTIVITY_EN" = 'Due Date passed'),"BSEG"."TS_AUGDT")) - <%= buffer1 %> ) This works well but when I filter on Fiscal Year the KPI is wrong because our Fiscal Year is not similar to Calendar Year. Our Fiscal Year starts always in october. How can I change my formular that the KPI is calculated for example from october 2024 til september 2025 when I selected 2025 as Fiscal Year. Thanks and best regards.

477
J
Celonaut
fabian.altendorfer
Level 3
fabian.altendorferLevel 3
asked in Process Analysis
Adjustments Process Explorer

Hi,Is it possible to adjust the settings of a Process Explorer on how it opens inside a view, like the zoom level or which Events are shown?Right now, there are too many events displayed in the Process Explorer, and my users need to zoom manually to see the names of the activities and their KPI values. I would like to change the initial zoom settings to a higher value or to show only the activities that don't display 0 in their primary KPI, if that's possible.Many thanks for any help, Fabian

192
fabian.altendorfer
Level 3
Mst11
Level 3
Mst11Level 3
asked in Process Analysis
How to Recreate Button Dropdowns in New Views

Hello everyone,I understand that the button dropdown is still not available in the new Views. Has anyone managed to recreate a similar functionality? For example in the analysis I have two button dropdowns and for each one of them I have manually inputted 5-6 categories (Local Supplier, Company Code, MSGK, PO number etc.). Each category is updating two variables (one is for the name of the column and other is PQL calculation in OLAP table). Categories from button one are updating variables in column A while the categories in button two are updating variables in column D. I need to achieve something similar in the new Views, but the documentation for the Input Dropdown isn’t entirely clear to me. Has anyone implemented this successfully? If so, how did you manage it?Thanks in advance for your help!

201
Mst11
Level 3
Mst11
Level 3
Mst11Level 3
asked in Process Analysis
Comments/Augmented attributes

Hello everyone,I would like to create option for users where they can leave comments. I would like for this option to be connected to a chart (let say it’s a chart showing number of blocked documents per month) and I would like to allow users to leave comments for February (number of blocked documents was really high compered to other months). But the issue is that for comments and augmented attribute identifier needs to be unique and I cannot configure it. So if someone has some idea I would be grateful.  Also in documentation they configured comments with variables but when i put variable for DOC ID (VIM_1HEAD.DOCID) and use that variable as identifier it’s not working. Any idea what should be put there? Thank you!

210
Mst11
Level 3

Badge Winners

  • Qualified to Get Data Into Celonis
    syota.aoyaghas earned the badge Qualified to Get Data Into Celonis
  • Qualified to Write PQL Queries
    syota.aoyaghas earned the badge Qualified to Write PQL Queries
  • Qualified to Manage Change and Scale Adoption
    marcos.vegahas earned the badge Qualified to Manage Change and Scale Adoption
  • Value Assessment Expert
    asdfghas earned the badge Value Assessment Expert
  • Qualified to Create and Deliver Demos
    asdfghas earned the badge Qualified to Create and Deliver Demos
VIEW ALL
Community Code of Conduct