Skip to main content

Recent Discussions

44
C
Level 4
CelonisAcademyLevel 4
 Celonis Academy Group
Updated Course: Deliver Value Assessments

Discover a standard approach to prove the Celonis value.The course is available here.

10
C
Level 4
lisaschneider
Level 2
lisaschneiderLevel 2
 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

00
lisaschneider
Level 2
M
Level 2
maxim.vnoutLevel 2
 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

10
M
Level 2
Phuad Karaev
Celonaut
Phuad KaraevCelonaut
 News & Updates
🚨 Mid-Challenge Check-In: Celosphere Community Challenge 🚨
🚨 Mid-Challenge Check-In: Celosphere Community Challenge 🚨

 We’re halfway through the Celosphere Community Challenge — and the Community has been buzzing with great conversations and contributions 🙌 🎉 Shoutout to our current Top 10:​@joaocarlos.macie  ​@Joe-Hartzel ​@janpeter.van.d ​@yingtao.gu13 ​@asdfg ​​@jan.vajse12 ​@carlos.taleg11 ​@joos.buijs ​@irfan.suria12 ​@Bastian Blum  You're all off to an amazing start, but remember, the leaderboard is still wide open and anything can change! 💡 How to earn points   Activity Points 1. Introduce yourself in Community Connect & interact with others 15 points ➕ Bonus: Have/upload a profile picture +2 extra points 2. Subscribe to Product Updates to stay informed 10 points 3. Reply to threads in Product Q&A Categories 5 points per reply ➕ Bonus: Reply marked as Best Answer +3 extra points per reply  🎟️ We’re giving away 20 Celosphere 2025 tickets to the top contributors📅 Challenge ends on September 19📢

251
Joe-Hartzel
Level 3
Leslie Lei
Level 3
Leslie LeiLevel 3
 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

746
joaocarlos.macie
Level 3
Maurits de Vries
Level 2
Maurits de VriesLevel 2
 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

90
Maurits de Vries
Level 2
pavan.bhara13
Level 3
pavan.bhara13Level 3
 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 2
A RabLevel 2
 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.

121
N
Celonaut
C
Level 4
CelonisAcademyLevel 4
 Celonis Academy Group
Your Voice Matters – Help Shape Celonis Academy!Interview

Have you taken a course, joined a webinar, earned a badge—or simply explored the Celonis Academy? - We’d love to hear your story! We're inviting you to a quick 30-minute interview where you’ll help us better understand:Your Role – how you use Celonis in your day-to-day Your Academy Experience – what’s working well and where we can do better Why Join?Help shape the future of Celonis Academy content Receive a $150 voucher toward qualification or certification exam attempts. Interested? Reach out to us here. 

100
C
Level 4
Leslie Lei
Level 3
Leslie LeiLevel 3
 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?

162
Leslie Lei
Level 3
jan.hagem
Level 3
jan.hagemLevel 3
 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
Katharine Raab
Celonaut
Katharine RaabCelonaut
Introducing the latest Celonis Platform updates
Introducing the latest Celonis Platform updates

We've enhanced the Celonis Platform with new usability improvements for a more seamless experience. Analysts will find it easier to explore their data with powerful new visualizations like the boxplot chart, while also benefiting from new data management and usability features. These updates are designed to help you work more efficiently and effectively. DATA INTEGRATION Inactive Data Model Suspension PI GRAPH Delete Object/Event Types & Dependencies PROCESS DESIGNER Improved Modeling & BPMN 2.0 Conformance PROCESS NAVIGATOR Approver role in Process Journal STUDIO VIEWS Object count in Views Predefined filters for containers Y-axis autoscale for charts Knowledge sidebar & quick metadata updates Show & hide Knowledge Model entities Boxplot Chart Component All changes listed below are in General Availability. To take part in early previews, check out the list of opportunities here. Planned releases: Studio Views - Legacy View component migration: September 2025

1960
Katharine Raab
Celonaut
M
Celonaut
mateusz.miaraCelonaut
 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

511
Joe-Hartzel
Level 3
E
Level 3
ewa.aniśkLevel 3
 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?

396
Joe-Hartzel
Level 3
julia.bauer
Level 5
julia.bauerLevel 5
 Process Improvement
Augmented Attribute Behavior

Hello everyone, I’m using an augmented attribute  “Sendout y/n” which is based on this record identifier: EORD → Material || Plant || Supplier. This attribute is used within a dashboard and can be manually set for the default value “no” to “yes”.  In the case a user changes this combination: Material: 123456, Plant: XY, Supplier: SupplierA → 123456XYSupplierA → Sendout (Augmented Attribute): Yes, I can then use this attribute for a connected AF. Let’s say the SAP EORD table data changes → orderbook changes the record identifier would now be: Material: 123456, Plant: XY, Supplier: SupplierB → what would now happen? Would the combination 123456XYSupplierB be on Sendout: Yes? Or would the augmented attribute as it is based on the MATNR, WERKS, LIFNR know that the identifier itself changed and be by default No again? When changes occur I would need the combination 123456XYSupplierB to have the augmented attribute with: No by default. I’m assuming that this will be the case, however, I’m no

445
Joe-Hartzel
Level 3
C
Celonaut
Celonis Community TeamCelonaut
 News & Updates
Do you want to connect with other Celonis users? We're making it possible!News

Hello Community,We've taken your feedback to heart and created a brand-new way to network with like-minded individuals who use the Celonis platform!Whether you're currently facing a similar business challenge, implementing a comparable process, or working in the same industry—our new Peer-to-Peer Matchmaking service will connect you with the right people.Here’s how to find your perfect match in just three steps:Fill out the form: Click here and tell us who you would like to meet. Find your match: We'll send you an email with your match's contact details. Get started & share experiences: Connect in 1:1 conversation, exchange ideas, and tell us about your experiences in the Community!And the best part: The first five pairs to connect in a call and share their experiences here in a Community post will receive exclusive Celonis swag from us! So, what are you waiting for?We look forward to hearing about your experiences and shaping this initiative with you.  Our CX team carefully review

990
C
Celonaut
C
Level 4
CelonisAcademyLevel 4
 Celonis Academy Group
📢 Partner Sales Enablement SeriesNews

We are hosting a partner-exclusive webinar series, enabling you to take your skills to the next level in your role as a Celonis Partner!✔️ Enhance your marketplace knowledge.✔️ Dive deep into live demos.✔️ Get your questions answered directly by Celonis experts.Explore the Partner Sales Enablement Series, comprised of nine insightful sessions, and sign up to the ones that excite you the most! 🚀Can’t attend the live sessions? Stay tuned for on-demand recordings, which will be available 24/7.Which session(s) are you planning to join? Share with us below 👇

170
C
Level 4
marcelo.ferre11
Level 2
marcelo.ferre11Level 2
 Process Improvement
Sending data from Action Flow to Action Flow without a Webhook

Hi Team,I’m trying to send data from one Action Flow to another without using a webhook. Is that possible? Thanks in advance for your help!

100
marcelo.ferre11
Level 2
yingtao.gu13
Level 2
yingtao.gu13Level 2
 Community Connect
Glad to join the community!

Dear all!My name is Yingtao and I’m leading the Process Mining team at valantic! It is really great to be in the community and looking forward to exciting exchanges with you! :)

181
Caterina Gambuti
Celonaut
Joe-Hartzel
Level 3
Joe-HartzelLevel 3
 Community Connect
My Intro

I’m Joe Hartzel, a researcher passionate about exploring how technology, data, and human behavior intersect to shape the future of work and innovation. Over the years, my focus has been on analyzing complex problems, uncovering patterns, and translating insights into practical strategies that drive real-world impact.What excites me most about research is the opportunity to go beyond theory—turning evidence and findings into actionable knowledge that can help organizations and communities adapt, grow, and thrive.In this community, I look forward to:Sharing research-driven perspectives and lessons learned from my workLearning from your diverse experiences and case studiesCollaborating to push the boundaries of what research and practice can achieve togetherFor me, this is about transforming knowledge into impact, and I believe that through collective learning and collaboration, we can accelerate that journey. Looking forward to engaging discussions and meaningful exchanges with all of yo

362
Joe-Hartzel
Level 3
karl.guent
Level 4
karl.guentLevel 4
 General Product Q&A
Something wierd is happening with my environment ... the labels are lost and I am seeing variable names. Is this happening to other people as well?

95
Joe-Hartzel
Level 3
mtucker10
Level 2
mtucker10Level 2
 General Product Q&A
How can i tell if my EMS connection has microsoft features enabled?

I’m trying to create a data connection between Celonis into Power BI. When I put the hyperlink into the ‘get data’ prompt, the navigator pane is blank (ie shows no data available).  I’m curious if I have the microsoft connection enabled. How can I check this? Important to note - I do not have analyst rights in Celonis hence why I’m attempting to import data into Power BI. 

90
mtucker10
Level 2
apurva.patha12
Level 4
apurva.patha12Level 4
 General Product Q&A
Limit the row level data in Pivot(New View)

Hello All,Could you help me to understand how to select recent 5 years in Pivot Table(New View). Currently i can see older data also like below.I want to limit it to last 5 years only. Please help.Regards,Apurva

283
yevhen.riabt12
Level 2
bhargav.bhima
Level 2
bhargav.bhimaLevel 2
 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.

1187
Joe-Hartzel
Level 3
C
Level 4
CelonisAcademyLevel 4
 Celonis Academy Group
Celonis Partners - Ready to Build Solutions?
Celonis Partners - Ready to Build Solutions?

Hey Celonis Partners! Are you aspiring to build solutions with Celonis?❓Tell us below which solution type you want to develop. 🚀​​Are you already experienced in solution creation with Celonis? ➡️ Share your experiences with us below!Are you not familiar with the solution types mentioned above but curious to find out more? ➡️ Check out our Position and Promote Solutions training track!Are you just getting started with your solution creation journey? ➡️ Whether you are part of the Celonis Platform Apps Program (CPAP), or building solutions for your own consulting engagements, the revamped Solution Creation Expert Badge is your one-stop-shop for all the enablement you need. Elevate your skills and unlock new possibilities today!

150
C
Level 4

Badge Winners

VIEW ALL
Community Code of Conduct