Support
Academy
Documentation
Marketplace

Success Hub
Groups
Events

Home
Community
Product Q&A
General Product Q&A

General Product Q&A

Not sure where to post? Ask your product-related questions here and get support from the community.

2,564 Topics
5,886 Replies

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

2563 Topics

Most replies

Most views

Newest first

pierre.aless12Level 2

asked in General Product Q&A

Are we able to extract the user adoption via Pycelonis from a specific team?

Hello all, I would like to know if it's possible to extract the user adoption data/login history from the Platform Adoption View via Pycelonis 2.0.1 (I have the CSV export feature enabled, btw). I'm trying to navigate to the specific object, but I can't even reach the Admin & Settings panel. Thanks in advance for any help.

165

7 months ago

gulshan.mishr13Level 1

asked in General Product Q&A

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

272

7 months ago

ines.cerveLevel 2

asked in General Product 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

1574

7 months ago

.146004188Level 2

asked in General Product Q&A

How does the workday calendar in data model look like?

Dear Community, we would like to use the workday calendar feature in the data model, so that we can calculate the lead time excluding all public holidays + weekend. Since our data source is not based on SAP, we don't have the TFACS-Table. Can someone help and tell me what kind of table I should update here as a workday calendar:which columns are mandatary?how should the table look like?what is the corresponding data format? An example table would be very helpful here. Thank you in advance. Kind regards,Liz

4810

7 months ago

guillermo.alamaLevel 1

asked in General Product 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?

232

7 months ago

manuel.wetzeLevel 5

asked in General Product 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

411

7 months ago

dhruv.jinjh11Level 1

asked in General Product Q&A

Hey everyone, I have designed an Action Flow using the List Items module in Microsoft SharePoint Online, and it has a limit of 3500. Essentially, if my SharePoint list contains more than 3500 records, not all the records will be fetched.

Is there a way to fetch all the records present in the list?

362

7 months ago

bianca.leuve11Level 2

asked in General Product 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?

421

7 months ago

henry.ferna12Level 2

asked in General Product 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

7 months ago

dennis.arrinLevel 3

asked in General Product 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

2064

7 months ago

cedric.zitkoLevel 1

asked in General Product 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

8 months ago

tomnguyenLevel 2

asked in General Product Q&A

How to learning using Celonis

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!

382

8 months ago

preethimani.sundaLevel 1

asked in General Product Q&A

I have not completed my celonis rising star assessment as I have taken the assessment 2 times now the assessment is not opening plss help me to complete the assessment

Please help me to complete the assessment

422

8 months ago

dennis.arrinLevel 3

asked in General Product Q&A

Balancing Innovation and Accessibility in Process Mining

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

8 months ago

brendon.mcdia11Level 1

asked in General Product Q&A

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

222

8 months ago

julio.bolan12Level 2

asked in General Product Q&A

FILTER some data only when a condition is true.

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 :)

8 months ago

douglas.henriLevel 4

asked in General Product 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

184

8 months ago

pruthvin.v11Level 3

asked in General Product Q&A

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

135

8 months ago

astha.jLevel 3

asked in General Product Q&A

How to delete trigger subscribers?

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.

311

8 months ago

karl.guentLevel 4

asked in General Product Q&A

In Warranty Claims and I want to isolate ("include") Claims over -$10,000 and below over$74.99. I am doing it in the filter bar (see red box below). However, I'd like to add it as a component, like the Date Picker (purple box below). I can't

111

8 months ago

suraj.kumar14Level 1

asked in General Product Q&A

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."

8 months ago

s.a14Level 3

asked in General Product 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.

8 months ago

andres.naran12Level 4

posted in General Product 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?

8 months ago

michael.lenzLevel 1

asked in General Product Q&A

Action Flow: Sharepoint Online XLSX Question

I have the following problem: I would like to upload a .XLSX file into my workspace via an ActionFlow. The .XLSX file is located on SharePoint Online. I can download the file using the "Download a File" action (Microsoft SharePoint Online) in the ActionFlow. However, I'm stuck at that point. In the output, the data is in "binary" format. How do I convert it from binary back to something I can import into a workspace? I have tried many things, but I just can't find the solution. Does anyone have any advice?

673

8 months ago

linett.denniLevel 2

asked in General Product Q&A

Does anyone know of an online place (URL) where we can view sample use cases and practice PQL query?

274

8 months ago

Page 3 / 103

Badge Winners

ebru.ulashas earned the badge Value Realization Expert
jauhar.khalihas earned the badge Value Realization Expert
ebru.ulashas earned the badge Qualified to Manage Implementation Projects
ebru.ulashas earned the badge Qualified to Deliver Business Value with Celonis
sofia.papadhas earned the badge Qualified to Deliver Business Value with Celonis