Solved

Hi everyone,I’m trying to connect MongoDB to Celonis. At first, I assumed that I’d need to use a custom JDBC driver (based on a thread that I’ve read here and the Celonis documentation).However, when I reached the step to select the “Database Type” in the connector, I couldn’t find a fitting option for MongoDB.Has anyone successfully set this up?Should I use a specific Database Type in this case? Or is there another workaround to get MongoDB connected?Thanks for any tips or guidance! 

Problem Description: In a Celonis Studio View, I am creating a column chart to display process cycle times, which are categorized into different intervals (buckets) using a CASE WHEN statement. During this process, two main issues occur:Missing Columns/Categories for Empty Data (NULL / No Data): If no records exist for a specific interval within the current filter context, the corresponding interval is not displayed as an empty category (a bar with value 0) on the X-axis; instead, it is simply omitted from the chart. This results in missing segments along the axis labels, making interpretation difficult.Incorrect/Alphabetical Sorting of the X-Axis: Since the CASE WHEN statement returns text labels for the intervals (e.g., '-15 - 0', '0', '1 - 9'), Celonis defaults to sorting the X-axis alphabetically rather than logically/numerically. Manually overriding this via the Sorting field with a separate numeric PQL formula (CASE WHEN ... THEN 1 ... THEN 2) does not yield the desired result, a

I’m currently exploring the Celonis Machine Learning Workbench and looking for some practical examples to learn from.I found the official PyCelonis Examples repository on GitHub, which is very helpful for understanding PyCelonis and interacting with Celonis resources. However, I was wondering whether there are also repositories, sample notebooks, or templates focused more on end-to-end ML Workbench use cases.I’m particularly interested in Supply Chain examples such as:Late/on-time delivery prediction Supplier or procurement risk prediction Inventory-related predictions Lead time prediction Bottleneck or process outcome predictionI also came across the older O2C – On-Time Delivery Prediction example, but it seems to rely on the legacy celonis_ml package.Does anyone know of any up-to-date PyCelonis 2.x / ML Workbench GitHub repositories, Jupyter notebooks, or sample projects that could be used as a starting point?And if you have built something similar yourself and can share the general

Running into a confusing behavior with our Delta Load setup and hoping someone can shed some light on it.We have a Data Job set to Delta Load mode, with several tables that don't have a Delta Filter configured. According to the docs, those tables should automatically fall back to a Full Load. For most of them that seems to work fine, but for some we're getting duplicate rows instead — identical in every column except _CELONIS_CHANGE_DATE.What makes it stranger: if we manually trigger a Full Load for those same tables, the duplicates disappear and everything looks clean. The problem only comes back when those tables run through the Delta Load job again.Two questions:Why does the "implicit Full Load" within a Delta job produce duplicates rather than overwriting existing data? Why does it behave differently from a manually triggered Full Load?

The Process Explorer component keeps loading indefinitely when connected to one particular Knowledge Model. Everything else seems fine — Variant Explorer and Case Explorer work without issues on the same KM, and if I switch the Process Explorer to a different Knowledge Model in the same view it loads perfectly.Already tried creating a fresh view, adding a new Process Explorer component from scratch, and reconnecting it to the same KM — same result. The issue follows the Knowledge Model, not the component or the view.Anyone seen this before, or have an idea where to start looking?

Running into an issue with the translation CSV workflow and wondering if anyone has seen this.When exporting translations, some entries contain HTML and CSS that the editor generates automatically — happens as soon as you use standard formatting like bold, font color, or font size in a textbox. The output ends up looking something like:<div><strong style="color: rgb(0, 0, 0);">Some text here.</strong></div>Those inline styles contain semicolons, and re-uploading the CSV fails because of them — even if nothing was changed in the file. The only thing that actually unblocks the upload is deleting the entire row, reference tag and translation both. Clearing just the translation value and keeping the reference tag doesn't work, the upload still fails.The problem is that this affects a large number of entries, so every sync cycle means manually identifying and stripping out all the styled rows before the upload goes through. Is there any way to allow semicolons in the

Came in this morning to find our Studio environment basically broken. All data model variables had disappeared and were no longer connected to the knowledge models, so none of our views were showing any data. Nobody on the team had touched anything.Manually recreating the variables fixed it for most knowledge models, but two of them kept throwing "Failed to change Data Model" whenever I tried to select the variable — so those are still broken.On top of that, a lot of KPIs are now displaying oddly formatted names with a prefix and the data model name included, something like km-master.kpis.some_kpi.displayname instead of just the plain KPI name they had before. Not sure if that's related or a separate issue.Anyone seen something like this, or have an idea what could cause variables to disappear like that without anyone actively deleting them?

Having a frustrating recurring issue and not sure what the actual fix is at this point.We have several Action Flows that send emails via an Outlook account. Every few days, one or more of them deactivate automatically with this error in the Send Email module:Invalid login: 535 5.7.139 Authentication unsuccessful, basic authentication is disabled.Reconnecting the email connection seems to help temporarily but the error comes back after a few days. Has anyone dealt with this, or found a more permanent fix?

Hitting a wall with an extraction of tens of millions of rows from Amazon Athena via the SQL editor. The pull itself seems to finish without complaint, but the pipeline then breaks at the Data Push Job step with an InternalException.A couple of things I've noticed:A similar extraction through the visual editor (same columns, but a much smaller row count) runs without any issue as part of the daily load, so I don't think it's the source system itself causing this. I only moved to the SQL editor because I needed JOIN and CAST logic that the visual editor doesn't support. Not sure yet whether it's the volume or the JOIN/CAST operations that's actually the trigger.Has anyone hit Data Push failures at this scale, or specifically with JOIN/CAST in SQL editor extractions? Any insight into what usually causes this would help.

I'm working with a REST API that returns doubly-nested JSON (think: a top-level array of objects, each containing a nested array, which itself contains another nested array). Celonis splits this correctly into three separate tables, and the parent key from the top level propagates fine into the first nested table. The problem is that it stops there.The second-level nested table has no reference back to the top-level parent. The intermediate ID that's available at that level isn't unique (it's a type identifier that's the same across all top-level records), so I have no way to join the second-level table back to a specific top-level record without getting a cartesian product.The root issue as far as I can tell: in the Connector configurator, you can only choose from fields that exist in the API response as Primary Key. The propagated parent key that Celonis adds to the first nested table isn't available as a selectable column when configuring the second nested table, so there's no way t

Working on an OCPM data model and running into an issue where transformations based on SAP tables won't preview or publish anymore, regardless of which specific transformation it is, even standard Celonis ones fail as long as an SAP table is involved.A few observations:Transformations on other source systems (e.g. Dynamics AX) seem unaffected, so it looks specific to SAP tables somehow. Saving with validation fails outright, saving without validation works, but publish still isn't possible afterward. Existing, unchanged transformations still seem to run fine in the backend, so this feels isolated to the Objects & Events interface specifically.Anyone run into something similar with SAP-table-based transformations?

Been pulling my hair out on this one. I'm the admin of our space and have full permissions, but the gear icon in the ML Workbench that's supposed to let you adjust memory allocation is just... not there. Checked on multiple browsers, different devices, had a colleague confirm it's not showing up for them either.The script I'm trying to run keeps failing or hitting memory errors, and it's something our team relies on daily, so this is becoming a real problem. I've gone through the usual troubleshooting (refreshes, browser switches, confirmed admin rights) and I'm stuck.Is there something I'm missing on the permissions side, or is there a way to enable this?

We're trying to set up an automated PDF report using Action Flows and running into a few limitations we'd like to understand better before deciding how to proceed.Our setup: a view with multiple tabs, one of which renders differently depending on a variable (basically acts like a toggle filter). We want to export a combined PDF that includes content from different tabs, including three versions of that one tab with different variable values, and send it to a group of users automatically at least twice a week.Two things we've hit:Separating tab IDs with commas in the Create PDF module didn't produce the multi-sheet output we expected. Not sure if we're doing something wrong or if this just doesn't work as described. We're not sure if variables can only be set through manual interaction, or whether there's a way to pass them in when an Action Flow runs on a schedule.Is the desired output achievable in some form, and if so, what's the recommended approach?

Large history table extraction keeps hitting an Athena query timeout.I'm stuck on a recurring issue when pulling a large history table through Data Integration → Extractions. No matter whether I build it in the visual editor or the SQL editor, the run dies after a long-running query with:[Simba]AthenaJDBC An error has been thrown from the AWS Athena client. Query timeoutI already tried cutting the row count by joining the history table against a header table first, no change. The only version that actually finishes is one where I add a hard date cutoff, but that obviously leaves out a chunk of history I actually need.Anyone dealt with this on larger Athena-backed extractions? Looking for a way around the timeout that doesn't mean sacrificing part of the dataset.

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

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!

Hi everyone, how are you?I'm trying to combine two tables with the same columns in a Data Model. My goal is to merge the data so I can continue adding and analyzing new information in my views.I've tried using UNION/UNION ALL, but I haven't been able to get it to work. What is the correct way to combine two tables with the same structure in a Celonis Data Model?Any help or guidance would be greatly appreciated. Thanks in advance!

hi all,Context :We have been using Celonis for many years connected to SAP ECC.To limit our data consumption + keep our jobs running as efficiently as possible, we have been extracting our tables based on a 24 months rolling basis.For that, we have a small job running every month setting the start date of all the extractions. This start date is used in the tables extraction filters. This has been running smoothly so far.What is happening :Our company is going to transition one ERP from SAP ECC to SAP S4.in SAP S4, the price conditions table PRCD_ELEMENTS (KONV table in SAP ECC) and more specifically the date field KDATU, is setup in CHAR data type. This is not compatible with our extraction setup.Assuming I wont be able to get this data type change, any recommendation on how to handle that?Thanks

Hi, I’m currently facing an issue while setting up an Action Flow / Machine Learning Workbench solution to download and merge multiple Excel/CSV files from a SharePoint site.I can see that it’s possible to download a single file using the Microsoft SharePoint Online module in Action Flow. However, my problem is that the folder contains multiple files with different names, and I would like to handle all of them within one solution.Has anyone worked on something similar and could share some advice on how to approach this?

Hello everyone, is there a way to send emails to multiple vendors at once using Action Flow? Currently, my setup supports sending emails to only one vendor at a time, and I would like to extend this capability to handle multiple vendors simultaneously.At present, I trigger emails from the dashboard View by passing a variable that identifies the vendor along with the corresponding email addresses. However, I am looking for a mass email functionality that allows sending emails sending to multiple vendors in a single trigger.  

Dear experts , What is the size limit of Objects and Events in OCPM and  so far we have not consider archiving the older records from OCPM is it advisable ?  

Hi everyone, I’ve got the following Issue:I have an action flow that queries data and builds up an HTML view in the form of a table for all its entries.In the end I  trigger a Process Automation Skill to send an email via the “Email by Celonis” action. My hyperlink is correctly tagged with:<a href="https://url:port/sap/bc/gui/sap/its/webgui?~transaction=*transactionname%20table-field%3Dsalesorder%3BDYNP_OKCODE%3D%2F00%23" rel="noopener noreferrer" target="_blank"> salesorder</a> but in the mail I only receieve the text “salesorder” without the hyperlink. On the other hand when I use the URL as the hyperlink text it gets through with the mail:<a href="https://url:port/sap/bc/gui/sap/its/webgui?~transaction=*transactionname%20table-field%3Dsalesorder%3BDYNP_OKCODE%3D%2F00%23" rel="noopener noreferrer" target="_blank"> https://url:port/sap/bc/gui/sap/its/webgui?~transaction=*transactionname%20table-field%3Dsalesorder%3BDYNP_OKCODE%3D%2F00%23</a>but only because my

hello team, i want to find how many days between invoice date and clear date in olap table. i just do "clear date" - "invoice date" but the result is weird very big numbers like millions. i just want normal days count. what is wrong with my code please help me