Product Q&A

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! Four days ago, about Oct, 22th, I found a undesired behavior on Celonis Snap: everytime I select a filter condition by clicking on visual components, the below error message is shown: Syntax error near [AS] after reading [FILTER DOMAIN. If I select the same filter conditions by clicking on Add new selection buttom It works.

Hi, I have to add new activities to the existing _CEL_P2P_ACTIVITIES table, which was also used for analysis. CELONIS11914934 15.7 KB After i insert the new activities, i make some selects to check the data and appers that is correct. CELONIS21914934 7.71 KB After that somes ok. But when i go to add the new activitie in my analysis from Workspaces, in the new sheet i try to create a new selection, but dons appear the new activities that i insert on the table. CELONIS31914934 30.2 KB If i execute an instruction on SQL i see the activity on table, but on the analysis dons have that. Did I miss any step to do, i need to make a some regeneration table or some like that? Thanks all

Hello Celonis community,I want to determine the number of data records in vertica for all tables of a schema (SAP System).The easiest way should be via the system table tablesso I get all tables of a SAP connection, which also worksselect * from tables where table_schema = XYZbut unfortunately the following does not work:select t.table_name,(select count(1) from t.table_name) as table_row_countfrom tables as t where t.table_schema = 'XYZ-> Execution error: Not allowed to access schema tthe other way via a system table does not work reliably:SELECT table_schema,table_name,SUM(row_count) AS row_countFROM (SELECT table_schema,table_name,NVL(CASEWHEN NOT is_segmented THEN (row_count / node_cnt)::INTELSE row_countEND, 0) row_countFROM (SELECT t.table_schema,t.table_name,ps.projection_name,(SELECT MIN(is_segmented)FROM projections pWHERE p.projection_name = ps.projection_nameAND p.projection_schema = ps.anchor_table_schema) is_segmented,node_cnt,SUM(ps.row_count - NVL(dv.deleted_row_c

Hi there, in the ML workbench, there is an API call to push data to a data pool data_pool.push_table(...) Is there also a way to pull data (eg a specific table) from the data pool? Couldnt find something like data_pool.pull_table(...) Best, Benedikt

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

Need to calculate time spent on Credit hold activity for order to cash process and populate a column of OLAP table but credit hold activity is denoted by 2 names in activity table 1)Set Credit Hold 2)Set Default Credit Hold.What should be the formula for thisI have used formula(CALC_THROUGHPUT(FIRST_OCCURRENCE[Set Default Credit Hold] TO LAST_OCCURRENCE[Release Credit Hold], REMAP_TIMESTAMPS("_CEL_O2C_ACTIVITIES".EVENTTIME, HOURS)))But I need to put below condition as well for same column(CALC_THROUGHPUT(FIRST_OCCURRENCE[Set Credit Hold] TO LAST_OCCURRENCE[Release Credit Hold], REMAP_TIMESTAMPS("_CEL_O2C_ACTIVITIES".EVENTTIME, HOURS)))

Is there an inbuilt process connector available in IBC for Success Factor- a Human Capital Management system

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, Are there any process connectors, data model and analysis in healthcare domain or pharmacy related ?

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

Hi Team, I am currently working on auto-assignment of the DBConnection to the table all at once in the front end via the python code. But i am not getting any functions which can help me with that. I am able to connect to the datamodel, fetch the table ,table data and change the table names too. The only thing i am lacking is to change the DBConnection of everytable from python. I could analyze from the data of the table fetched via python that each DBConnection has their own DBConnectionID , but i am unable to change that ID from python. Please let me know if that change is possible, if so, how to do it. Thanks in advance.

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).

We have one SAP client connected already. Now we want to connect the second one, the same process (O2C). In this other client we have a separate business division, which we want to analyze separately. Current already existing analyses shouldnt be influenced by this new data load. We will probably also want to have some analyses to compare the business divisions, but we will definitely need to be able to easily create analyses separately. Will appreciate any guidance a lot. I will outline below my understanding and will appreciate comments to it. I understand that first of all we need to create the new connection. And from this instruction we only need to perform steps 1 and 6, because the server part is already there and it is not SAP client specific. Then, for the moment, since we have a data load running every night, I will add a filter on the case table (VBAP) to only take data from the first client (MANDT = CLIENTNUMBER). Because, if I understand correctly, otherwise with the next

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]

Hi Team,We are working with the conformance module in Celonis. I see an error msg popping in all my components saying that Your model contains duplicate activities. Activity A occurs in the model 2 times, Activity B occurs in the model 3 times Please try to create a model without duplicate activities as it may cause severe performance issueIn my reference model, I have used duplicate activities however they are a part of different sequence flows (e.g. two different paths after split using exclusive gateways) and also for some instances the activities can happen again in the sequence flow.Can you help me understand this error msg in detail and how exactly does it affect the performance issues?Thank you in advance!Soham Potdar