- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

1 month ago

Home
Community
Ask the Community
General Q&A

General Q&A

Can't find what you're looking for? Ask it here!

1,141 Topics
2,481 Replies

When you subscribe we will email you when there is a new topic in this category

1141 Topics

Recently active

Most replies Most views Newest first

e.nLevel 4

asked in General Q&A

Data model Error

I got the following message. but I do not know how should I solve the problem. Could you please explain the detail? Data model load failed during load to engine: Could not load data model. Load failed. Error Message: Could not execute foreign key join: there are duplicates on both sides of the specified key relationship. Table "A": key column ("E"), key ('00058B2D25244258B806'), rows 1 and 2. Table "B": key column ("E"), key ('EEE3E74B186040F48522'), rows 29 and 35. Celonis Support ID: e9012fd3-bf7c-4e59-9d7a-6b92484458a2

135

10 hours ago

ivana.ljubiLevel 2

asked in General Q&A

Resend invitation to only pending users

Hi,is it possible to resend invitation after 14 days of unaccepted invitation, as using “Sharing invitation” task is not working. It is showing message “only user with pending status can be selected” but I selected exactly those users. Would be good if I can resend invitaiton with one click, rather than using blue button “invite new users” and type all emails again..Thanks.

17 hours ago

lukas.deekeLevel 2

asked in General Q&A

Filter the sequence

Hi All, I need a filter that filters out all activities where activity “A” is not first. So i only want to see all cases where the correct acitivty sequence is A → B → C → D...

19 hours ago

carlluca.muenk11Level 2

asked in General Q&A

I've been experiencing a recurring issue with the sign-in process for both my Bentley and ABB projects. I often get the same error message, and while clearing cookies and history sometimes helps, it doesn’t always solve the problem.Has anyone else encountered this? Any suggestions for a more permanent fix, or is there someone specific I should reach out to for support?

1 day ago

maxime.psbpmLevel 2

asked in General Q&A

Service Request Management connector (for ServuceNow)

Hello,As a new user of Celonis, I wanted to check if it's normal that some process connectors, such as the Service Request Management connector (for ServiceNow), don’t come with out-of-the-box applications. In such cases, is it up to us to build our own package from the ground up?

192

2 days ago

julien.mayerLevel 2

asked in General Q&A

Is anyone else experiencing EXTREMELY slow OCPM?

Everything I’m doing on my OCPM projects (saving and previewing transformations, publishing, running data jobs, loading data models) is taking an obscene amount of time. I’m talking 2+ hours for something that used to take minutes…Is anyone else experiencing this?

5 days ago

gulshan.mishr13Level 1

asked in General Q&A

how can we write a Pql Statement to count the activities passes through the cases

6 days ago

ines.cerveLevel 2

asked in General Q&A

Error: The aggregation function SUM is applied on a column from table "EKPO" which has a 1:N relationship to the common table "EKKN". This means that one input value can contribute to the aggregation result multiple times.

Hi everyone!I'm having issues with a formula, can you please help or tell who can help me?My goal is to have an OLAP with fields from EKKN and EKPO. I need a KPI to sum the PO item values in EUR. Formula: SUM("EKPO"."NETWR_CONVERTED" )Error: The aggregation function SUM is applied on a column from table "EKPO" which has a 1:N relationship to the common table "EKKN". This means that one input value can contribute to the aggregation result multiple times. For more information search for "Join functionality" in PQL documentation. I've checked the results and, in some cases, it is summing the same value more than once, as predicted by the error. The following solutions did not work: SUM ( CASE WHEN INDEX_ORDER ("EKPO"."NETWR_CONVERTED",PARTITION BY (FILTER_TO_NULL ("EKPO"."NETWR_CONVERTED"))) = 1 THEN "EKPO"."NETWR_CONVERTED" ELSE NULL END)https://docs.celonis.com/en/sum.html PU_SUM("EKKN","EKPO"."NETWR_CONVERTED")Error: Pull-Up-function could not be executed. PU_SUM: Cannot execute PU-fu

494

6 days ago

guillermo.alamaLevel 1

asked in General Q&A

TFACS table has been added to Workday Calendar options in Data Model, but it is not available in the Studio.

As explained in the documentation, we have added a TFACS-style calendar from our data pool in order to determine workdays between two dates: However, when trying to access the table from the Studio, for instance like this: WORKDAYS_BETWEEN( MIN("_CEL_P2P_ACTIVITIES"."EVENTTIME"), MAX("_CEL_P2P_ACTIVITIES"."EVENTTIME"), WORKDAY_CALENDAR("AT_TFACS", 'AT')) we get an error message saying that the table does not exist. The workaround we have done to solve this issue consists on adding the AT_TFACS table to the data model without any connection to the rest of tables in the data model: This does indeed solve our issue. However, we ask ourselves: Is this a clean best practice? Should the table be automatically available in Studio once added as workday calendar option?What happens in the backend when adding a TFACS-style table to calendar options?

7 days ago

manuel.wetzeLevel 4

asked in General Q&A

Hi all, I have a question regarding the backened of the comments component.How does it behave once I have to change the identifier logic of the corresponding record?

I did set up a record with identifier and the comment component of the "new View" which worked fine and created a new record called "... Comments" in KM. Now I got a change request to change the underlying record and consequently its ID. I did change the identifier of the record. But now (kind of as expected) the comments record is "misconfigured". I get a warning in backend data integration dataload:"Client Error: Can not find the join partner data model column [XXX] for the augmentation column [XXX] in the loaded data model. Querying this augmentation table will not work until the data model schema inconsistency is fixed." In Knowledgemodel "Comment Record" I also get error "Augmentation table wit name YYY_COMMENTS has an invalid configuration and will not be queryable until it is fixed. For details please check the load warnings." I would be fine just deleting the record and table and start from scratch. No need to migrate

121

9 days ago

philipp.finzeLevel 2

asked in General Q&A

How to create a chart that compares the development of a single KPI with the past year?

Dear fellow Celonis users, I want to create a bar or line chart where I can compare the development of a KPI in the current and previous year.I saw that somebody suggested to create a filter for the respective year. This might help to switch back and forth. However I want to show it simultaneously in one graph. Appreciate any help.

251

13 days ago

milan.ericLevel 3

asked in General Q&A

Inline editing limited to tables with 30M rows, any workaround?

Hey, I am curently working on creating a dashboard for employees as a view where they can simultanously write back to each line in a custom “comment”-column. Basically the inline editing function from the new Views.Sadly I want to do this for a rather large data model. Is there a way to have inline editing or something similiar for bigger tables that exceed 30M Rows? Or can I put some sort of filter on that table in the front end to minimize the rows below 30M. Or does it have to be in the back end? Thank you!

140

14 days ago

milan.ericLevel 3

asked in General Q&A

Knowledge Model added a record to the Base and now I can not remove it

Hello everyone, not sure if this is a bug but I am very new to knowledge models and views. I only worked with analysises beforehand and I am trying views for the very first time. I somehow added a record here. Not sure how, since I never pressed “Create record”. I tried to create an augmented attribute but it somehow failed. Anyways I am trying to clean up my mess now. This is the newly created record: It is autogenerated and now is included everytime I create a Knowledge Model based on that Data Model: I NEVER touched the BackEnd at all. When opening the DataModel in the preview section, it exists as a standalone table: But when I ppress “Go to Data Model” it does not actually exist in the BackEnd (obviously, since it doesnt exist).But how do I get rid of this record? It annoys me that it exists and I can not do anything about it… Thank you!Sincerely, a very confused new Views-User

140

15 days ago

bianca.leuve11Level 2

asked in General Q&A

Dynamic date header

Hi folks, Does anyone know if it is possible to have a dynamic date in a table? so that the table has a column with today's data, and the header shows the current date?

241

16 days ago

henry.ferna12Level 2

asked in General Q&A

Extractor / App for Credit Management in SAP S4H

The SAP S4H Data Model for Credit Management has changed since ECC.Has anyone had experience in extending the existing Celonis AR data model to incorporate credit management? I am currently developing such a model for a client and would be interesting in the experience of othersRegards

17 days ago

dennis.arrinLevel 3

asked in General Q&A

Is Celonis becoming too complicated?

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

764

19 days ago

andres.naran12Level 4

asked in General Q&A

Extract images from PDF report into SMTP

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?

21 days ago

dennis.arrinLevel 3

asked in General Q&A

Celonis Free Plan and Academic Alliance no longer available?

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.

271

22 days ago

cedric.zitkoLevel 1

asked in General Q&A

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

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

22 days ago

Renan ChavesLevel 2

asked in General Q&A

New Studio View - Data Viz - Table Formatting

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

181

23 days ago

dennis.arrinLevel 3

asked in General Q&A

Balancing Innovation and Accessibility in Process Mining

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

24 days ago

brendon.mcdia11Level 1

asked in General Q&A

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

162

24 days ago

douglas.henriLevel 4

asked in General Q&A

Formula excel for PQL

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

104

26 days ago

s.a14Level 3

asked in General Q&A

How to get total time spent by each workgroup on re-assignment of an incident?

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.

28 days ago

andres.naran12Level 4

posted in General Q&A

How to show a target in a Column and Line Component?

Hi, I'm trying to show a target inside a column and line component, but for some reason I'm not able to add it.I already created the target in the desired KPI, but I don't know how to show it. Did anyone have a similar scenario before?

29 days ago

Page 1 / 46

Badge winners

florian.schul11has earned the badge Celonis Certified Data Analyst
sayali.randh11has earned the badge Qualified to Get Data Into Celonis
lyzanne.tr24has earned the badge Celonis Technical Expert
ivana.ljubihas earned the badge First Post
lukas.deekehas earned the badge First Post

Show all badges

Terms & Conditions

Sign up

Already have an account? Login

Login with SSO

Login to the community

Login with SSO

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

ANY QUESTION?

Talk to an expert

FAQs

MORE CELONIS

Academy arrow_outward

Documentation arrow_outward

Support Center arrow_outward

Partner Portal arrow_outward

Marketplace arrow_outward

CHECK US IN

YouTube

Instagram

Facebook