Process Analysis

Hello dear community, I`m sure you kann help me. Ive have an Olap table, in the dimension is the table, which shows certain change activities. As KPI I want to calculat a relation of case count(of change actvities)/case count (dependant of different business cases) In the denominator should be a variable, that shows the case count of different business cases. Thank you, I hope you understood me

Dear community, I would like to create an OLAP table to know which activity reworked more than 2 times. Dimension: Repeated Activities KPI: How many cases which contain rework Does anyone know how to create this table? Thank you for your support. Sugano

Dear Celonis-Team, I want to visualize the percentages of Process Connections instead of their absolute values. See the picture below: However, I am too stupid to write the function for this - I would appreciate any help how to get to this result. Have a great day and weekend!

Hello Community! I am new to Celonis, and I have been trying in the last month to develop a job where I need to identify and quantify the Reworked Activities in a Process. I was able to calculate the time spent each time the Activity is executed within a given Case, but I was unable to filter only the Reworked Activities. I only need to show the Number of Hours spent on Rework Activities. What Ive managed to build so far is this: Reworked activities highlighted in yellow image929530 137 KB image1157593 42 KB Dimension TARGET("Activities.Activity) KPI TARGET ( REMAP_TIMESTAMPS ( Activities.Timestamp, MINUTES ) ) - SOURCE ( REMAP_TIMESTAMPS ( Activities.Timestamp, MINUTES ) ) Thank you!

Hi , I want to visualise the most frequent based on the highest to lowest value of the Sales orders. E.g I have Variant 1 -Sales order -->Delivery>Invoice and the total value of sales order passing the variants is 200 ,Nr of Sales orders with this Variant -1 Variant 2 - Sales order -->Delivery Value- 100 and Nr of Sales orders passing through - 2 This should be shown as Variant 1, Variant 2 in Variant explorer . Currently its showing Variant 2>Variant 1 as its based on frequency. How can we achieve this?

Hi Community, I would like to calculate the date difference from the minimum activity start date of the corresponding case to the start date of each activity. My OLAP table looks like this: Dimensions: CASE, SORTING, ACTIVITY, START TIME, END TIME Any ideas how to do this? Thanks, Alex

Hi team, I am trying to upload a .csv file in to the Celonis Frontend datamodel. but everytime i do that press on reload, im getting a File connection not found error. I searched the community and i cannot seem to find a reason for this. Any suggestion would be helpful. Thank you.

Hi Team, I am trying to create a miltiline graph for two dimensions (local market and Month) for single KPI (Average throughput time). Celonis creates separate combination for each market+Month Is there any way I can create a graph something like below image854371 24.7 KB Note: I do not want to create separate KPI for each market and throughput time as market list is quite big Thanks, Amogh

Dear All I am looking for a solution to calculate a KPI based on a condition I tried it with this statement but there is an error CASE WHEN EKBE.VGABE LIKE 2 THEN SUM(EKBE.WRBTR) ELSE 0 END)

Hi, I want to calculate the time spent by all users in all the cases handled by them in the ITSM background. Can you please help in the implementation of the same. An example of the problem is given below:- Case id Eventime Activity User 1 01-01-20 change priority A Solution should be like this:- 1 02-01-20 change severity A Time spent User 1 03-01-20 change owner A 3 days A 1 04-01-20 create action B 2 days B 1 05-01-20 execute action B 2 05-01-20 create ticket B 2 06-01-20 change priority B

Hi, I would like to merge this two filter togheter but I dont found the right formula : FILTER EKKO.BSART IN (ZNB , Z3P, ZTR, ZRS) and FILTER EKKO.EKGRP ***!= (995) with FILTER EKKO.BSART IN ( ZST , Z3P, ZTR, ZRS) and FILTER EKKO.EKGRP = 995 ; Thanks in advance.

The process flow for Accounts Payable has an activity called Due Date Passed. Does this mean that a vendor invoice is overdue? The reason of my confusion is because the definition provided by Celonis is Thereby Accounting that the invoice is paid on time before the due date passes. This is unclear to me. AP includes the following activities: (1) Vendor Creates Invoice", (2) Scan Invoice , (3) Enter in ERP System, (4) Book Invoice, (5) Clear Invoice (Payment), (6) Due Date Passed. I will really appreciate getting help on this

Hello, Good day. For OTC, we want have an OLAP with dimension: _CEL_O2C_ACTIVITIES.ACTIVITY_EN and KPI: Net Order Value (VBAP.NETWR_CONVERTED). The issue is that it is not giving the right value, especially when there are SO items that went thru the same activity more than once. For example, we have SO1 and Activity1, this SO has Net Order Value of 1 EUR and went thru the Activity1 3x, so the result of the KPI in the OLAP is 3x Net Order Value (3 EUR). We needed to output the correct Net Order Value (which is 1 EUR).

In the grouping field, I am using ROUND_MONTH(EKKO.AEDAT) as legend, but in the chart, it is showing date format as grouping column . How can I change the format to YYYY_MM ?

Hello All, Anyone knows how to use and what is the benefits of using index sheets on front end analysis? I tried using and seems its scanning open requests but not sure how is it working? Thanks, Kalpesh

I need to perform something like the VLOOKUP in PQL. In particular, in my O2C_VBAK table I added a column EDIPartner, that pulls the EDI Partner number (EDPAR.KUNNR) for the concerned VBAK.KUNNR. Now, I want to make a drop down filter in my analysis, so that user can choose different EDI Partners, and I want him to see not only the number, but also the name of that partner. If I just write VBAK.EDIPartner|| - || KNA1.NAME1, then it will take the NAME1 of the VBAK.KUNNR. How do I make it take the NAME1 of the VBAK.EDIPartner?

Hi Celonis Community! I have a question about the ability to calculate the number of repeated actions for some indicator in my situation, I want to count how many refunds are made per document within each document creator field demension - the creator of the document (unchanged during processing) kpi fields 1 column - the number of documents that were returned 1 time 2 column - the number of documents that were returned 2-3 times 3 column - 4-7 returns and so on returns - the number of events Returned by the creator of the document I accomplished this task by making 2 tables. Highlighting the values I need in the upper graph and looking at the creators in the lower table is it possible to accomplish this using one metric? image693391 7.49 KB

While applying data permission for specific user I am getting the below error while accessing the analysis. FILTER DOMAIN: Incompatible expression after IN operator: Expected INT or compatible, but got [CONST_STRING]

I added a new attribute (column) to an already existing column. I can see it in the schema: and if I try to write the code in a data job: But if I try to find it in the Formula editor in my analysis I cannot find it: Any idea what could be wrong? Thank you very much Regards Masha

Hi, I tried to build an OLAP table with les champs suivants : CHANGED_FROM : _CEL_P2P_ACTIVITIES.CHANGED_FROM CHANGER_TO : _CEL_P2P_ACTIVITIES.CHANGED_TO OverDelivery: EKPO.UNTTO UnderDelivery: EKPO.UEBTO I would like to create an column with CHANGED_FROM * OverDelivery But I received an error message. How could I do this multiplication between those tables ? image71463 2.27 KB image790124 6.4 KB Thanks in advance.

Hi Team, Need some help about Bridge Chart. I tried to create a Bridge Chart with Dimension and Sorting as below: CASE WHEN DELIVERIES.RGK_DRRA>0 AND DELIVERIES.RGK_DRRC>0 THEN Late SL WHEN DELIVERIES.RGK_DRRA<-3 AND DELIVERIES.RGK_DRRC<-3 THEN Early SL ELSE Ohters END And the Aggregation is COUNT(DELIVERIES.DELIVERY_ID) But the sorting is not what I want, and the colors are all black. Could anyone help me with sorting and changing colors? Thanks a lot.

I would like to see the workflow of 2 different task tables from SN in Celonis. The Case table and the case_task table. The issue i encounter is that the dimension Roundmonth (case record created) does a auto join for the case and task table (sounds logic). But all i want is a simple "excel"table to track the records. How can i show the trend of 2 different tables based on both their creation date?

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

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

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