Product Q&A

As someone with a stake in Celonis’ success by means of a commercial online course I have been offering since 2021, I’ve closely observed its evolution in process mining. My experience, along with feedback from my students, has highlighted a growing concern: while Celonis’ new advanced features like the business miner, the execution management system, object-centric process mining and AI-driven intelligence are impressive, they seem to overshadow the platform’s foundational strengths—offering simple, actionable insights. The Shift Away from SimplicityIn the early days, Celonis was a go-to for its ease of use: you could upload an event log and instantly generate a clear, valuable 2D process map. The low barrier to entry made it ideal for those looking to identify inefficiencies quickly. Today, however, reaching that classic 2D process map with sliders feels almost like a hidden feature. Navigating through the various menus, filters, and new tools can take numerous clicks, with a lot of

Hi community, has anyone managed to set up a OAuth 2.0 connection to SAPs Success Factors yet?We're running in some issues there and I'd be happy to know if there are users out there who were able to successfully connect the two systems. Best regards!Johann

Hi folks! I have a challenge where I need to create a PDF report from an analysis and send it by email, I’m using SMTP. I was able to configure the module to send the PDF report attached. However, I’m trying to include the content of this PDF in the email's content as an image. Normally I would be able to create a python code that allows me to get the data from PDF, but unfortanely is not possible to use any program language inside an action flow.According to this documentation, https://docs.celonis.com/en/email--action-flow-.html it’s possible to use the content_ID to include the content of PDF report as an image inside the HTML content, but I cannot find any example that explain how to achieved this.Does anyone know how to do that, pls?

Hi there guys! I noticed that Celonis Free Plan and Academic Alliance are no longer available for new users? When googling these options, all options lead to do this link:  https://signup.celonis.com/ui/sign-up/get-started Upon registration, users can choose between ‘Celopeers’ and ‘Academy’, but no actual acces to the platform is provided.The Celonis website still says ‘try for free’ everywhere however, but there is no way new users can try anything out at this moment. Is this a glitch or are the Celonis Free Plan and Academic Alliance disbandend? It’s strange because they are still heavily promoted as ‘try for free’. Curious to hear your answers, kind regards, Dennis Arrindell.

Hello I am new to the platform ; I would like to know if there is a way to find fake log activities that I could use to test the solution. Thank you for the help ! Cédric

I was going through various packages in the celonis and i found out that there is a package called "Celonis_ml" with no other documentation and when gone further it says it got deprecated and moved to pycelonis and the demo O2C - On Time Delivery Prediction has been built importing the Celonis_ml can anyone help what changed and how to build ML Workbench predictive analysis and what libraries need to be used an upgraded documentation..thanks!

Hi guys,I would like to know if is possible to format the component Table to be something similar to a matrix (Pivot Table) where we can expand and collapse rows. That would be good for some kind of analysis.  Also, in this new table view, is possible to change font, font size, color and etc…? I couldn’t find these options.Thanks,Renan

How to add additional data in existing webhook ?

Hello everyone, I am an employee from a technology company called Terus. I am assigned to learn and know how to use Celonis, then bring it back to apply to the company's process, but I currently do not have a clear plan for this move because in my country, not many people use Celonis.By chance, when I was researching, I noticed that this community and everyone shared a lot of information related to Celonis. I want to ask about the roadmap that everyone learned to use and apply Celonis? I hope everyone can give me an answer!

*Deleted Post*  (re-posted as a new post here:  

How do I add a process explorer filter in an analysis that calculates throughput time between activities in seconds?

This Screenshot show my unfilteres table:As you can see I got a lot of data where my resultsqueeze and resultvalidation is empty. I want to filter those entries. What i did is Filter the whole sheet with the following statement:FILTER ("reportdataextraction"."resultsqueeze" !='' and "reportdataextraction"."resultvalidation" !=''); But the statement is filtering every entry where either one of the columns is empty. This is my result:  What am i doing wrong? Thank you for the help! Bests,Jonas Vennemann

I want to filter based on a condition like this:FILTER Color = 'blue' WHEN Shape = 'square'. I'm having trouble creating a formula like this because what I have tried is filtering all instances where Color = 'blue', but I want to filter only for blue color when the shape is square.I think this should be something very easy to do, but I'm having trouble. Thanks in advance :)

I need some help guys, I want to add up the day's payments to generate an accrual. Example: Day 01 $100, Day 2 $200 Day 03 $300 In the amount I want, I would do it like this: on day 1, $100, on day 2, $300, on day 3, $600. But I don't know how to do it, below in Excel how it was done.This needs to be per month. So it adds up only within the month when the month ends it resets and dnv starts. I don't know if it's clear, but you can try to clarify better. Excel:  my attempt at PQL   SUM ( CASE WHEN "BSEG"."AUGDT" >="BSEG"."AUGDT" THEN KPI("valor_acumulado") + "BSEG"."DMBTR" ELSE  "BSEG"."DMBTR" END) valor_acumulado = CASE WHEN  "BSEG"."AUGDT" >= "BSEG"."AUGDT" THEN "BSEG"."DMBTR" END  

Do anyone know the PQL formula to find PR which is not converted to PO within 2 days

The data model looks like this. (1) is VBAP(2) is VBEP(3) is MARA(4) is MVKE   Now I created an OLAP table with columns from different SAP table. When I now want to include the SAP field MVGR1 from table MVKE is receive following error message.  How should the formula look like by using e.g. DOMAIN_TABLE or BIND together with PU-Function so that I can display the field MVKE.MVGR1 in the OLAP-Table?

Hello everyone, I want to use the WORKDAYS_BETWEEN function, however, in preparation for this function, I need to create a Workday Calendar. How do I do this within data integration/KM?  Thank you so much! BRJulia Bauer 

I’m trying to determine how best to calculate order backlog by using the activity table and event statuses. The calculation would be used to render the data into either a table, histogram or bar chart grouped into week (Round_Week(Event_TimeStamp)). Please share any ideas or code examples.

Hi everybody! I’m pretty new to celonis development and never ask a question here before, but I hope you can help me! I’m extracting data from SAP for Production data and now have the issue that I want to join the JEST table to two other tables (AUFK and AFVC) on the column AUFK.OBJNR and AFVC.OBJNR. How can I do that since downloading the whole JEST table means like 200 million entries :-( I hope you can help me!  Thank you very much!

I have a trigger which is link to 2 subscribers. I'm not able to delete the subscribers, so when I delete the trigger, it gives following error.

When I try to look for the following package at the marketplace:  The marketplace only shows me this one to download: I don't need this one, since this is designed for OCPM models, in my case I want the first one but I don't know how to get it. Does anyone have the same issue?  

I want to connect Azure MySQL to celonis. I am not able to connect. Getting error message "Connection test failed. Please check the data connection and ensure that the system is running. Extractor responded with an internal error."

Hi, Can you help me with a PQL that can showcase total time spent by each workgroup on an incident? The incidents can be re-assigned between different workgroups in its life cycle. output required Workgroup Avg time spent on incidents Volume of Incidents handledA XX mins. 10 incidentsB XX mins 20 incidents Example data below.

Hello,  I need a line chart showing created/open/resolved cases count every day. ​For x axis, I used GENERATE_RANGE function to generate DATE values as below. GENERATE_RANGE ( '1D' , TO_DATE ('2024-01-01', FORMAT('%Y-%m-%d')), TODAY()) For y axis(KPI), I use: COUNT_TABLE ( "casetable" ) However, the problem is there's no common table between this generated temporary table with the case table or activity table, so the case counts cannot be calculated based on this temporary table.   ​Does anyone know a good way to create that analysis, ideally only in frontend and not change the data model?