- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

1 month ago

Home
Community
Product Q&A

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

3023 Topics

Recently active

Most replies Most views Newest first

hari.galla11Level 2

asked in Process Analysis

Process Analyses is not working due to error message CrashedEngineException

When i open analyses the following error message is occurred. Error Message: com.Celonis engine transports exceptions CrashedEngineException Process Engine Node 100975043 has been shutdown Could you please advise what needs to be done to fix it.

4 years ago

jasper.schik11Level 2

asked in Data Ingestion & Infrastructure

Filter out cases that start before a certain year

Hey all,Is there a way to filter out all cases that start before a certain year?I tried the following:FILTER YEAR(P2P_-_Q2_2018_csv.TIMESTAMP) => 2016But this still gives me cases that start in 2015 in an OLAP table, because there are also activities performed in 2016.

4 years ago

kavya.kadiy13Level 2

asked in Data Ingestion & Infrastructure

Issue with proportion of #change activity/#cases ratio

Hi ,I am encountering wrong results with change ratio formula below.SUM(KPI(Priority - Change_Indicator))/ COUNT_TABLE("_CEL_ITSM_CASES")where KPI(Priority - Change_Indicator) isCASE WHEN MATCH_ACTIVITIES(NODE_ANY[ Change Priority Medium to Low, Change Priority Low to Critical, Change Priority Low to High, Change Priority Low to Medium] ) = 1 THEN 1.0 ELSE 0.0 ENDFormatting used is Percentage With DecimalsThis KPI was working fine in our dashboards from long time and started giving weird values since few weeks with same formula.The results of numerator and denominator are ok when executed separately . The only problem is when I combine with both / operator.It also works fine when I change the numerator from MATCH_ACTIVITIES to CASE WHEN _CEL_ITSM_ACTIVITIES.ACTIVITY LIKE %Change% but I dont want to use this because there are tens of formula which need to be modified.I could not identify the exact issue so far to address the customer question-why do same formula give wrong res

4 years ago

steven.berndLevel 3

asked in Data Ingestion & Infrastructure

Deviding KPI1 / KPI2 does not work. Why?

Hello everybody,I have a problem, which is definitely easy to solve, but I lack the idea.I have a KPI 1:COUNT (DISTINCT CASE WHEN EBAN. LOEKZ = X THEN EBAN. BANFN ELSE NULL END)I have a KPI 2:COUNT (DISTINCT CASE WHEN MATCH_ACTIVITIES (NODE [Technical Clarification]) = 1 THEN EBAN. BANFN ELSE NULL END)I would like to divide KPI 2 / KPI 1 in a new KPI 3.The new formulaCOUNT (DISTINCT CASE WHEN MATCH_ACTIVITIES (NODE [Technical Clarification]) = 1 THEN EBAN. BANFN ELSE NULL END)/COUNT (DISTINCT CASE WHEN EBAN. LOEKZ = X THEN EBAN. BANFN ELSE NULL END)unfortunately does not work that way.Can anyone help why?Thanks a lot

4 years ago

sandhya.pundiLevel 1

asked in Process Analysis

Prerequisite for process mining?

Hey All, im doing some evaluation for process mining and want to know the pre- requisite for this. Thanks, sandhya

4 years ago

bavaji.shaikLevel 2

asked in Data Ingestion & Infrastructure

Sum of Distinct count of activities in case statement

Hi Community,I need some help on this logic in code editor to give % of completed orders at second time.Sum(All Completed orders with conditional activity = 1 Reason) & Sum of all completed ordersThere are multiple REASONS in Activity column but i need only completed orders with one REASONTrying to calculate the % from a table based on certain activities but limited to the count = 1 .Can you please help with the case statement how to get the % based on above. Here i want to get only count of REASON = 1 for the status & activity = completed for each case.COUNT (DISTINCT CASEWHENtable.ACTIVITY = REASONANDtable.status = COMPLETED ANDtable.ACTIVITY like %COMPLETED%THEN 1 REASONWHENtable.ACTIVITY != REASONANDtable.status = COMPLETED ANDtable.ACTIVITY like %COMPLETED%THEN NO REASONELSE OTHERSEND)Thanks

4 years ago

joão.filipLevel 2

asked in Process Analysis

Filter Table based on aggregation

Hi everyone, Currently I have a table where I list all my process activities, where one of the KPIs is a calculation of the ratio of cases where a given activity is present. The calculation Im making to get this is the following: COUNT(CASES.CASE_ID)/GLOBAL(COUNT(CASES.CASE_ID)) I would then like to filter this table, so that it only shows me the activities that have a ratio of less than 1%. However, Celonis does not allow to filter on aggregate functions. Ive tried other workarounds, unsuccessfully. Is there a way for me to accomplish this and show only the desired activities? Thanks in advance for your help, Joo

4 years ago

masha.galitLevel 3

asked in Process Analysis

Time stamp (month) of a specific activity as a dimension for a column chart

Hello, Im only starting to use Celonis, so maybe my question is a super obvious one. But I need to learn somehow:) Im working on an O2C process, based on SAP. I need to create a column chart, where as a dimension I need the month when a specific activity (create delivery) happened. So, not the case creation (VBAK.ERDAT), but the time stamp of the activity create delivery. Can anyone help me to come up with a proper statement for that? Thanks in advance Regards, Masha

4 years ago

bavaji.shaikLevel 2

asked in Data Ingestion & Infrastructure

Division in KPI Case statement

Hi Team,Can you please help me with the below logic.I am using Case when statement with PU_COUNT_DISTINCT and I need to pass the sum of output to a variable of 1st condition and division with other variable on next when condition in the KPI.Appreciate if anyone helps with the pseudo code.

4 years ago

himalini.himalLevel 2

asked in Process Analysis

Color Mapping logic based on ‘like\\contains’ string

Hello Celonis team, I would like to know how I can conditionally color the columns of a column component based on like\\contains logic? I am using round_month on my x-axis but I want to color all bars for 2019 separate for the ones from 2020. In my experience, color mapping will only allow me to set a color for the entire string in the dimension. Thank you. Himalini Aklecha

4 years ago

bavaji.shaikLevel 2

asked in Data Ingestion & Infrastructure

PU_COUNT_DISTINCT code error

Hi Team,When I tried to run the below code, the errors says that "Initial parameter must be a table but not column.Note: Parent table and child tables both are same.SUM(CASE WHEN PU_COUNT_DISTINCT(table, table.Order, table.ACTIVITY = REASON) = 1 THEN 1.0 ELSE 0.0 END)Can you please help me to solve this error.Thanks.

4 years ago

hormoz.izadiLevel 2

asked in Data Ingestion & Infrastructure

Exporting Tables

Hello, Is there an option to export extracted tables on the back-end as CSV files? Best, Hormoz

4 years ago

.14600906Level 3

asked in Data Ingestion & Infrastructure

How to overwrite same CSV table while import from file?

Hi Team, In our Data model we are uploading the data through csv using import from file feature, however we need to overwrite the data every week with new upload but need to keep the table name and structure same. I tried uploading new csv file with exact same name but it creates as another new table in the data model. Is there any way we can overwrite the data through csv upload? Thanks, Amogh

4 years ago

navish.navisLevel 2

asked in Process Analysis

Functions/KPIs without Accounting for Filter

Hi, New to Celonis here. Is there way to write certain KPIs that do not get affected by selections & filters? Basically, I guess static variables that get sliced by dimensions? For example, on a OLAP table, if I was looking at Return Goods along customer dimensions and have Total Orders % (# of orders returned/ Total Order Count not respecting the return goods filter.). And if I change to a different dimension, I would want the KPI to recalculate too. Basically, if I filter to just returned goods, is there way to keep the total order count in the above formula refer to overall total count while being sliced by dimensions. Also, is there a recommended way to analyze such comparisons in general?

4 years ago

chanti.pLevel 3

asked in Process Analysis

Need to get Activity count for the selected Activities (multiple) from Button Drop down

Continuing the discussion from Greetings!: Hi Im new to Celonis and i have a requirement in building an analysis. Below specified is the requirement. I have configured a Button drop down and it display all the Activites list. I created a variable (<%= ACTIVITY_GROUP_1 %>) to save the selection from the dropdown. I want to calculate the selected Activity count. Below is the formula im using to get the count and it giving me correct values only if i select a single Activity. When i select multiple Activities i can see the variable having all the selected Activities seperated by comma(,) but the result is 0. Can someone help me in getting the count of multiple Activities, and below is the formula im using. SUM( PU_COUNT(CASE_TABLE, _CEL_AP_ACTIVITIES.ACTIVITY_EN,"_CEL_AP_ACTIVITIES".ACTIVITY_EN IN ( <%= ACTIVITY_GROUP_1 %>))) Thanks & Regards, Chanti

4 years ago

navish.navisLevel 2

asked in Data Ingestion & Infrastructure

Difference between Activation_count vs. Index_Activity_type?

Hi, I am possibly missing something obvious here - What is the difference between ACTIVATION_COUNT and INDEX_ACTIVITY_TYPE functions in PQL?

4 years ago

paul.velthLevel 4

asked in Process Analysis

Filter null values (-) from a dropdown in IBC

Hello Celonis and Celonis Users, There is a dropdown we like to create without showing the null values, The dropdown is based on the activity column, so some activities have null values in them. If I filter with: FILTER ACTIVITY_TABLE.COLUMN IS NOT NULL; I see the null value drop to the bottom: I have tried additional filters like: FILTER ACTIVITY_TABLE.COLUMN !=; FILTER ACTIVITY_TABLE.COLUMN != ; FILTER ACTIVITY_TABLE.COLUMN !=-; Best regards, Paul Velthuis

4 years ago

bronwyn.murreLevel 2

asked in Data Ingestion & Infrastructure

Case Explorer no longer loads

I was wondering if you have some insight on the following issue: (1) We added a new string field to our activity table (2) When it is populated with large values (actual content varies in length from 50 100) we see two things happen: Case explorer no longer loads (we just see a blue spinner)An olap table that tries to display this field reports a broken swap file: read invalid size error (3) When we force the value to have a fixed content of length (10) everything works as expected Are there some fundamental limits set on the activity table to limit its size and make loading (application end) more efficient? Is there best practice on the structure and size of the core activity table? image1116413 7.68 KB

4 years ago

sezin.yaman12Level 2

asked in Data Ingestion & Infrastructure

Pulling columns from other tables to Case Explorer

I would like to add a column to case explorer from another table that is not the case nor the activity table. I am not using the cloud version of Celonis and I could not find a way to pull columns from other tables. There is a table that is linked to my case table, from where I want to pull a specific column which has comments. Is there a way to do this?

4 years ago

mihail.mihaiLevel 1

asked in Data Ingestion & Infrastructure

Count of cases with certain “status”

Hello friends!Will you be so kind to help with one issue:I have standard activity table: CASE_ID, ACTIVITY_NAME, EVENT_TIMEPlease find in attachment a sample of table.I want to make diagram chart (or OLAP Table) to show how many cases are being delivered at a certain month.For example -The activity Start of delivery for case #15 takes place on 05.01.2020 and the **next **activity End of delivery takes place on 10.06.2020. That mean that case #15 is being delivered on January, February, March, April, May, June.The activity Start of delivery for case #16 takes place on 07.01.2020 and the **next ** activity End of delivery takes place on 12.04.2020. That mean that case #16 is being delivered on January, February, March, April.So the diagram chart (or OLAP TABLE) should show followingMonth Case CountJan 2Feb 2Mar 2Apr 2May 1Jun 1Will you please clarify which formulas or functions I have to use.Thank you

4 years ago

adam.stefa11Level 2

asked in Process Analysis

ISNULL Function

HI, I found out there is a huge difference between using ISNULL(table.column) = 1 and different type of writing this formula (table.column) IS NULL. Do you have know from where this difference comes from ? Here is example from analysis: ISNULL(BKPF.KBR_KONT_FLAG) = 1 BKPF.KBR_KONT_FLAG IS NULL

4 years ago

clement.degirLevel 2

asked in Process Analysis

Discrepancy between PU_COUNT and Case_count

Hello community, In my datamodel, the case key is BSEG.SID||BSEG.MANDT||BSEG.BUKRS||BSEG.BELNR||BSEG.GJAHR ||BSEG.BUZEI The LFB1 and the BSEG tables are linked (1:N) with the fields SID, MANDT, BUKRS and LIFNR. I have filtered my analysis as below: FILTER LFB1.SID =FC3; FILTER LFB1.MANDT =130; FILTER LFB1.BUKRS = CN01; FILTER LFB1.LIFNR = 0000115406; There are a total of 20 cases: COUNT_TABLE(BSEG) = 20. I am doing a PU_count of the BSEG cases to the LFB1. My understanding is that I should also get 20, but I get 29 ?!? PU_COUNT(LFB1, BSEG.SID||BSEG.MANDT||BSEG.BUKRS||BSEG.BELNR ||BSEG.GJAHR||BSEG.BUZEI) = 29 Do you know what could explain such discrepancy ? Thanks in advance for your help ! Clment

4 years ago

krzysztof.sitar11Level 3

asked in Data Ingestion & Infrastructure

Export to excel OLAP with saved formula

Hello,I am trying to export to excel data which contains a saved formula in some columns. I have downloaded Celonis APP for AP: Payment behaviour. I have noticed that when I change from saved formula KPI to formula directly, then there is no issue to export to excel. If I refer to saved formula in column value, then I get error Failed: Code 500.Is there a possiblity to export data to excel which includes saved formulas in column values?Thank you in advance for clarification

4 years ago

paul.perkuLevel 2

asked in Process Analysis

Using Variables for calculation

Hi all, I want to calculate the time difference between two activities in an OLAP table. Based on the amount of the time difference I want to use another unit. Is it possible to create a variable which gives you a result based on the row in the OLAP? For example: Event From | Event To | Time between Post Invoice | Pay Invoice | 30 Days Post Invoice| Cancel Inovice | 2 Hours This code in the variable will be only calculated once. Therefore the variable unit give me in the second row 2 Days instead of 2 Hours. CASE WHEN MEDIAN(DATEDIFF(ss, source(WFMT_EVENTS.TIMESTAMP), target (WFMT_EVENTS.TIMESTAMP))) < 120.0 THEN sec WHEN MEDIAN(DATEDIFF(ss, source(WFMT_EVENTS.TIMESTAMP), target (WFMT_EVENTS.TIMESTAMP))) < 7200 THEN min WHEN MEDIAN(DATEDIFF(ss, source(WFMT_EVENTS.TIMESTAMP), target (WFMT_EVENTS.TIMESTAMP))) < 86400 THEN h ELSE Days END

4 years ago

takayoshi.ichikLevel 3

asked in Process Analysis

Aggregation based on cases on PE

Hi Community. I am trying to put average of CS(Customer Satisfaction) on PE. The CS is based on Cases. I set Custom KPI like below. avg(case_tbl.cs) avg(source(act_tbl.cs)) They returned average based on activities. I thought PU functions would work and tried them, but they return the same value. avg(PU_MIN(case_tbl, act_tbl.cs)) avg(PU_MIN(case_tbl, source(act_tbl.cs))) avg1353839 98.7 KB Is there any way to calculate average based on cases in PE ? Thank you.

4 years ago

Page 111 / 121

Badge winners

xin.shihas earned the badge Qualified to Build Analyses
laura.walku11has earned the badge Celonis Certified Data Engineer
alessio.vasinhas earned the badge Celonis Technical Expert
alessio.vasinhas earned the badge Qualified to Build Action Flows
eric.gring11has earned the badge Qualified to Manage Implementation Projects

Show all badges

Terms & Conditions

Sign up

Already have an account? Login

Login with SSO

Login to the community

Login with SSO

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

ANY QUESTION?

Talk to an expert

FAQs

MORE CELONIS

Academy arrow_outward

Documentation arrow_outward

Support Center arrow_outward

Partner Portal arrow_outward

Marketplace arrow_outward

CHECK US IN

YouTube

Instagram

Facebook