Product Q&A

I asked a similar question some time ago, still looking for an elegant solution:Context:Currently we do all the extraction within one Data pool, that does also contain the OCPM objects and events. Since we start to connect additional systems, we want to use the approach “1 dedicated Data pool per system, 1 common Data pool for all OCPM objects and events data”Problem:I hoped to simply rebuild the existing extractions in a new Data pool and then switch the Data source within the OCPM-transformations to the new Data pool. This works totally fine for custom objects, but for Celonis objects the Data source is read-only:  What is the most “elegant” solution?One approach would be to create a view for each table: view in the old data source pointing to the underlaying table of the new data pool. ...quite a lot of (maintenance) effort and not sure whether this would work.Another approach is to create full overwrites of all transformations. But by this you loose the connection to the official c

Hi everyone,I need help figuring out how to execute a Machine Learning script directly from a button in my Celonis app in views (dashboard). I believe I might need to use Action Flows, but I’m unsure about the exact steps to make this work.Here’s what I want to achieve: When a user clicks a button in the Celonis app, it should trigger an ML script. The script could be hosted externally (e.g., a REST API) or executed within Celonis.( atm its not hosted, there is just a file in ipynb format, stored in ml workbench in  analysis. I need guidance on how to set up the Action Flow and link it to the button. Has anyone implemented something similar? If so, could you share the best approach and any potential challenges I should be aware of?Thank you in advance!

Hello Community,We have a complex data model in which the user must set three date filters (different source fields) with the same date in order to get the desired result.Like I said, he has to do it three times.Is there a convenient solution (data picker) where the user only has to set the date filter once, and the filter is applied to all three source fields?Best, Thomas 

Hi everyone,I'm working with Celonis Machine Learning Workbench (MLWB) and a Knowledge Model as the data source.Current setup:Data is queried from a Knowledge Model into MLWB. A Python/scikit-learn model is trained successfully. Predictions are generated and stored in a pandas DataFrame. The goal is to visualize those prediction results in a Studio View/dashboard.The challenge:I can generate the prediction table in MLWB, but I have not found a way to make the prediction output directly available in Studio.I'm specifically looking for a solution that does not require:Exporting a CSV from MLWB Uploading the CSV into Data Integration Manually creating new data tablesInstead, I'm trying to understand whether there is a more native integration pattern between MLWB and Studio.QuestionsIs it possible to expose a DataFrame or ML prediction output from MLWB directly to a Studio View? Can MLWB prediction results be persisted as a Knowledge Model asset, View asset, or another object that Studio c

I have multiple action flows seggregated by country and other attributes. All the AFs are writing to the same table in the data pool. Due to the execution runtime limit, I had to create multiple action flows instead of one action flow.Now all the AFs are scheduled to be executed every Monday. I can not schedule all AFs half an hour apart, as the count of AFs will only grow in the future and writing back to the data model for all AFs may take more than a day to complete.  And to use trigger at each AF is troublesome to maintain.Is there any easy way, where I can trigger the first AF execution on Monday and all other AFs will be executed one by one without any deadlock. 

Hey team,I am going through the task mining course by celonis and as I follow through the course, I am unable to create a task mining project under the task mining session, every time when I create a task mining project it is created under data integration session instead of the project session in task mining. Have anyone faced a similar issue if yes what was the solution?Thanks in advance,Akshay

Hi all,I'm trying to build a cumulative distribution curve in Studio using a line chart.Along the X Axis I have a KPI which gives me 1, 2, 3 , 4, days and so on. On the Y Axis I’m trying to show a cumulative count of items which took the amount of days shown on the X Axis to do something.I have the error in the line chart that there is undefined behaviour, no ORDER BY specified, because in the Line Chart I cannot sort by the KPI used for the X Axis.When incorporating ORDER BY as follows:    RUNNING_SUM( KPI("this is a count(distinct….) kpi"),    ORDER BY (KPI("nr. of days") ASC))I am told that I cannot use the count aggregation function together with a dimension function input.Has anyone faced something similar and found a solution? When I put the two data points into a table and sort the table by the Nr of days it works pefectly but the same sorting functionality is not taken over when I switch that sorted and functioning table to a line chart.Any ideas? Your feedback would be very mu

Hi ,We are building a Core-Plus-Delta localization architecture in Celonis Process Designer/Manager (Symbio). We have a single global master process (e.g., HR-7-3-1a) where specific steps (e.g., Step 16) need to trigger country-specific localized tasks across 10 APAC countries (CN-1a, MY-1a, SG-1a, etc.).Since the Process reference field on a task/call activity node enforces a 1-to-1 limit:What is the recommended best practice in Symbio to link 1 global step to 10 country localized sub-processes?How do you configure this so end-users in Process Navigator get a seamless 1-click experience via Scope Filters (Locations attribute) without seeing duplicate global steps?Thanks!

Hi Team, Anyone worked on Apache Kafka data connection, if so please provide relevant documentation and steps how to extract tables from it.

Hi everyone, I'm facing an issue with Machine Learning Workbench and would appreciate some guidance.I cannot access any resources from within the notebook environment: - get_data_pools() returns 0 data pools- get_spaces() returns 0 Studio spaces- Team connection appears to work- Authentication succeeds without errors- The notebook can connect to Celonis successfully Additionally, when checking permissions through PyCelonis, all services seem to return empty permission lists. In the browser UI, I can access my Studio project and Knowledge Model without any issues, but the same resources are not visible from ML Workbench. My questions are: 1. Does ML Workbench require separate permissions or resource assignments to access Studio Spaces or Knowledge Models?2. Can ML Workbench access Knowledge Models directly, or does it only work through Data Pools/Data Models?3. Has anyone encountered a situation where authentication succeeds but get_data_pools() and get_spaces() both return empty result

Good day, In my Settings view I am asking my App user to select certain events that matches a scenario. How do I include the option in my button for a NULL value if such events are not available in the data set? I save my button input into a variable. Currently I add a button next to my button to revert the variable value to NULL but I am not sure if this is the correct way to do this.Any assistance will be appreciated. Thank you.

Hi Guys,I am currently facing issues with the datapipeline between celonis studio and the machine learning workbench. The ML Workbench is unable to access Celonis data due to outdated celonis_ml dependencies that rely on deprecated sklearn functions. This breaks the built-in data pipeline and prevents direct data model access. As a workaround, data had to be exported manually as CSV and processed externally. An update to the ML environment and data connectors is required to restore full functionality.Is there a fix or a workaround for this?

Is there a way to change the data type of a KPI trend label? For example, I have a KPI called “Receivables” that is 4.5B €, and I want to show the trend with a monthly range. However, it is displayed as 12,345,678.90 instead of 12.3M.Has anyone experienced something similar and found a way to overcome this?Thanks in advance for your help!

Dear Celonis Community,I’m trying to set up KPI Meters with a certain color mapping to visualize performance against targets and benchmarks.Users can already define targets via a variable which is also possible to include in the color mapping.We managed to create global benchmarks via a write back to a custom Celonis table. Would there be a possibility to make these benchmarks a threshold?I figured that PQL inside the color mapping does not work.  

I have a Knowledge Model, and I am not sure how do I import that knowledge model data into Celonis Forms. I am only getting options for UI aspects like text, table, numbers, etc .Please someone say how to do it ?

Hello,In make.com, there is a very useful Custom Mailhook module, which triggers immediately upon receipt of an email.This module was left out in Action Flows for some reason. Why is that?I cannot use Watch Emails module, as this is polling based and the smallest polling interval would be 1 minute, which is too long for my use case. I need immediate triggering.Best,Ercan

Is it possible to Migrate from ARIC BPM to Celonis CPM?If Yes what is the procedure/steps?

Is it possible to Migrate from ARIS BPM to Celonis CPM?If Yes what is the procedure/steps?

Hey Everyone, I can connect to a knowledge model and pull the data within into the MLWB using pycelonis. But can we retrieve the knowledge model YAML code and store it in MLWB? Please help me with this concern if there is a way. 

Hi everyone, I’m looking for advice on how to track and display historical KPIs in Celonis so the values are not overwritten as source data changes over time. Example:I want to track the % of maintenance tariff codes for purchase order items (i.e., EKPO.BEST_STAWN filled vs. all items). Some of my KPIs also use relationships between EKPO, MARA, and LFA1.I need to calculate and store these KPIs in monthly intervals—to know exactly what the maintenance value was for each month in the past, not just recalculate it on current data. 1 What’s the best way in Celonis to store unchangeable monthly KPI values?2 Is it better to use Automated Table Snapshots (copy/freeze tables) or KPI Snapshotting (export results), or something else?3 If table snapshots are best, should I build them in the backend (SQL/jobs) or can I do it inside Celonis using Action Flows or some built-in module? Thanks!

Has anyone been successful in using the KPI Snapshot function within a VIEW and KM that uses a Case centric data model?The goal is to track KPI historical values via trend charts and graphs but with more user flexibility than Transformation Center enables.I’m aware of a Celonis provided Marketplace app for using KPI Snapshots as mentioned in the documentation, but it requires an OCDM. Thanks, 

During the implementation of a process analytics solution, I encountered a complex issue where the underlying data was successfully loaded, modeled, and linked through the required relationships, yet the analytical layer was unable to retrieve or display the data correctly. Despite verifying the data pipeline, model configuration, identifiers, relationships, and query logic, the visualization layer continued to return empty results. Resolving the issue required a systematic investigation across multiple platform components, extensive documentation review, and careful validation of each stage to isolate the root cause rather than relying on trial-and-error fixes.

Hi Community,I'm getting the following error while loading my data model:Could not execute foreign key join: there are duplicates on both sides of the specified key relationship.Table EKKO, key columns (MANDT, LIFNR), key ('011', '0000805024').What is the recommended best practice for resolving this issue?Should the duplicate records be removed, or should the join relationship be adjusted? If removing duplicates is the preferred approach, how do you typically handle it? I have already identified the duplicate records, so the only remaining step would be how to delete them.Thanks in advance for your insights and recommendations!

Is there an error in the system? 

Hi,I am trying to create a view filter with case when nested in it.It goes like this:FILTER VBAP-FilteringField CASEWHEN COALESCE (Var1, ‘’) = ‘Open Order’ THEN =  ‘Open Order’WHEN  COALESCE (Var1, ‘’) IN (‘Open Order’, ‘Missing Invoice’) THEN IN (‘Open Order’, ‘Missing Invoice’).END--The issue is: in the beginning, when there is one value (‘Open Order’) resulted from the CASE WHEN statement, the filter works well. But when I expand the fomular, including the result as a list  (‘Open Order’, ‘Missing Invoice’) and need to use the Word “IN” instead of “=” for filtering, it throws an err in the formular.Any suggestion how I can work around this?Thank you!