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.

  • 664 Topics
  • 1,671 Replies
662 Topics
D
Level 3
daniel.diers12Level 3
asked in Process Analysis
No common parent: Solution with Pullup possible?

Hi all, I have the following issue: I have 2 tables Table1: articlenumber, Table2: articlenumber, I have no key defined in data model due to other reasons. Is it possible to define the key in the analysis, e.g. by using the pullup function so use both tables together (e.g. to find out how many articles are in table1 but not in table 2? Many thanks and br Daniel

30
J
Level 1
J
Level 3
joão.francLevel 3
asked in Process Analysis
Bug with table horizontal scroling

Hi, Im getting a graphical bug where a table with horizontal scrolling in a fixed width sheet wont scroll to the end. Here is what it looks like. Untitled picture918358 6.82 KB Does anybody have a solution?

00
J
Level 1
.
Level 1
.14600915Level 1
asked in Process Analysis
How to filter column data with regex

Hello, I am trying to filter observations in particular column which begins with SYS or ENG while counting (Number KPI). How can I do it with Celonis? I have read about MATCH_PROCESS_REGEX, but did not quite get it. Please help

180
J
Level 1
.
Level 2
.14600929Level 2
asked in Process Analysis
Throughput Time between Null to First Set Delivery Block

We are trying to build a dashboard to calculate throughput time between two activities. Create SO Item with no block ( ')First Delivery Block (ZX) We are using the following PQL query is returning no values. Can you please guide us whether the pql query is correct? AVG (DAYS_BETWEEN( PU_FIRST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN = <%= start_activity_SO %> AND _CEL_O2C_ACTIVITIES.CHANGED_FROM = '), PU_LAST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN = <%= change_dev_block %> AND _CEL_O2C_ACTIVITIES.CHANGED_TO = ZG) ))

20
K
Level 1
A
Level 3
audrey.nober11Level 3
asked in Process Analysis
Search space in the reference (AP Process)

Hi, In the AP process, is it possible to do a search with all references that contained a space ? EX : DATA Reference number 12345 $5 1 2345 $10 23 451 $5 I would like to see only reference number with a space thanks in advance Thanks in advance. Audrey

00
K
Level 1
.
Level 2
.14600931Level 2
asked in Process Analysis
Executing Data Job duplicates data

Hi, a fairly basic question from a new user I expect! Im currently carrying out the Implementation Professional training. When I Execute an extraction it seems to stack a new data set on top of the first. My initial response was to make the Execution a Full Load rather than a Delta Load, but when I ran this, it ran for 2.5 hours without finishing and I had to close it down. Can anyone provide advice on next steps? Thanks! Dan

30
K
Level 1
T
Level 3
tomoki.tsuneLevel 3
asked in Process Analysis
Only Bar Chart failed to show the number of cases by process variants

Hi, I am trying to show the number of cases devided by variants of process using following dimension and KPIs. Dimension DISTINCT (VARIANT("_CEL_MM_ACTIVITIES"."ACTIVITY_JA")) ACTIVITY_JA contains the name of activities KPIs COUNT_TABLE("_CEL_MM_ACTIVITIES_CASES") Only the Bar Chart is refused to show the result showing following error. OLAP and other types of graphics elements show successfully what I want. I believe the code is pretty simple, I cannot understand why the code does not work only in the Bar Chart. I have tried following things already, fyi; writing without DISTINCTwriting with SHORTENDcounting other things e.g. ACTIVITIES Please let me know should you require additional information concerning this issue. Best

30
K
Level 1
F
Level 1
flor.allaeLevel 1
asked in Process Analysis
Save activity groups

Hello, I am quite new to Celonis, so perhaps this is a stupid question. I am investigating a process with a lot of different activities and a huge number of variants. To make some sense of it all, I am grouping a lot of the activities. However, whenever I close the analysis and reopen it later, the group definitions are gone and I have to redo all the work. Is there a way to save the activity groups? Thanks for the support!

00
K
Level 1
.
Level 2
.14600953Level 2
asked in Process Analysis
Aggregate Value Bucketing Across Levels

Hello, I have a table to aggregated values that we are trying to bucket within a dropdown. Currently when we bucket the values it filters on the line item level, but we want to filter on the aggregated value level. When we try to use a sum within our case when statement we get an error Aggregation dimension sum cannot be used together with a dimension input {AC0AD37E-4292-4773-A85D-4272482940D6}.png990187 20.2 KB {637ABF08-9E0E-4217-80FE-44EDFEA9D10D}.png802297 38.1 KB

70
K
Level 1
D
Level 3
daniel.diers12Level 3
asked in Process Analysis
Show values although there is noch key connection

Dear all, I have connected two table via a key, example Table 1 T1.Banf T1.Pos T1.Wert 123 10 X 124 10 Y Table 2 T2.Banf T2.Pos T1.Wert 123 10 X 124 10 Y 1235 10 Key: Banf, Pos In Table 2 I show the values of Field Wert from Table 1. For Banf 123 and 124 it works as the key is working. For 1235 it does not work. The whole case is not visible. I want to show the case, just the value of T1.Wert should be empty or any text like no value. How ist that possible? With CASE WHEN ISNULL it did not work. Many thx and br Daniel

00
K
Level 1
.
Level 2
.14600949Level 2
asked in Process Analysis
The aggregation function SUM cannot be used with a dimension function input. PLease check there are no aggregations and dimensions used together as function inputs

I am getting the error while creating the below KPI. Here KPI ABC_A/B/C is calculated KPI which uses SUM function. CASE WHEN KPI(ABC Categorization by Reporting Currency) = A THEN KPI(ABC_A) WHEN KPI(ABC Categorization by Reporting Currency) = B THEN KPI(ABC_B) WHEN KPI(ABC Categorization by Reporting Currency) = C THEN KPI(ABC_C) ELSE Vendor with no spend END

370
K
Level 1
mengfei.yi
Level 1
mengfei.yiLevel 1
asked in Process Analysis
What should be the time dimension of conformance checking

Dear process miners, I am playing with P2P process and I have PR item as case ID. When I am trying to create conformance ratio as a KPI in the transformation center, I am not sure whether I should BADAT field in the EBAN table or Eventtime field in the activity table. Does anyone know? Kind regards, Meyi

20
K
Level 1
E
Level 1
eleonora.jimenLevel 1
asked in Process Analysis
Is there a way to filter the process explorer based on the selection made on the execution-gaps object or to get the current filter on the view to set the filter for the process explorer.

In this particular case I want to select one of the flags and the selection will filter the process explorer for some activities

210
K
Level 1
M
Level 3
maarten.de.vrLevel 3
asked in Process Analysis
Do Execution Apps built in Studio support mobile?

Where can I find details about this, please?  Thanks,Maarten

40
K
Level 1
R
Level 4
rohit.kumar18Level 4
asked in Process Analysis
Does Transformation center allow exporting reports?

I have a query regarding sending reports for critical KPIs using transformation center. I tried to navigate through transformation center but couldn’t find any such option where I can scheduled reports.  even tried to check help support section of Celonis Below screenshot is perhaps of the older version of transformation center which is there on the help page.   It seems older version of transformation center was having different interface and there were these option of sending weekly, monthly or daily reports.  Note : There is a possibility to use the Action Engine to create reports but would prefer to use the report function of the transformation center.  Any help will be appreciated.

10
gabriel.okaba11
Celonaut
M
Level 2
mary.hope.suson11Level 2
asked in Process Analysis
Saving selection filters from one dashboard to another.

Hi,Is there a way that my filters from one dashboard can also be applied to another dashboard? For example, in my first dashboard, I filtered 2-3 dimensions and now I wanted to analyze in another dashboard those dimensions again. It could be placing a button to navigate to the link in the 2nd dashboard, but the selections filters are left behind in the 1st dashboard.

90
R
Level 4
V
Level 4
vasco.caron11Level 4
asked in Process Analysis
Is it possible to cancel a Studio Skill's Ongoing / Queued Executions?

Like the Title says, I have 18 Queued Executions of a Studio Skill that have been pending for 30m Here is a picture of the flow: Does anyone know how I can cancel / restart?It was running fine when I had just a couple of columns being written to the table, I've since added a number of columns and changed the Table Name  Thank you in advance!

40
V
Level 4
P
Level 2
pritam.roy19Level 2
asked in Process Analysis
What is the maximum number of rows we can export from any OLAP irrespective of the maximum rows we provided in the setting.

What is the maximum number of rows we can export from any OLAP irrespective of the maximum rows we provided in the setting.

170
S
Level 1
.
Level 4
.14600833Level 4
asked in Process Analysis
Gateways are not working?

Hi everyone, I set up a bpmn model for my conformance checker, but the gateways does not seem to work. Example: Here I can see, that the movement from "Erstanlage Schaden" to "Manuelle Deckung geändert" is possible. However when i look in the Conformance analysis it lists "Erstanlage Schaden" followed by "Manuelle Deckung geändert" as one of the most common violations.   Any ideas what i can do about it?  Best,Maria

00
S
Level 1
A
Anonymous
asked in Process Analysis
How to select multiple activities in Activity Selection

Hi there, our client hast 20+ activities that she has to drag and drop into the activity selection. Is there a less tedious way of doing this? One solution would be to create a new activity during the transformation step in the Event Collection.   But is there another way in the Process Analytics? Kind regards,Saša   

20
R
Level 4
O
Level 2
ozgur.gunes11Level 2
asked in Process Analysis
I want to use Crop Selection as filter for only one sheet in studio not all sheets. How can I do? I think I need to load script for that sheet. I need to basic pql for crop selection.

I need a pql of first occurrence of ACTIVITY 1 to last occurrence of ACTIVITY 2. same as crop selection part. Thanks.

50
A
Level 1
A
Anonymous
asked in Process Analysis
I was wondering when to use a skill or action flow? It seem there is an overlap in functionality or is it just me?

I was wondering when to use a skill or action flow? It seem there is an overlap in functionality or is it just me?

20
A
E
Level 4
enrique.sanch11Level 4
posted in Process Analysis
 Is there any way to set euro currency format in olap tables ?

 Is there any way to set euro currency format in olap tables ?  i like to see the amount of 3.000.000,15 € in euro format, now in celonis it is posible to see with commas like 3,000,000.15 but this is a Dollar format. ¿ Is it posible to set the currency configuration for euro ? Is there any way to set the locale configuration for currencies decimal in ',' and thousands in ',' ? Thanks in advance. 

119
E
Level 4
C
Level 2
charles.picotLevel 2
posted in Process Analysis
I encounter an issue in the Maverick Buying prebuilt App for Accounts Payable process.

I encounter an issue in the Maverick Buying prebuilt App for Accounts Payable process. One of the chart is not displayed correctly as showed below.Indeed, when I am using the KPIs that have been built by the Celonis team I got an error message. The name of the KPI as well as the error message are displayed in the picture below: How can I solve this problem ?  Thanks

22
R
Level 4
K
Level 3
khurram.shahz11Level 3
asked in Process Analysis
Table fitering with rows who have open tasks

Hi, Can we filter a table with rows only having open tasks, by defualt it shows all record and user has to select filter icon. Is there any way that we can avoid this step for user. Secondly what is the difference between closed and resolved. By default I have onyly option to close. RegardsKhurram

10
K
Level 3

Badge Winners

VIEW ALL
Community Code of Conduct