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.

  • 645 Topics
  • 1,635 Replies
643 Topics
A
Level 3
alex.alexLevel 3
asked in Process Analysis
Exporting a scroll-able component (chart) to PNG does not show the entire chart

As the title says, exporting a chart that scrolls to PNG only shows the area that is captured within the current window. Is there a way to have the exported PNG show the entire chart? CPM_OLAP_Table_20200902_152303|690x141

20
C
Level 1
M
Level 3
masha.galitLevel 3
asked in Process Analysis
Column chart KPI: count of cases that match specific condition

Trying to create a KPI for my column chart, where I would count only those cases for which a specific condition is met. In particular, I want to count the number of SO Items (COUNT_TABLE(VBAP)), which were created via EDI (VBAK.BSARK = DFUE). Tried this statement, but getting an error: CASE WHEN VBAK.BSARK = DFUE THEN COUNT_TABLE(VBAP) ELSE NULL END Error: image77760 4.71 KB Dimension is ROUND_MONTH(VBAK.ERDAT) if that makes the difference. UPDATE: in addition, important that in the end I want to show on the same column chart also the number of SO Items that were created not with EDI. I.e. I want to have a stacked column that consists of all SO Items and I see the part with EDI and the part without EDI. Help appreciated! Regards Masha

00
maximilian.hoffm13
Level 3
P
Level 3
pritam.roy20Level 3
asked in Process Analysis
Unable to make NULL Value as the selector in an OLAP Field

In the OLAP I can see the particular field has null value, but selecting the same value resulting the OLAP to show no rows.

80
S
Level 1
M
Level 3
masha.galitLevel 3
asked in Process Analysis
PQL filter - different filtering based on an attribute

Hi everyone, I am trying to write a load script that would incorporate the below logic, and I am confused with the syntax. Will appreciate any advise. Analyzing SAP O2C process. Logic: If SO Item is for defined materials then this SO Items should be included without any additional filter. If SO Item is for any other materials (not from that defined set), then for those SO Items additional filter should apply. Materials that should go without filter: EDIDUMMY, ILODUMMY For every other material I want to exclude those where there is a reason for rejection: ISNULL(VBAP.ABGRU) = 1; I tried to write something like this, but after I try to save the script analysis keeps loading forever, so I guess something is not working with the filter: CASE WHEN VBAP.MATNR IN (EDIDUMMY, ILODUMMY) THEN FILTER 1=1 ELSE FILTER ISNULL(VBAP.ABGRU) = 1; thanks Masha

70
M
Level 3
N
Level 2
nicolas.forstLevel 2
asked in Process Analysis
How to easily remove an activity?

Hi all, I have a process with parallele sub processes. As Celonis doesnt display theses sub processes my idea is to remove the activites related to these sub process in the analysis. So how is it possible to easily remove activity in the analysis (keep all the cases with or without this activity but just remove the activity)? I could do that by removing the activity in my csv and reload it but I wanted to know if there is an easy way to to that in Snap (by exemple in using the Activity filter, but this filter will filter the cases and not remove the activity). Thanks all for your help Nico

100
C
Level 1
N
Level 2
nils.höhlLevel 2
asked in Process Analysis
Reduce the number of shown labels in the dimension axis

Hello everyone, Im currently working on an analysis for viewers which is going to be exported as image, a stacked area chart in the date range of a year. Now to my problem: Their requirement is that every workday has to be shown in the diagram, so the dimension axis gets unreadable because of the amount of dates displayed: (part of the diagram with the date range of half a year as example) Is there any way to only display every second or third label on the dimension axis so it looks less cluttered and more readable? Ive looked through the component options but couldnt find anything related exept the tick count, but that doesnt help me for this case. Best regards, Nils

30
C
Level 1
D
Level 3
daniel.diers12Level 3
asked in Process Analysis
Count Cases which are just in one table

Hey all, I want to count cases where an article number is just present in one table but not in the other example TableV1 ArtNr 1 3 4 5 7 9 TableV2 1 2 3 4 5 6 7 8 9 10 Count cases which are in TableV2 but not in TableV1 (Null). In that case 2, 6, 8, 10 -> Count = 4 Thx and br Daniel

00
C
Level 1
D
Level 3
daniel.diers12Level 3
asked in Process Analysis
Change table name with variable

Hey pros, I want to upload lots of table with the same columns, like article number and price. To select which version/table should be analysed I want to setup a variable with the name of the table. Example: Currently COUNT(DISTINCT SupplierA_v10.csv.Teilenummer des Lieferanten) Should be something like that COUNT(DISTINCT " || <%= Name_Update %> || .csv".Teilenummer des Lieferanten) Do you have any ideas how to set this up? Many thanks ahead and br Daniel

50
C
Level 1
M
Level 3
masha.galitLevel 3
asked in Process Analysis
Understand the pie chart

Hi, I am trying to build a simple pie chart and am a bit puzzled by the results. As dimension I added the following statement: CASE WHEN VBAK.BSARK = DFUE THEN EDI ELSE NON-EDI END And as KPI: COUNT_TABLE(VBAK) So, I want to see a pie chart that will be divided into two parts based on the value in the field BSARK: part 1 - DFUE part 2 - anything else But for some reason the pie chart also has a 3rd part which has - value. How shall I understand it? thanks a lot for any advise

10
M
Level 3
rita.kiss12
Level 4
rita.kiss12Level 4
asked in Process Analysis
Count activity through the whole process

The ACTIVATION_COUNT operator returns for every activity in every case, how many times, at a given point in a process this activity has already occurred. Is there a similar function that counts how many times the activity occurred for every case? 2020-09-01 14_46_43-11 AP First Time Right _ Process Analytics780228 5.03 KB 2020-09-01 14_46_35-11 AP First Time Right _ Process Analytics803138 2.45 KB E.g. in this case, I used ACTIVATION_COUNT for the repetitions. Now the #2 is actually the total number of cases, as it means 2x at this point but it might be more. Is there a way to show when the activity happened exactly 2x (so exclude 3x, 4x, etc.) Thanks!

100
rita.kiss12
Level 4
.
Level 3
.14600836Level 3
asked in Process Analysis
Date Picker based on PO Line Item creation date

Hi all, in our P2P analysis we used to filter based on PO Header creation date (EKKO.AEDAT). However, it would be more precise to filter based on PO Line Item creation date. Looking in our SAP table for PO Line Items (EKPO), the date which is available in EKPO is always the last update date (which is not necessarily the line item creation date, in case there are changes in the PO line item after the creation). Thus, we have to also look at the CDPOS and CDHDR tables in SAP to see what kind of change have been done for the PO line item (> Insert = PO line item creation date; Update = change date after PO line item creation date). As we are not having CDPOS and CDHDR tables in our P2P data model, we are now using a date picker with the formula _CEL_P2P_ACTIVITIES.EVENTTIME. However, by doing so we would need to add component filters or an Analysis script in order to consider only the activity Create Purchase Order Item for the event time (FILTER _CEL_P2P_ACTIVITIES.ACTIVITY_EN = Creat

20
rita.kiss12
Level 4
.
Level 2
.14600830Level 2
asked in Process Analysis
Throughput Time from a Crop Selection

I want that, when filtering a process using the Crop Selection, that the Throughput Time displayed for a Case is calculated considering the first to the last filtered Activity. I tried to do this using the Standard Components, and realized that it calculates the Throughput Time of the whole Process and not just the filtered segment. How do I set this up?

20
.
Level 2
.
Level 2
.14600933Level 2
asked in Process Analysis
Referencing minimum value of calculated KPI

Hello, I am trying to refer to a minimum value of a calculated KPI and calculate another KPI. In this case I am looking at minimum cost and calculating Potential savings. Is there a way to do this? the min function only works on columns as far as i know

10
A
Level 2
.
Level 2
.14600952Level 2
asked in Process Analysis
Vendor Master Data Analysis

Hi everyone! I would like to build an analysis focused on the vendor master data I would like to show the vendors who are NOT flagged for deletion but at the same time had NO activity in the last 24 months (no invoices) Any ideas how to pt together this data? Thank you very much Tatiana

40
C
Level 1
V
Level 3
vamshi.kuchuLevel 3
asked in Process Analysis
First timer to Celonis - COUNT_TABLE

Hi Celonis experts, I am trying to understand what columns are picked up from a table when i do a Count_table(EBAN). When i tried doing, COUNT_TABLE(EBAN) results are 22531. However, when i try to achieve the same with any column in EBAN table, the values are not matching. Thanks in Advance!

30
V
Level 3
.
Level 3
.14600905Level 3
asked in Process Analysis
Size of Beads in Simulation while moving from one Activity Node to another

Hello Team, I have query and have attached a picture of it in this Topic. While running simulation, I have observed that the beads move from one activity to another but have different sizes. Can you please tell me what does the different sizes of the beads technically/functionally mean(image attached). I was assuming that the size of the beads should be uniform as it indicates individual cases. Please correct me if Im wrong.Thank You. Warm Regards, Jayanta

00
.
Level 3
R
Level 2
raghu.raghu12Level 2
asked in Process Analysis
Exporting Workspace analysis to PDF or PPT format

Hi Team, I am new to this Celonis, i have a doubt like can we export the workspace analysis which we created in Process analytics to PDF or PPT format. can anyone please clarify my question. Thanks in advance. Regards, Raghu

00
R
Level 2
.
Level 2
.14600839Level 2
asked in Process Analysis
Boxplot filter is correct?

Hi,everyone, I created an analysis using boxplot, but the filter didnt work well. PQL statement Column chart DimensionHOURS(PU_FIRST(casetable,activityTable.EVENTTIME)) KPICase Count TPTAvg. AVG(CALC_THROUGHPUT(CASE_START TO CASE_END, REMAP_TIMESTAMPS(activityTable.EVENTTIME, MINUTES))) Boxplot Distribution AxisCALC_THROUGHPUT(FIRST_OCCURRENCE[<%= From %>] TO FIRST_OCCURRENCE[<%= To %>], REMAP_TIMESTAMPS(activityTable.EVENTTIME, MINUTES)) From,To Activity name Dimension AxisHOURS(PU_FIRST(casetable,activityTable.EVENTTIME)) image20641236 131 KB If I selected 11 on the column chart, I assumed that the boxplot also shows 11. However, it is displayed 0.Same for other values image20631246 136 KB Is it IBCs specification? Or something wrong with my PQL statement? Best regards, Marie

40
.
Level 2
.
Level 1
.14600939Level 1
asked in Process Analysis
Does Celonis has ability to consume Live Data Connection

Hi team, Does Celonis has the ability to consume on live data and give the insights?

10
D
Level 2
P
Level 3
pritam.roy20Level 3
asked in Process Analysis
Alerts After the Celonis Data Job Execution

Hello, We are running a number of Data Jobs, including Extraction and Data Jobs, can we get the alert of the log either successful or error message in our mobile. We are getting the data in our mail.

40
V
Level 1
N
Level 1
nicola.passeLevel 1
asked in Process Analysis
Process Explorer Automation

Hello, I dont know why everytime I try to use the Process Explorer in my analysis I cant show the automation rate of the activities. Every time I insert a Process Explorer component it appears without the Automation KPI. I tried to set it up by myself in the Analysis Settings, Process Explorer KPIs but probably I dont use the right code Should I also include some formulas in Saved formulas & Variables ? If yes, which ones? Many thanks for your precious help

20
V
Level 1
A
Level 3
alexander.alexaLevel 3
asked in Process Analysis
How to COUNT MAX/MIN per one user

Hi, I am trying to solve a case. How to count numbers (MAX and MIN) of events in single KPI. Need to know how many events take on one user. I have two users. They have different numbers of events min 1 and the other one max 20. I need to make a count of events per user to get max 20 in single KPI. I tried to use a standard KPI maximum events per case but it is not what i need. 2020-07-30_12-57-17769203 9.74 KB

40
A
Level 3
.
Level 2
.14600933Level 2
asked in Process Analysis
Filters for PU functions on date

Hey Guys, I had a quick question about filters on Pull up functions. I am trying to create a dashboard that displays Sum of spend by vendors. But i do this by Pull up function (because I use it as a dimension to categorize). I know we can put filters on the pull up function PU(child table, parent table.column [,filter expression]). My question is can we put more than one filter in the expression? I want to be able to filter for the month and year. I was able to filter for month but couldnt filter for year. Is there any way to put filter for year and month in date format ? Because I want the user to be able to input year and month to display information

100
C
Level 1
R
Level 1
rick.macke11Level 1
asked in Process Analysis
Take minimum of two groups in Celonis front end

We are working on an issue where we would like to list the lowest order number activity within a certain case key, within a certain change number. E.g. picture attached might clarify the situation a bit more. We want to do this in the front-end (the dashboards) of Celonis.

00
V
Level 1
M
Level 3
masha.galitLevel 3
asked in Process Analysis
Drop down/filter by attribute of a specific activity

Hi everyone, I need to create a drop down that will allow me to filter cases shown in the analysis by the value of a specific attribute of a specific activity. In particular: I need to filter cases where activity remove billing block was performed either by user type A or B. Process O2C in SAP, if that is important. Thank you very much in advance Regards Masha

10
M
Level 3

Badge Winners

  • Value Assessment Expert
    rmandradhas earned the badge Value Assessment Expert
  • Qualified to Create and Deliver Demos
    rmandradhas earned the badge Qualified to Create and Deliver Demos
  • Celonis Certified Data Analyst
    caroline.wende13has earned the badge Celonis Certified Data Analyst
  • Qualified to Prove Celonis Value
    rmandradhas earned the badge Qualified to Prove Celonis Value
  • Qualified to Build Views
    shahbaz.maniyhas earned the badge Qualified to Build Views
VIEW ALL
Community Code of Conduct