Product Q&A

In process Analyst, the Case / Actitvity table is not arranged in proper sequence. How to arrange the process in process sequence using Query?

Dear Celonis Community,I am trying to count how many invoices have single line items, and how many have more then 2, 3, etc.I am able to get the formula to work when i create a OLAP table as per the below:image744307 5.36 KBThe Dimension = BSEG."_CASE_KEY"KPI = COUNT_TABLE(BSEG)In the third column I have the below code that produces the correct result as indicated in my table.case when COUNT(BSEG."_CASE_KEY")=1 then 1 else 0 endHowever, my intention is to count the total number of cases where invoice has only 1 line item. When i remove the dimension of Case_Key and replace it with CASES.CompanyCode, it produces a zero value.I have tried different statements such as:COUNT(CASE WHEN PU_COUNT(CASES, BSEG."_CASE_KEY") = 1THEN BSEG."_CASE_KEY"ELSE NULLEND)But this only produces a count of 0.Can you please advise what i am doing wrong, and how i can correct for this error.Thanks,Anna

Hello Team, How to get the timestamp on when the file has been last uploaded in the celonis. Senario : A Excel File has been uploaded and a transformation job has been created for the same to add the details to the DM. The Excel uploading is manual and transformation job has been scheduled. The extracted details has been represented in an Analysis. Need to mention the details of the date when this file has been uploaded.

Hi teamThis feels like a simple question but I cant seem to find a way to do it so thought of asking - Im looking to create a OLAP table to support data validation that looks like the below:Table Name__Table CountLFA1__123EKKO__456The idea is that the OLAP will list all tables in the model to easily see the current Table Count for each table.Is there a way I can define a dimension to list all tables in the model that would populate the 1st column of this OLAP table with all table names?ThanksOliver

Hi allI am trying to calculate throughout time from a date column (Scheduled Due Date) to an activity event time (Record Goods Issue). I have tried CALC_THROUGHPUT and SOURCE/TARGET but it looks like the only way these will work is if I define Scheduled Due Date as an activity.Is there a way of coding this without creating a new activity?ThanksOliver

Hi, We have 2 Data Models both with the same customer table. In the first data model I have customer_credit with a 1-1 relation with the customer table. Celonis links them in the data model as 1-n (customer-customer_credit) However in the second data model the same 2 tables are linked with n-1 (customer-customer_credit). How can I ensure the link is 1-n when the tables are 1-1? Best, Joo

What if i create subsequent/multiple versions of the process in the platform and wants to retrieve previous versions, how can i access it ?, where are they stored?

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.

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.

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

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

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

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

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

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

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.

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

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.

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

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

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?

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

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

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

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