Product Q&A

Unfortunately, despite my strong dedication to completing the program successfully, I have encountered some challenges that prevented me from obtaining the certification. My first attempt at the business assessment was disrupted due to an unexpected technical issue during the exam, which caused me to lose that opportunity. In my second attempt, I unfortunately did not pass the test. As a result, I currently remain uncertified, which is disheartening given the effort I have invested throughout the program.WHAT SHOULD I DO NOW ?

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_id

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 1

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?

We are living in a time where technology is not just evolving — it is accelerating.Artificial Intelligence (AI) is no longer a futuristic concept from movies. It is already transforming the way we live, learn, work, and solve problems.AI is present everywhere:Healthcare uses AI to detect diseases earlyFinance uses AI to predict market risksCompanies use AI to understand customer behaviorSelf-driving cars use AI to make decisions in real timeRobots use AI to interact with the world intelligentlyAI is not just about coding.AI is about thinking.AI is about solving real-world problems.AI is about building systems that can learn, adapt, and improve.As a student passionate about Artificial Intelligence, Machine Learning, and Data Science, I am continuously learning:• Python programming for problem solving• Data Structures and Algorithms for logical thinking• Mathematics for understanding models

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"&gt

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’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? 

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? 

Sharing this webinar to the broader community.  It is a 30-minute webinar delivered by Celonis and AkzoNobel.  Link below to register.  GBS Beyond Cost: Working Capital & AI Transformation Webinar | CelonisLearn how Celonis Process Intelligence helps GBS organizations drive AI transformation and improve working capital performance. Register for our webinar on April 28.We’ll explore how to optimize working capital, accelerate AI transformation, and reduce Days Sales Outstanding (DSO). We are thrilled to feature AkzoNobel, who will share their firsthand success story and transformative use case with Celonis.

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 r

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

We have a Celonis view with KPIs defined in the Knowledge Model. These KPIs use time-based filters with variables like datefrom and dateto inside the PQL-code.For example:"o_celonis_VendorInvoiceItem"."CreationTime" NOT BETWEEN {d '${datefrom}'} AND ADD_DAYS({d '${dateto}'}, 1)and elsewhere in the same KPI:"el_custom_SalesOrderItem"."TIMESTAMP" BETWEEN {d '${datefrom}'} AND ADD_DAYS({d '${dateto}'}, 1) When exporting this view to Excel via Action Flows, the Get Rows module lets me reference the Knowledge Model, but I cannot pass values for these variables.Using the Data Model instead allows variable injection in PQL, but then I lose access to predefined KPIs and calculated attributes, resulting in very complex, hard-to-maintain code.Question:Is there a way to dynamically set the variables of Knowledge Model KPIs when using Action Flows?

Hello community, I have seen that some features are not working perfectly in the Studo Analysis and there are a lot of migration tool available from Studio Analysis to Views. Is there known the future of Studio Analysis? We have quite some use cases still in this older technology and I would like to assess the urge for migration. Thanks a lot.Jan

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

I’m encountering a refresh/dependency issue with a cascading dropdown setup in Celonis Studio. I have a bar chart histogram where the user selects: Dropdown #1 (Date field): “Ordered Date” or “Submit Date” Dropdown #2 (Time interval): Days / Weeks / Months / Quarter / Years The Bar Chart buckets the selected date field by the selected interval. Current logic / dependency chain:Dropdown #1 stores the selected date column PQL into: ai_purchase_analysis_histogram_dd Dropdown #2 is a dependent control: It uses ${ai_purchase_analysis_histogram_dd.pql} for its data. It stores the PQL into: graphtimeinterval Bar chart dimension uses: ${graphtimeinterval.pql}The issueThe chart updates when:

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

Hi - Is it possible to export the process explorer to an external site?