Skip to main content

Product Q&A

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

3101 Topics
V
Level 4
vivek.mLevel 4
asked in AI
ML Dataset example to try with Celonis?

Hi All, Am currently working on ML. Can I get the sample Dataset for the ServiceNow or SAP Applications ? Br/VM

20
V
Level 4
L
Level 2
latife.atalaLevel 2
asked in AI
ML Suite Samples

Hello, All. We were working on the examples that once you published your ML suite website. Such as, Anomaly Detection, Duplicate Payments, Root Cause Analysis However, yesterday when I visit the website I couldnt find the samples. Coul you please let me know where can I find them? Since we are trying to adapt those logics into our P2P and AP processes. Thank you! Latife

10
S
Level 1
N
Level 1
nabaa.refaiLevel 1
asked in AI
Python API: Find and replace field names within an analysis

Hi, is there a way we can use the python API to find and replace field names specified in PQL within an analysis? For example, Im linking an existing analysis to a new data model and some of the field names differ slightly e.g. BSEG.TS_AUGDT is now BSEG.AUGDT. Is there a way I can easily update the PQL to use the new fieldname definition via the API without having to update manually via the front end?

00
S
Level 1
A
Level 2
amruth.mudda11Level 2
asked in AI
PQL Query Celonis ML

Hi Team , Is there any simple way to write a PQL query for select * from table name in celonis ML for get_data_frame(query). As of now we need to add all the column names separately one after the other PQLColumns(). Any suggestions would be helpful. Thank you Amruth

40
S
Level 1
M
Level 1
milos.markoLevel 1
asked in AI
On time delivery, feature recommender issue

Dear Team, I try to perform a on time delivery machine learning technique with the *cel11920939 217 KB *" but I receive error on my data set. I wanted to ask is there a tutorial on how should we do whole procedure, for example I tried to import tables connected with foreign key, but I do not know is that proper connection, is the data set I am using proper (it has activity name, timestamp, index etc) should I try to execute it in training.celonis.cloud or it does not play any role. Please if you have datasets you could share with me or whole tutorial of on time delivery and not just in .ipynb file, I am getting KeyError: Model Setup 5/5 (see picture) Best regards Milos Markovic WU Vienna

20
S
Level 1
T
Level 1
theresa.wettiLevel 1
asked in AI
Long loading time for opening empty app in ML workbench

Dear team,is it normal that it takes more than 20 min to open an (empty, newly created) app (smallest memory, storage and CPU limit). If not, what might be the reason? Thank you very much in advance.

00
S
Level 1
D
Level 2
daniel.lopez13Level 2
asked in General Product Q&A
IN specfic analysis the activity selection is not working, the list of activities is blank.How can I enadble it?

IN specfic analysis the activity selection is not working, the list of activities is blank. How can I enadble it?

30
D
Level 2
.
Level 2
.14600929Level 2
asked in Process Analysis
Throughput Time between Null to First Set Delivery Block

We are trying to build a dashboard to calculate throughput time between two activities. Create SO Item with no block ( ')First Delivery Block (ZX) We are using the following PQL query is returning no values. Can you please guide us whether the pql query is correct? AVG (DAYS_BETWEEN( PU_FIRST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN = <%= start_activity_SO %> AND _CEL_O2C_ACTIVITIES.CHANGED_FROM = '), PU_LAST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN = <%= change_dev_block %> AND _CEL_O2C_ACTIVITIES.CHANGED_TO = ZG) ))

20
K
Level 1
A
Level 3
audrey.nober11Level 3
asked in Process Analysis
Search space in the reference (AP Process)

Hi, In the AP process, is it possible to do a search with all references that contained a space ? EX : DATA Reference number 12345 $5 1 2345 $10 23 451 $5 I would like to see only reference number with a space thanks in advance Thanks in advance. Audrey

00
K
Level 1
.
Level 2
.14600931Level 2
asked in Process Analysis
Executing Data Job duplicates data

Hi, a fairly basic question from a new user I expect! Im currently carrying out the Implementation Professional training. When I Execute an extraction it seems to stack a new data set on top of the first. My initial response was to make the Execution a Full Load rather than a Delta Load, but when I ran this, it ran for 2.5 hours without finishing and I had to close it down. Can anyone provide advice on next steps? Thanks! Dan

30
K
Level 1
T
Level 3
tomoki.tsuneLevel 3
asked in Process Analysis
Only Bar Chart failed to show the number of cases by process variants

Hi, I am trying to show the number of cases devided by variants of process using following dimension and KPIs. Dimension DISTINCT (VARIANT("_CEL_MM_ACTIVITIES"."ACTIVITY_JA")) ACTIVITY_JA contains the name of activities KPIs COUNT_TABLE("_CEL_MM_ACTIVITIES_CASES") Only the Bar Chart is refused to show the result showing following error. OLAP and other types of graphics elements show successfully what I want. I believe the code is pretty simple, I cannot understand why the code does not work only in the Bar Chart. I have tried following things already, fyi; writing without DISTINCTwriting with SHORTENDcounting other things e.g. ACTIVITIES Please let me know should you require additional information concerning this issue. Best

10
K
Level 1
F
Level 1
flor.allaeLevel 1
asked in Process Analysis
Save activity groups

Hello, I am quite new to Celonis, so perhaps this is a stupid question. I am investigating a process with a lot of different activities and a huge number of variants. To make some sense of it all, I am grouping a lot of the activities. However, whenever I close the analysis and reopen it later, the group definitions are gone and I have to redo all the work. Is there a way to save the activity groups? Thanks for the support!

00
K
Level 1
.
Level 2
.14600953Level 2
asked in Process Analysis
Aggregate Value Bucketing Across Levels

Hello, I have a table to aggregated values that we are trying to bucket within a dropdown. Currently when we bucket the values it filters on the line item level, but we want to filter on the aggregated value level. When we try to use a sum within our case when statement we get an error Aggregation dimension sum cannot be used together with a dimension input {AC0AD37E-4292-4773-A85D-4272482940D6}.png990187 20.2 KB {637ABF08-9E0E-4217-80FE-44EDFEA9D10D}.png802297 38.1 KB

20
K
Level 1
D
Level 3
daniel.diers12Level 3
asked in Process Analysis
Show values although there is noch key connection

Dear all, I have connected two table via a key, example Table 1 T1.Banf T1.Pos T1.Wert 123 10 X 124 10 Y Table 2 T2.Banf T2.Pos T1.Wert 123 10 X 124 10 Y 1235 10 Key: Banf, Pos In Table 2 I show the values of Field Wert from Table 1. For Banf 123 and 124 it works as the key is working. For 1235 it does not work. The whole case is not visible. I want to show the case, just the value of T1.Wert should be empty or any text like no value. How ist that possible? With CASE WHEN ISNULL it did not work. Many thx and br Daniel

00
K
Level 1
.
Level 2
.14600949Level 2
asked in Process Analysis
The aggregation function SUM cannot be used with a dimension function input. PLease check there are no aggregations and dimensions used together as function inputs

I am getting the error while creating the below KPI. Here KPI ABC_A/B/C is calculated KPI which uses SUM function. CASE WHEN KPI(ABC Categorization by Reporting Currency) = A THEN KPI(ABC_A) WHEN KPI(ABC Categorization by Reporting Currency) = B THEN KPI(ABC_B) WHEN KPI(ABC Categorization by Reporting Currency) = C THEN KPI(ABC_C) ELSE Vendor with no spend END

180
K
Level 1
mengfei.yi
Level 1
mengfei.yiLevel 1
asked in Process Analysis
What should be the time dimension of conformance checking

Dear process miners, I am playing with P2P process and I have PR item as case ID. When I am trying to create conformance ratio as a KPI in the transformation center, I am not sure whether I should BADAT field in the EBAN table or Eventtime field in the activity table. Does anyone know? Kind regards, Meyi

20
K
Level 1
E
Level 1
eleonora.jimenLevel 1
asked in Process Analysis
Is there a way to filter the process explorer based on the selection made on the execution-gaps object or to get the current filter on the view to set the filter for the process explorer.

In this particular case I want to select one of the flags and the selection will filter the process explorer for some activities

110
K
Level 1
M
Level 3
maarten.de.vrLevel 3
asked in Process Analysis
Do Execution Apps built in Studio support mobile?

Where can I find details about this, please?  Thanks,Maarten

40
K
Level 1
A
Level 3
alexander.grafLevel 3
asked in Data Ingestion & Infrastructure
Howto: Access system parameters

Hey,I want to access some system parameters like logged in users language and last successful dataload. Is there any possibility to do that?Kind regardsAlex

00
J
Level 1
R
Level 3
rahul.bhat11Level 3
asked in AI
Access logs from front end

Hi team, I am trying to do a usage-statistics datamodel in the front end using the Access_logging with python . I had got a folder of access_logs before i started developement. But now i need the updated versions of access logs for this usage statistics datamodel. Does someone know where this is stored or how we can access for a perticular server? Thanks in advance. image1037258 17.9 KB

10
J
Level 1
.
Level 1
.14600927Level 1
asked in Data Ingestion & Infrastructure
P2P demo data to a pandas dataframe

Hello, I am trying to use the demo P2P data as a pandas dataframe throught the ML Workbench. Following the documentation : from pycelonis import get_celonis login = { celonis_url : url api_token : token } celonis = get_celonis(**login) out pycelonis: Login successful! Hello vasilis <pycelonis.api.IBC at 0x7f6cb9719340> celonis.workspaces out <Workspace, id 0036fb70-61e7-4e8e-92d3-4aeac9d563bd, name Purchase To Pay Demo Analysis> Then when i try to find the analysis i get " No result found for id : xxx" analysis = celonis.analyses.find(0036fb70-61e7-4e8e-92d3-4aeac9d563bd) Any hints how to get the OLAP table of the P2P demo data to a pandas dataframe?

00
J
Level 1
.
Level 3
.14600774Level 3
asked in Data Ingestion & Infrastructure
Migrate Data model from Celonis 4 to IBC

Dear all, Is there any way to migrate a data model from Celonis 4 to IBC using pycelonis? Otherwise is there any method to convert a data model object to data frame to use the function push_table? Thank you in advance

00
J
Level 1
D
Level 3
daniel.diers12Level 3
asked in Data Ingestion & Infrastructure
Delete table then table pops up again (deletion nearly not possible)

Hi all, I have a big problem. I have several CSV/xlsx-filles uploaded as tables to my data model. When I try to delete one table (e.g. in data model under Tables) I click in Edit and then Remove table. After done that the table is gone, but ca. 10-12 seconds later the table comes back, magic. If I click it several times, sometimes the table is gone then. At the buttom of the Tables list there are then created several new tables like that Auswahl_Delta.xlsx_0_0_0_2_0_1_0_0_0_0_0_2 What can I do to solve that? What is going wrong? Please help me. Thx and br Daniel

00
J
Level 1
R
Level 2
rob.buijtLevel 2
asked in Data Ingestion & Infrastructure
Unit4 Business World financial ERP

In our company we use Unit4 Business World for our transactional services (OtC, RtR, PtP). Is there any experience within the community with connecting real time to the Unit4 Business World database?

00
J
Level 1
J
Level 2
jacob.visse12Level 2
asked in Data Ingestion & Infrastructure
Connecting Mendix to EMS

We want to make a connection to a Mendix platform which is hosted in the Mendix on AWS from our EMS. The Mendex documentation shows that the following endpoints are possible: Soap Rest Odata Is there anybody who has done this already?

50
J
Level 1

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