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.

  • 537 Topics
  • 1,479 Replies
537 Topics
K
koert.kritz11
asked in Process Analysis
Hi all, is it possible to make a dimension in a OLAP table static. So when I click on another dimension it does not affect the value?

Hi all, is it possible to make a dimension in a OLAP table static. So when I click on another dimension it does not affect the value?

6
K
6 months ago
L
lukas.muell
asked in Process Analysis
Rework Selection as column chart component in Daslhboard

Hello everyone, I'm still quite new to Process Mining and PQL.  How can I create the Column chart of the "Rework Selection" as a standalone component for the dashboard? In my process, there is a process flow (loop) that can occur either 0, 1, 2, 3, 4, or 5 times per case. Therefore, on the X-axis, the number of loops should be listed (0, 1, 2, 3, 4, 5), and on the Y-axis, the frequency of occurrence of each number of loops should be shown.  I tried it with this: https://docs.celonis.com/en/calculations-on-activity-sequences.html   And that works well for an OLAP table, but it only provides me with the count of loops per case and not the count of cases for each loop count (0,1,2,3,4,5). However, I cannot or do not know how to access this OLAP table in another component and sum up the counts per loop iteration. Thanks for your help! 😊

4
dennis.pflug
Level 1
6 months ago
K
koert.kritz11
asked in Process Analysis
Hi all,I have a drop down list in my analysis with multiple values, but I want one value to always be selected and you must not be able to deselect that specific value. How do I do this?

Hi all, I have a drop down list in my analysis with multiple values, but I want one value to always be selected and you must not be able to deselect that specific value. How do I do this?

2
K
6 months ago
K
koert.kritz11
asked in Process Analysis
I want to add a component filter to my chart in studio analysis that Filters it to only show values between 08:00 and 16:30. How do I do this?

I want to add a component filter to my chart in studio analysis that Filters it to only show values between 08:00 and 16:30. How do I do this?

2
K
6 months ago
M
maciej.kupcz12
posted in Process Analysis
Hi All!

Hi All! I'm wondering if this is possible in Celonis to build custom attribute (not based on any table) through which I can iterate and calculate pu functions? I want to create record which can be used for reporting purposes (extracted using PowerBI connector).In this record I want to see KPIs per month. For KPI calculations I'm taking into consideration multiple factors including dates (entry date, clearing date, etc.), so I can't build this column only base on one date field. I was thinking about creating attribute, which will contains specific range of dates (not based on any SAP table) and then, base on it, iterate by all those dates in range and set up pu functions using those dates as variable. I was trying using RANGE, but I was getting error that there is no common tables between range and for example BSEG (from which I'm taking date to compare to result of RANGE function): Time dimension in record: var_date One of the filters in PU function: "BSEG".&q

2
M
6 months ago
R
rafikahamed.moham12
asked in Process Analysis
Dear Community

Can we Add Color in Process Explorer(Views) for Particular Activities as needed?

2
R
6 months ago
R
rafikahamed.moham12
asked in Process Analysis
Dear Community

Can we Change the FONT Size or Style of KPI Names and Table or CHART Title Names in Views?

1
deeksha.r12
Level 1
6 months ago
K
koert.kritz11
posted in Process Analysis
Hi all,

Hi all, Is there a way to get saved Formulas from analysis into Knowledge model without recreating them manually?

3
matt.witty13
Level 1
6 months ago
andrea.quint
Level 1
andrea.quintLevel 1
asked in Process Analysis
How can I create a matrix type visualization in a view?

Hi Celopeers team, I have a requirement where the user needs see the data as a matrix (like a image) Basically the user needs to see the trend of various KPIs for specific dimension over time. the request is in a View someone knows, how can I do it? Thanks 😉

3
andrea.quint
Level 1
6 months ago
M
magdalena.silak11
posted in Process Analysis
Hi all!

Hi all! I am trying to track the information how many notifications are sent weekly by my Action Flow. Do you know the best way to do so? Can I add some module in the action flow that would be able to add a line whenever we have new notification to some table that I could then use in the KPI of the analysis? BR!Magda

2
M
7 months ago
andrea.quint
Level 1
andrea.quintLevel 1
asked in Process Analysis
Can I read data in the comments I have on a profile view?

Hi Celopeers Team, I have a profile view with a comment component, I need to creat an Action Flow that sent to the user especific data more de comments that there are. Does anyone know how I can read the data in the comments of an action flow? Thanks 😉

2
andrea.quint
Level 1
7 months ago
R
rafal.augus
asked in Process Analysis
How to filter records, where we want to get only those with no value? Problem both for Celonis tables and Celonis Action Flows.

Hello! Among my data I have records with four possible values in the column Class ('Inactive', 'Proc Manage', 'non-Proc Manage' and '-'). The last option occurs when there is no value for the record inside Class column.  Although without filtering I can see records with all values of Class listed above, trying to filter as in the picture, I can't get them (I receive only Inactive ones, my goal is to get empty ones also). If I want to get for example only those where Class = 'Inactive', it's easy, but what about the requirement to filter only records with no value for Class column? I don't know how to do it in a table, and inside Action Flows filtering as well. My intuitive code inside Action Flow is FILTER "MyTable"."CLASS" IS NULL , but unfortunately, there is no result. Do you have any idea how to solve this issue? I will be grateful for your support.

6
bunyod.sap
Level 1
7 months ago
A
ayushi.ade12
asked in Process Analysis
Hi All,Can we add display rules to other column on the basis of one column?I have a requirement wherein I need to show background color to entire row.

Hi All, Can we add display rules to other column on the basis of one column? I have a requirement wherein I need to show background color to entire row.

1
B
7 months ago
B
boobathi.subra
asked in Process Analysis
Passing parameter value from one sheet to another sheet

Let say i have predefined columns in sheet2 which has employee details ,So i willl send the employee id from sheet 1 to sheet2 and show employee info based on employee id. How can i achieve it. Please help on this. Note : Dynamically passing employee id

3
D
7 months ago
richa.patel
Level 1
richa.patelLevel 1
asked in Process Analysis
How to find if any specific analysis is using incremental data?

How to find if any specific analysis is using incremental data?

4
dennis.pflug
Level 1
7 months ago
C
c.m
asked in Process Analysis
How to sync two OLAP Tables with variables- one table showing a list of payers in one column with costs in the 2nd colmun. The 2nd OLAP table should show the sum of the first OLAP table.

Payer: Combined Number and Name Logic- One Payer Name can have several Payer Numbers, so Table A always shows a list of Payer Numbers/Name Combinations. Table B should show only the SUM of the Costs of the Payer name. The Customer would like to have in Table A Number and Name combined in one column, Table B should always show the SUm of the above selection.  Table A: Variable: Payer Number/Name Combined Column A, Costs Colmun BTable B: Payer Name Column A, SUM Costs Column B I think the solution could be working with variables: I added two variables: Drilldown_dimensions and drilldown_text so if I select a payer both tables respond.  In Data Transformations I combined three different payer colmuns and also three different payer number colmuns to one column. So it is not possible to select only the payer_name for the selection.

1
B
7 months ago
V
vasco.caron11
asked in Process Analysis
Is there a way to reference Knowledge Model Variables in Studio Dashboards?

Good afternoon, Just wondering if there was a way where I could use the variables we've set up in the Knowledge Model, inside the dashboards, for page filters, etc. Thank you!

4
J
7 months ago
H
hugo.deube
asked in Process Analysis
Forward filter through the URL in Studio View

Dear Celonis Team, I tried to forward a filter through the URL in an View in Celonis Studio. I followed the instructions indicated at the followig doc page: https://docs.celonis.com/en/advanced--forward-filter-through-the-url--e-g--from-an-analysis-.html. Unfortunately, although it is described in the docs using a View, the function to forward a filter via "?filters=.....Base64Tag..." does not work and the filtered View does not open after inserting the string into the URL. I wonder if there is a bug into the function, because following the proposed gif in the documentation it worked well in the past. Please help if you have experience using Views.

1
A
8 months ago
A
anil.vish
asked in Process Analysis
How to create a Change Assignee feature in the App?

I have created a table within the Studio App. The table is loaded with Tasks(Created through skills) auto-assigned to Business users in Celonis. Now we would like to have a feature to select a record and click on the change assignee button, on this click we need to be presented with a list of users to whom we can reassign the record. We built an action flow to update the email but we are only able to build a text box to input email addresses, we would like to be presented with a list of users(emails) to whom the task can be reassigned. Please let us know how we can accomplish this.

1
B
8 months ago
S
sam.weyel11
asked in Process Analysis
Is there a way to Export a Knowledge Model into a consumable and editable document?

Is there a way to Export a Knowledge Model into a consumable and editable document?

11
F
8 months ago
S
sanchit.khann11
posted in Process Analysis
I have to implement a functionality where:

I have to implement a functionality where:There is a table for my vendors with multiple line items, each line item has a Rating field which can be blank or some value.SO when I click on the Vendor code, an overlay view opens.Now on this view there is a button, clicking on which I need to perform different actions:If there is a rating for that vendor, then trigger an action flow. I have created the action flow but not the conditionIf there is no rating for that vendor, then open a message pop displaying a Text. What I need help with is, how do I put a condition on the button to check if the rating exists or not and then open the message pop up.Bros ​@Abhishek Chaturvedi​  @Dipro Banerjee​ Help! :)

3
abhishek.chatu14
Level 1
9 months ago
J
joão.macie
asked in Process Analysis
Time between two activities based on activity attribute

Hi, I need to calculate the time between two activities that are not directly followed by each other taking an event attribute into account. Example: Calculate time between A and B where: Both activities A and B happen more than once in the processTo get the correct throughput time, we need to consider an activity attribute (e.g., campaign_id). In our case, if activity A happens three times, it will have three distinct campaign ids, so we need to match those ids with the ones in activity B. How can I implement that in Celonis? I tried using SOURCE() and TARGET() from the example in this post , but it seems it only works for directly followed by activities, so there was no data for my chart, as A is never directly followed by B in this case. Thanks a lot in advance!

3
S
9 months ago
J
joyce.cardo12
asked in Process Analysis
Hi mates! I am trying to load a data model, but I am getting thi error :The export failed: Data Type Time is not supported. I know tha data type time is not supported, but how I can replace it to ony have the time populating?Thks!

1
D
9 months ago
C
cybel.itani
asked in Process Analysis
Hello, I am a temporary user but when I try to ingest the activity dataset into the data model, I get this issue: The export failed: Table contains more rows than the allowed maximum per table of 10000000 Please reduce the number of rows.

Hello, I am a temporary user but when I try to ingest the activity dataset into the data model, I get this issue: The export failed: Table contains more rows than the allowed maximum per table of 10000000 Please reduce the number of rows.

3
C
9 months ago
S
sooraj.edaya
asked in Process Analysis
Components on a single view with different Knowledge Models

Hi Community, I am trying to create a view, which has 2 different components(Tables/Charts) with different knowledge models behind it. I have created 2 separate knowledge models, but was not succesful referincing them on the same view. Does anyone has experience building components withdifferent knowledge model on the same view?  Best Regards, Sooraj

5
S
10 months ago

Badge winners

  • Certified to Build Analyses
    ben.lakho11has earned the badge Certified to Build Analyses
  • Certified to Get Data Into Celonis
    ben.lakho11has earned the badge Certified to Get Data Into Celonis
  • Certified to Build Action Flows
    ben.lakho11has earned the badge Certified to Build Action Flows
  • Certified to Build Views
    ben.lakho11has earned the badge Certified to Build Views
  • Certified to Write PQL Queries
    ben.lakho11has earned the badge Certified to Write PQL Queries
Show all badges
Terms & ConditionsCookie settings