Skip to main content

Product Q&A

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

4441 Topics
M
Level 2
manohar.sairaLevel 2
asked in General Product Q&A
Feature Request: User Creation Date in Celonis Admin & Settings Dashboard

Feature Request: User Creation Date in Celonis Admin & Settings DashboardThis request proposes adding a new feature to the Celonis Admin & Settings Dashboard that would display the User Creation Date for each account.Purpose & Benefits: Provides administrators with visibility into when a user account was created. Helps in audit readiness and compliance checks by tracking account lifecycle. Assists in troubleshooting and access reviews by correlating account age with activity. Reduces dependency on separate audit reports for basic account details. Expected Outcome:A new column/field labeled “User Creation Date” available in the Admin & Settings Dashboard, enabling administrators to quickly filter, sort, and review users based on when their accounts were provisioned.

221
R
Celonaut
alexandre.vilan12
Level 2
alexandre.vilan12Level 2
asked in Data Ingestion & Infrastructure
Trigger chained data jobs using Action Flows

Hello everyone, I’m trying to use Action Flow to trigger chained data jobs, meaning job A is executed, once it’s done job B is executed, once it’s done job C is executed. Ideally, I would like to launch Data Model Schedule from Action Flow, but I’m only able to launch data jobs and load data model. What I’ve done so far is: 1. Creating json file with all my jobs ID (A,B,C) - Parse Json Module2. Creating a POST request using API Celonis Key, to access data pool and launch jobs, load data model -    HTTP Make a request Module3. Using Iterator module to repeat step 2 for all job IDThe issue I’m facing is, job A need to be completed before launching job B and same for job B and C (this is what I’m calling chained data jobs). Configuring a Sleep in the iterator loop greater than the running time of my jobs is working, but not optimized. My question is: Do you know if there is a way to trigger chained data jobs in Action Flow, meaning triggering Data Model Schedule or launching several jobs

121
janpeter.van.d
Level 8
llllliz
Level 2
lllllizLevel 2
asked in Data Ingestion & Infrastructure
How to use data pool parameter?

Dear community, I would like to set up a data pool parameter to allow me to switch between test and prod environment? So I would need two global variables for my data jobs:var_data_source: to allow me switch between test schema and prod schema var_table_name: to allow me when creating table to add _test at the end of the table nameI have only found the way to create parameters in EACH data job under transformation and refer to the data pool parameter. Is there a smarter way? I am still using the data integration (not OCPM). Thanks a lot!   

532
janpeter.van.d
Level 8
asdfg
Level 3
asdfg
posted in Process Analysis
Celonis value realization in real life, tips for a believable delivery?

Hi all,in Celonis sales there’s big focus on value realization yet I find the current approach by tracking value with the Transformation Hub less than ideal. For instance, the Duplicate Invoices App may assume that all identified invoices are saved cash, but in reality vast majority of such invoices could’ve been automatically blocked by ERP anyways.Do you guys have some good examples from real life where you were able to demonstrate significant amount of realized value (in $$$) companies got from Celonis implementations? How much of the value was purely Celonis’ merit and how much was it based on process improvement programs companies were undertaking regardless of Celonis?I think this discussion is needed, especially in smaller markets (I’m based in Norway), as the licensing model is much driven by value realization assumptions.

311
alexander.skars
Celonaut
Saba
Level 4
SabaLevel 4
asked in Process Analysis
Add to Data Model

Hi everyone, How can I add something to the existing data model? Thanks!

212
Saba
Level 4
benene
Level 2
beneneLevel 2
asked in Process Analysis
Custom CALC_THROUGHPUT filter shows different results than built-in Throughput Time Explorer

Hello everyoneI'm relatively new to building custom Celonis components in Studio and I've hit a wall with something that seems like it should be straightforward. Hoping some experienced folks here can point me in the right direction.The issue: I'm trying to replicate the built-in throughput time explorer with a custom component, but I'm getting different results:Built-in explorer: 12k cases (1-day filter) My custom component: 13k cases (same filter)What's confusing me:I exported both results and compared them - all 12k cases from the built-in are in my results My component has ~1k additional cases that seem valid when I check them manually These "extra" cases definitely meet the 1-day criteria, so why does the built-in exclude them?My current filter:FILTER CALC_THROUGHPUT(FIRST_OCCURRENCE [ '${start_activity}' ]TOFIRST_OCCURRENCE [ '${end_activity}' ],REMAP_TIMESTAMPS("TABLE"."EVENTTIME", MILLISECONDS) )/ 86400000.0 BETWEEN ${min_days} AND ${max_days}; Questions:Did I make a mistake in

220
benene
Level 2
mukesh.gupta11
Level 4
mukesh.gupta11Level 4
asked in Data Ingestion & Infrastructure
Does anyone have the steps to do the data integration with the Dynamics 365 for order to cash process?

Does anyone have the steps to do the data integration with the Dynamics 365 for order to cash process?

124
asdfg
Level 3
R
Level 2
raluca.wurziLevel 2
asked in Process Improvement
Scripts for Infor-ERP system

Dear Celopeers, We already extracted the relevant tables from the customers system. Nevertheless, as the cutsomer is using Infor, we are lacking the expertise with this software.Are there any scripts available which we can use in order to facilitate the next steps? Thank you! Kind regardsRaluca

307
asdfg
Level 3
A Rab
Level 3
A RabLevel 3
asked in General Product Q&A
A module to stop the action flow at some point

Hi,I have an action flow with a Router module, and I want one of the branches to just end the Action Flow without going through the rest of the Modules in the Action Flow. Because I have an Aggregate module, it always continues executing from there, so I want to just stop the Action Flow at specific condition. Thanks

172
A Rab
Level 3
R
Level 3
roshan.kumar13Level 3
asked in General Product Q&A
Data model relation for two tables which are related in 1-N relation(VBAP:1 and VBRP:N).

These two tables are related in 1-N relation(VBAP:1 and VBRP:N). Also in some cases there are no entries in VBRP(AUBEL and AUP) for some entries in VBAP(VBELN and POSNR). I am creating an Olap to find all entries in VBAP (VBELN and POSNR) which does not have related data in VBRP(AUBEL and AUP) but they dont show up in olap. If i remove the VBRP columns from olap then they show up.

112
M
Level 2
lisaschneider
Level 2
lisaschneiderLevel 2
asked in General Product Q&A
Issue with PQL to adapt KPI to line chart months

Hi!I’Ve been struggling with setting up the correct PQL for visualising a KPI on a line chart showing a timeline as the formula became quite complicated. Would appreciate any help on understanding what query I need or why it is not working.  The KPI I want to display on a timeline chart is a cancellation rate. The view contains an input dropdown as a variable  ${outlier_analysis_selection_main.pql} which the dashboard should adjust to. The dimensions of the line chart are ROUND_MONTH("CASE_TABLE"."DSL_ORDER_DT").  In the line chart, I already have the overall cancellation rate.This does not adjust to any user filtering done through the dashboard, nor the selection through ${outlier_analysis_selection_main.pql}. I also have another cancellation rate line which does adjust to any user filtering done. I can therefore compare the development of the cancellation rate for whatever is selected to the overall cancellation rate. Now I want to add a line that always shows me the cancellation rat

91
janpeter.van.d
Level 8
Maurits de Vries
Level 2
Maurits de VriesLevel 2
asked in Process Analysis
How can I create a table from the following code?

I have the following lines of code for which I would like to create a table in which we see the total amount of transaction codes, another column with total amount of transaction codes per company code and the amount of transaction codes as a percentage of the total transaction codes, per company code.In the back end I have managed to write these codes, however, because of a lack of the 'Over' function I can't seem to be able to make it work in the front end. These are the codes in question that are currently working in the transformation scripts ( back-end ):select TRANSACTION_CODE,ACTIVITY_EN,Company_code,Count(TRANSACTION_CODE) as count_tcode,SUM(count(TRANSACTION_CODE)) OVER(PARTITION BY Company_code) AS total_per_Company_code,ROUND((count(TRANSACTION_CODE) * 100.0 / NULLIF(total_per_bukrs, 0)), 2) AS percentage_per_Company_codeFROM _CEL_AP_ACTIVITIESGroup by TRANSACTION_CODE,ACTIVITY_EN,Company_codeHow would you go about creating a PQL script that could tackle these lines of code

231
janpeter.van.d
Level 8
Leslie Lei
Level 3
Leslie LeiLevel 3
asked in Data Ingestion & Infrastructure
How to restrict the scope of filters

Dear Celonis users, I only know how to create a filter in KM and apply it to a table.  I would like to restrict the scope of filters, so that they will only have impact on one tab, when I put those filters in the filter bar. Is it possible to achieve this goal on Celonis web version?

263
janpeter.van.d
Level 8
tfaruq Rotork
Level 2
tfaruq RotorkLevel 2
asked in General Product Q&A
Past Celosphere (2023 & 2022) video on-demand no longer available ..

Hello,Im no longer able to access past Celosphere (2023 & 2022) video on-demand. I belief it used to be https://www.celonis.com/celosphere/2023/recordings/watch and https://www.celonis.com/celosphere/2022/recordings/watch respectively. Currently URL redirect to 2024. Is there any chance to watch year 2024 and 2023 past recordings? Thank you. 

60
tfaruq Rotork
Level 2
bhargav.bhima
Level 2
bhargav.bhimaLevel 2
asked in General Product Q&A
Need help with PQL filtering

Hi,What I’m trying to do is essentially pick the last but one non-automated user from the event log and pull it to object level. The previous non-automated user needs to be different from the last non-automated user.In the sample data shown below the desired output would be JANE.I’ve tried looping one PU_LAST and using it as filter for another PU_LAST but doesn't seem to be working.PU_LAST( OBJECT ,  EVENT_LOG , EVENT_LOG NOT IN (PU_LAST( OBJECT, EVENT_LOG,EVENT_LOG NOT IN (‘AUTOMATED’) ))  ,  ’AUTOMATED’).EVENT LOG ID USER 1 JACK 2 JANE 3 JOHN 4 AUTOMATED 5 JOHN  Any insights would be much appreciated.

1238
fabian.wende
Level 2
asdfg
Level 3
asdfg
posted in General Product Q&A
Celonis-support for OCEL standard

Hi folks,what’s your thoughts about the OCEL standard for object-centric event data? Should Celonis support it and that way enable us to do ETL and keep log data outside outside the Celonis cloud, for instance in MS Azure?It would be interesting to hear if Celonis has given a thought about implementing OCEL or not.https://ocel-standard.org/1.0/

323
asdfg
Level 3
M
Level 1
michael.lenzLevel 1
asked in General Product Q&A
Action Flow: Sharepoint Online XLSX Question

I have the following problem: I would like to upload a .XLSX file into my workspace via an ActionFlow. The .XLSX file is located on SharePoint Online. I can download the file using the "Download a File" action (Microsoft SharePoint Online) in the ActionFlow. However, I'm stuck at that point. In the output, the data is in "binary" format. How do I convert it from binary back to something I can import into a workspace? I have tried many things, but I just can't find the solution. Does anyone have any advice?

924
Arnab17
Level 2
Saba
Level 4
SabaLevel 4
asked in General Product Q&A
ABAP

Hi everyone,I’m trying to convert an ABAP statement into PQL but I’m not sure how to do it.In ABAP I have:SELECT SINGLE *  FROM vbap  INTO ls_vbap WHERE vbeln = ls_vbbe-vbeln   AND posnr = ls_vbbe-posnr. I think In SQL this would look like:SELECT *FROM VBAPWHERE VBELN = :ls_vbbe_vbeln  AND POSNR = :ls_vbbe_posnrLIMIT 1; But I don’t know how to express the same logic in PQLDoes anyone have any idea?Thanks!

240
Saba
Level 4
M
Level 2
maxim.vnoutLevel 2
asked in Celonis Free Plan
Celonis license

Hello,I reached out through the Celonis contact form, but I’m looking to speak directly with someone regarding licensing. Specifically, I’d like to know whether it’s possible to obtain a license and what the pricing options are.Could someone point me in the right direction?Thank you,Max

130
M
Level 2
Leslie Lei
Level 3
Leslie LeiLevel 3
asked in Data Ingestion & Infrastructure
Cross tables filtering doesn't work in N to 1 to N data model

Hello Celonis users, Good day. There is no chance for me to change anything in the data model and I mainly work in PQL Editor. My goal is to use fields from N-side tables to filter data and visualize it. More details:Data model: Table A [N] → [1] Table B [1] ← [N] Table C Table A:Material code            Warehouse            Procurement type1                                  Australia                    External1                                     USA                        Own produced2                                      UK                          Own produced2                                      USA                         Others3                                   Austrialia                   External3                                       UK                          Own produced Table BMaterial code              Responsible1                                        Martin2                                         Mary3                                         Julia Table CMaterial

826
joaocarlos.macie
Level 3
pavan.bhara13
Level 3
pavan.bhara13Level 3
asked in Data Ingestion & Infrastructure
Microsoft Entra authentication

Hey everyone! Has anyone tried using the Microsoft Entra authentication to create a connection between Microsoft SQL and Celonis? (https://docs.celonis.com/en/connecting-to-microsoft-sql.html#UUID-9e582e53-55d8-d3e9-7b6c-1e122f4219d9_section-idm4544307539120034248385337057)We are trying to enable this and Celonis Help source documentation we stumbled upon provides how an Entra authentication works (https://learn.microsoft.com/en-us/sql/connect/jdbc/connecting-using-azure-active-directory-authentication?view=sql-server-ver16) but we miss the steps on how do we set it up in Celonis directly. Any insights on the actual setup would be very much appreciated. TIA! Good day! 

80
pavan.bhara13
Level 3
A Rab
Level 3
A RabLevel 3
asked in General Product Q&A
Preselect dates in the date range component

Hi,I would like to select an item from a dropdown list, then have the from date and end date already marked in the date range component for that selected item, is that possible in Celonis? and how? Thanks a lot.

151
N
Celonaut
jan.hagem
Level 3
jan.hagemLevel 3
asked in Data Ingestion & Infrastructure
Automating Data Ingestion of External Statistics (Destatis) into Celonis

Hi everyone,in our Procurement analysis we are evaluating price developments and also compare them with external reference data provided by the German Federal Statistical Office (Destatis). The data is available as CSV flat files, which we currently download and manually integrate into our data model.I was wondering:👉 Has anyone already built an automated data ingestion pipeline for this kind of use case (regularly pulling official statistics or external CSV-based sources into Celonis)?👉 If yes, what approach or tools did you use (APIs, connectors, scheduled pipelines, etc.)?Any insights or best practices would be highly appreciated!Thanks in advance 🙌

150
N
Celonaut
M
Celonaut
mateusz.miaraCelonaut
published in Process Intelligence Graph (PI Graph)
Shipped Not Invoiced App version 1.

Shipped Not Invoiced App version 1.0.0 (2023-08-01) App version now available for object-centric process mining A Shipped Not Invoiced app version that supports object-centric process mining is available now from the Celonis Marketplace. The object-centric version of the app uses the Order Management perspective that’s supplied with our object-centric data model. Before you set up the object-centric version of the app, you’ll need to load the object-centric data model with your data and validate the Order Management perspective. The app uses the objects and events that you’ve already built from your source system data and stored in the OCPM Data Pool. To get started, see Quickstart: Extract and transform your data into objects and events. To use this version of the app, you'll need a Celonis EMS subscription that includes object-centric process mining. If you can't see the Data > Objects and Events option in your Celonis environment, your team doesn't have this feature y

521
Joe-Hartzel
Level 3
E
Level 3
ewa.aniśkLevel 3
asked in General Product Q&A
How can we apply colours to charts/process explorer/tables in Views?

How can we apply colours to charts/process explorer/tables in Views?

416
Joe-Hartzel
Level 3

Badge Winners

  • Celonis Technical Expert
    Pablo MChas earned the badge Celonis Technical Expert
  • Qualified to Get Data Into Celonis
    Pablo MChas earned the badge Qualified to Get Data Into Celonis
  • Qualified to Build Action Flows
    Pablo MChas earned the badge Qualified to Build Action Flows
  • Qualified to Write PQL Queries
    Pablo MChas earned the badge Qualified to Write PQL Queries
  • First Post
    Sergihas earned the badge First Post
VIEW ALL
Community Code of Conduct