Product Q&A

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

Hello, I have an issue with the Parallel processes feature. Here is my activity table and my process configuration in the data-model: CELONIS_ACTIVITY TABLE990362 9.84 KB This is what I expect to see in the process explorer: But this is what I get CELONIS_REAL91534 10.1 KB I do not know why the parallel process configuration is not taken into account Thank you in advance for your help, Best Regards Robin

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! 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 proj

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