General Product Q&A

Has anyone implemented JD Edwards P2P connector? I need to understand how it works and recomendations coming from real project experience.

Hi,I am working on a KPI (A), which is calculated based on the result from another KPI (B) but this KPI (B) should not affected by Dimension selections. Do you know if this is possible? Thanks

how to change the nanme

Hello everyone, we currently want to display the Bill of Materials Hierarchy in Celonis.The issue with that is, that the hierarchy is not present in any SAP-Table. But instead in the related tables MAST and STPO.I have the MAST which has BOM and Material (component) relationship which needs to be traversed to STPO with the BOM-Nr. to identify the compenents and each component may be split into sub materials and new BOMs which needs to be looked up in the MAST for its BOM again and it goes on and on. Up to 4 levels deep.So the 4th level has no relationship to the first level. This recursive issue with inputing the results from MAST into STPO into MAST into STPO… is not possible in the FrontEnd (I assume).I am going crazy with knowledge models and action flows, the documentation is absolutely horrible. So it probably needs to be done in the data model itself. Additionally we want to add the Vendor from open orders from the EKPO. So we can filter for a material and for a vendor to so the

Col 1 and Col 2 are the two columns in the OLAP table I'm attempting to generate.Where Col 1 from Table A can have 0 or many values associated from Col 2 of Table B.The cardinality of Tables A and B is (1:N). Currently in place-Values in Col 1 of Table A that have no value associated with Col 2 of Table B are excluded from the OLAP table. What I hope to accomplish-Values in Col 1 should be shown, and values that have nothing related with Col 2 of Table B should have (Null/-) displayed in front of them. The Join Functionality of Celonis does Left Outer Join, and considers the (N) side table (Table B) on the Left Side implicitly, while I want it to be the other way round. Thank You! Regards,Priyank 

Hey, I wasn't logging into celopeers for some time, congrats on being first! :)Celonis defenitely should send you a t-shirt or something else! Thanks for engagement, probably I'll also return to helping some people here.

Hi Everyone. I am trying to create a table in Data Jobs, but I want two zeros infront of a number.  nothing I try works? what could the issue be? See ‘00’||”COL-1” 

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. 

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

I created an Action Flow for PDF Reporting, but can only select my Analysis. Do you have an idea how to or if it is even possible to get my view(s) automatically into a PDF File.Kind Regards, Max

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?

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?

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.

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

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

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

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?   

 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

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

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?

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

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

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