Skip to main content

Product Q&A

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

3100 Topics
R
Level 3
rahul.bhat11Level 3
asked in AI
Python:Database Type:unavailable

Hi team, I have been doing the auto-assignment of tables and DBconnection for the datamodel from python. But i am getting a problem in which the store type for a table is appearing as unavialable. This happens only some times when the datamodel is copied from some other server. But this completely removes the object of doing this in the first place. below is the screenshot. Any help would be appriciated. image722226 35.9 KB Edit: It should be as below image701141 39.7 KB

00
R
Level 3
D
Level 1
dayvson.nasciLevel 1
asked in AI
Error running ML suite examples fom ML workbench

Hello there, Im trying to use the notebooks from the examples_ml-suite folder, specifically the 04_root_cause_analysis.ipynb notebook, but Im facing the following error when running the cell: image1636228 38.8 KB image1359568 104 KB

00
N
Level 1
S
Level 3
stefan.grossLevel 3
asked in Process Analysis
Master Data Check eg. INC01 (EKKO.INCO1 vs. TINC.INCO1)

Dear all, I want to do some master data check. For certain fields check if they are used within 3 years (we have 3 year of data in Celonis). E.g. I want to mark all Incoterms from the master table (TINC) which are not used in EKKO.INCO1. First problem was the join of the mastertable. We did it via EKPO <-> T001 <-> TINC With case key SID, BUKRS and MANDT. Dont know if there is a better way. The idea was now to store the distinct values of EKKO.INC01 in a static variable like the following (there is no parent table between TINC & EKKO) static_var = distinct EKKO.INC01 CASE WHEN TINC.INCO1 in <%=static_var%> then USED ELSE NOT USED END Any ideas how to do this? Thanks in advance Stefan

40
S
Level 3
L
Level 2
luc.lucLevel 2
asked in Data Ingestion & Infrastructure
IBC: Parallel Processes Option

Im currently working on the implementation of the Celonis IBC at a client. The process were analyzing contains parallel process steps. In the old version of Celonis there was an option to indicate Child/Parent columns in the acitivity table (https://celonis.cloud/help/display/CIBC/Parallel+Processes), however I cant find this option in the IBC. Is this option already available somewhere in the IBC? If not when can we expect a release?

10
L
Level 2
P
Level 2
pooja.tiwar11Level 2
asked in Data Ingestion & Infrastructure
Multiple Data Engineers changing the same Transformation task code

I was editing the code in the Transformation task and at the same time, my colleague was also changing the same transformation task. Then, both the codes got reflected, which is not correct. Is there anyway through which we can restrict other person to access that code if someone else is working on it.

00
J
Level 1
M
Level 3
mara.aderm11Level 3
asked in Data Ingestion & Infrastructure
Concat strings at group by

Hi, in data jobs I am doing a transformation and need to concat strings in a group by statement. How can I do this? I tried using google, stackoverflow and so on, tested different methods but was not successful (https://stackoverflow.com/questions/21053477/concat-group-by-in-vertica-sql/21054041) Kr, Mara

30
M
Level 3
D
Level 3
daniel.diers12Level 3
asked in Data Ingestion & Infrastructure
KPIs from 2 tables where one table is NULL

Hi all, I have the following problem I have two tables Table 1: EBAN -> Content 50 Purchase Order Requisitions (PRs) where 40 already have a created PO Table 2: EKPO -> Content 40 Purchase Order (POs) with key connection to the PRs above. Now I have created an OLAP with two KPIs #PRs#POs When I just show the KPI #PRs the number is 50 (which is correct). When I display both KPIs (#PRs and #POs) the number ist just 40 because the EKPO for that PR is NULL. Is there any chance to show both KPIs in one OLAP but with the correct number #PRs 50 #POs 40 I use the Celonis on Prem version. Many thanks and br Daniel

10
D
Level 3
A
Anonymous
asked in Process Analysis
CASE count in relaton to selected Business Case

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

00
J
Level 1
R
Level 3
robin.pianeLevel 3
asked in Data Ingestion & Infrastructure
Parallel processes / Subprocesses

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

10
janpeter.van.d
Level 8
janpeter.van.d
Level 8
janpeter.van.dLevel 8
asked in Data Ingestion & Infrastructure
What does the Eventlog Automerge option in Data Model overview do?

Hi all, Since a short while we see the option eventlog automerge in the data model overview (see attached screenshot). However, this is not mentioned in the Release Notes or online documentation. Does somebody knows what this option is for? Thanks in advance! Bests, Jan-peter! Celonis_Automerge|690x150

10
janpeter.van.d
Level 8
.
Level 2
.14600815Level 2
asked in Process Analysis
Identify activities which reworked

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

140
F
Level 3
L
Level 2
lennart.lehma12Level 2
asked in Process Analysis
Custom Process Connection and Activity KPI

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!

10
K
Level 1
.
Level 2
.14600830Level 2
asked in Process Analysis
Number of Hours spent on Rework

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!

30
.
Level 2
S
Level 2
swathi.swath14Level 2
asked in Process Analysis
Variant explorer - Variants by Value on Case table

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?

00
S
Level 2
A
Level 3
alexander.kwaukLevel 3
asked in Process Analysis
OLAP Table KPI Date Difference - searching for minimum

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

00
.
Level 3
H
Level 2
helson.queirLevel 2
asked in Entry Products (Celonis Free Plan & TryCelonis)
Dynamic filtering issue

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.

20
H
Level 2
F
Level 2
fábio.venânLevel 2
asked in Data Ingestion & Infrastructure
Add new’s Activities on table _CEL_P2P_ACTIVITIES

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

30
F
Level 2
M
Level 2
marcuszandonellajellen.marcLevel 2
asked in Data Ingestion & Infrastructure
Number of records per table (IBC Vertica)

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

00
A
Level 2
benedikt.burgs11
Level 2
benedikt.burgs11Level 2
asked in AI
Pull Data from Data Pool via ML WB

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

120
S
Level 1
R
Level 2
rahul.bhat12Level 2
asked in Process Analysis
File connection not found

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.

00
R
Level 3
.
Level 3
.14600906Level 3
asked in Process Analysis
How to create Multi line chart graph for two dimensions

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

140
M
Level 3
M
Level 2
minakshi.malliLevel 2
asked in Data Ingestion & Infrastructure
Need to calculate time spent on Credit hold activity

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

00
M
Level 2
M
Level 3
marco.messnLevel 3
asked in Process Analysis
SUM IF Funktionality

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)

20
D
Level 2
G
Level 3
guturi.rajdeLevel 3
asked in Data Ingestion & Infrastructure
Healthcare Related Connectors

Hi, Are there any process connectors, data model and analysis in healthcare domain or pharmacy related ?

00
.
Level 3
.
Level 3
.14600843Level 3
asked in Process Analysis
User Level Calculation

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

30
.
Level 3

Badge winners

Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Center arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2025