Unanswered Questions

I’m trying to connect Celonis in Power BII created an Application Key but still don’t see any tables loaded after connectionWhat could be the issue? 

Hi Community,I am struggling to reproduce a classic SQL join pattern in Celonis PQL and would appreciate some guidance. ### Data ModelI have an **N:1:M relationship** between three tables:- **Table A** – Material (1 record per material)- **Table B** – SalesOrg-related attributes   - N records per material   - Foreign key: `B.material_id → A.id`- **Table C** – Plant-related attributes   - M records per material   - Foreign key: `C.material_id → A.id` ### What I want to achieveFor each material, I want to display **all possible combinations** of SalesOrg and Plant, i.e. the cartesian product of tables B and C per material. ### SQL reference (works as expected)In SQL I would do something like:SELECT  A.id,  B.org, C.plantFROM ALEFT JOIN B ON A.id = B.material_idLEFT JOIN C ON A.id = C.material_idProblem in Celonis / PQLI simply do not manage to reproduce this in a View via PQL. In particular, I fail to get three columns in a table view (material, org, plant) showing all combinations of B

Hi all, I have a column with multiple values   e.g. col_list = '21651,5615561,50615,561591' per case_keyI need to split the values in four different rows when showing an OLAP table in studio.Some  case_keys present up to 5000 values in that column. Thank you for your help, Leonardo

I am having an issue with dates and exporting to csv. They are both kpis but any way I set it up its not coming over in any format. Need some help to get this working to show as MM/DD/YYYY. Result of the action flow Result after action flow runs  KPI 1KPI 2   

I have trigger-based task list configured in a view. Is there any way to close the tasks in bulk instead of one by one?

Hi everyone, I’ve got the following Issue:I have an action flow that queries data and builds up an HTML view in the form of a table for all its entries.In the end I  trigger a Process Automation Skill to send an email via the “Email by Celonis” action. My hyperlink is correctly tagged with:<a href="https://url:port/sap/bc/gui/sap/its/webgui?~transaction=*transactionname%20table-field%3Dsalesorder%3BDYNP_OKCODE%3D%2F00%23" rel="noopener noreferrer" target="_blank"> salesorder</a> but in the mail I only receieve the text “salesorder” without the hyperlink. On the other hand when I use the URL as the hyperlink text it gets through with the mail:<a href="https://url:port/sap/bc/gui/sap/its/webgui?~transaction=*transactionname%20table-field%3Dsalesorder%3BDYNP_OKCODE%3D%2F00%23" rel="noopener noreferrer" target="_blank"> https://url:port/sap/bc/gui/sap/its/webgui?~transaction=*transactionname%20table-field%3Dsalesorder%3BDYNP_OKCODE%3D%2F00%23</a>but only because my

Hi, I was going through academy links for Process Copilot but I don’t see the “Inspect response” option. has this been changed recently? 

I have created a form in celonis, i would like to be able to provide the link to multiple people to complete and then the data be submitted and stored in a table in Celonis. The only way i have managed to do it so far is using get form link in action flows but i have to specify an email address. I won’t know who will need it so cannot do this. Any help or suggestions? 

Hello CommunityI played a little bit with augmented attributes and now want to fully delete it.As you can see in the screenshot I deleted the augmented attributes within the Knowledge Model but the corresponding records still occur. The “delete” button is disabled.Question: How can I fully delete this unneeded stuff?Best, Thomas  

I have a Knowledge Model, and I am not sure how do I import that knowledge model data into Celonis Forms. I am only getting options for UI aspects like text, table, numbers, etc .Please someone say how to do it ?

I just set up a free account. I am an admin in the account.I created a data pool and then when I click on “Connect to data source” it flashes the dialog box with the connection options for a second and then the screen switches to a 403 error - “oops you’re not supposed to be here”I checked the permissions on the data pool and the correct permissions are set.I checked the permissions for the the user (an Admin) and all is correct.I searched the community but did not see a match.Any ideas?Thanks!

Hi Everyone, I am working on a particular information to check to extract which is User Group Permission  and User Group through the ML Work bench.  Please keep your thought for helping. Thanks,Shakthi

HiI have a Annotation Builder run that is stuck at 80/100 transactions. When I click the cancel button it does not cancel. When I click the stop button it does not stop. When I do this enough it does stop - but when I run the next set it starts up again

I am working on an engagement where we want to create Purchase Orders (PO) in SAP triggered from Celonis based on Purchase Requisitions (PR). We are trying to implement this via Action Flows using an RFC call (BAPI_PO_CREATE1). We have the following scenarios: Mirror PR – All PR lines in one PO with identical lines Combine PR – Combine several PRs into one PO Individual – Multiple PR lines are converted into individual POs Add PR – Add PR lines into an existing PO For scenarios 1, 2, and 4, there can be multiple PR line items that need to be created within a single PO (or appended to an existing PO).Current ChallengeWe are facing issues in structuring and passing multiple line items from Celonis to SAP within a single RFC call. Specifically:We are able to fetch multiple PR line items using “Get Rows”We are using Array Aggregators to construct required SAP structures like POITEM and POITEMXHowever, Celonis Action Flows seem to allow only a single linear route into the RFC module,

Dear Colleagues, I have a simple Action Flow where I “Get Rows” (Celonis module), then I “Create Excel” (XLSX Excel files module) containing the data I selected, then I “Send an Email” (Email module) with the excel I had created.Everything works, however in the “Create Excel” module where I do include headers, finally in the excel file they look like this: “O_CELONIS_PURCHASEORDER.PurchaseOrderItem” - is there any way to customize these headers or at least get rid of the first part “O_CELONIS_PURCHASEORDER”?Thanks and kind regards, Malgorzata 

Hi, I know that this subject already had some answers, but most of them are rather old, and a lot of things changed since then. :)Around 1.5 month ago my company filled form on Become a Partner | Celonis, but we didn’t receive any answer since then. Is there any way to check the status of it, or person I could email? We’re mostly located in Poland, but also having offices in Belgium and Germany.Best Regards,Mateusz Dudek

Hi everyone,I'm using the Conformance Checking feature in Analysis to model a process and run conformance checks on a case‑filtered event log (since multiple processes are included in the same dataset).When I switch to another process variant and upload a new process model, the Readable conformance explanations start referencing incorrect activity names. However, the underlying conformance checker results still show correct explanations.It seems related to the REMAP_INTS function that runs in the background, creating a temporary INT column on the activities table and mapping these integers to activity names. My assumption is that this mapping is not being refreshed when switching filters or uploading a new model.My main question:→ How can I reset the Readable conformance results after changing filters or uploading a new model?Secondary question:→ Is there a way to force a reset of the temporary INT mapping column in the activities table?Any insights or workarounds are appreciated!

Hi - Is it possible to 1. Use PAM in a View or 2. Recreate the PAM formulas with PQL?

Hi, is there a way to see/use autogenerated KPI in the View?