Product Q&A

In a Celonis Action Flow triggered by Microsoft SharePoint Online (Watch Items), a filter evaluates to FALSE even though it should logically evaluate to TRUE. The filter expression used is substring(lower(23.Fields.Title); length(23.Fields.Title) - 1; 1) = 's', where 23.Fields.Title is a SharePoint list Title field. At runtime, the resolved value of 23.Fields.Title (confirmed via the Filter Inspector and the SharePoint bundle payload) is C310-260430061344S, which clearly ends with the character S, so the expected result is that the filter condition evaluates to TRUE and allows the bundle to pass. However, the actual result is that the bundle does not pass the filter, and the execution log reports “The bundle did not pass through the filter,” with no errors or warnings.As we are currently facing errors when attempting to raise a ticket via Celopeers and the email support channel is not available, we are posting this in the community to seek guidance on whether this behavior is a defect

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!

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• Machine Learning for prediction and decision making• Data Science for extracting insights from da

We are looking for a Process Mining Consultant with Celonis experience for a Research-Based bio-pharmaceutical company to develop, deploy, and maintain process mining solutions that uncover inefficiencies, bottlenecks, and opportunities for process optimization. - Location: Poland (remote)- Duration: 6 months

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? 

Webinar Sessions | Celonis x AI: 𝗙𝗿𝗼𝗺 𝗕𝘂𝘇𝘇𝘄𝗼𝗿𝗱𝘀 𝘁𝗼 𝗔𝗰𝘁𝗶𝗼𝗻𝗮𝗯𝗹𝗲 𝗦𝗼𝗹𝘂𝘁𝗶𝗼𝗻𝘀AI is trending everywhere but, how do you turn hype into real business impact?Join us to explore:- Showcase of AI capabilities in Celonis, featuring a hands-on demo for service tickets.- Processand capabilities scalable for AI deployment and operation- How to get started and initiate pilot use cases📅 19 September & 26 September | 🕒 10:20 - 11:00 AMSpeakers: Federica Tella (Consultant) & Edoardo Puddu (Data Scientist)𝗦𝗲𝗰𝘂𝗿𝗲 𝘆𝗼𝘂𝗿 𝘀𝗽𝗼𝘁:- 𝟭𝟵𝘁𝗵 𝗦𝗲𝗽𝘁𝗲𝗺𝗯𝗲𝗿 𝟮𝟬𝟮𝟱:https://lnkd.in/duYZ-sQB- 𝟮𝟲𝘁𝗵 𝗦𝗲𝗽𝘁𝗲𝗺𝗯𝗲𝗿 𝟮𝟬𝟮𝟱:https://lnkd.in/dubVmgsf  

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.

In my table Nomination, the following columns are there Key, KeyType, SourceKey. I want to add an augmented attribute called SourceKeyType with the following logic : For each record in Nomination, I need to find its SourceKey and find the KeyType Corresponds to that SourceKey. For example :Key KeyType SourceKey 1 GOM 2 2 TRA NULL  After defining augemented attribute  Key KeyType SourceKey SourceKeyType 1 GOM 2 TRA 2 TRA NULL NULL  How to model the PQL?

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?

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

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

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

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  

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

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:I change Dropdown #1 then Dropdown #2 I chagne dropdown 2 onlyBut the chart does NOT update when:I change Dropdown #1 only (Ordered Date ↔ Submit Date)So it seems the chart only refreshes when graphtimeinterval changes, not when the upstream dropdown (ai_purchase_analysis_histogram_dd) changes, even thou