Product Q&A

Hi everyone,I’m trying to convert an ABAP statement into PQL but I’m not sure how to do it.In ABAP I have:SELECT SINGLE *  FROM vbap  INTO ls_vbap WHERE vbeln = ls_vbbe-vbeln   AND posnr = ls_vbbe-posnr. I think In SQL this would look like:SELECT *FROM VBAPWHERE VBELN = :ls_vbbe_vbeln  AND POSNR = :ls_vbbe_posnrLIMIT 1; But I don’t know how to express the same logic in PQLDoes anyone have any idea?Thanks!

Hello,I reached out through the Celonis contact form, but I’m looking to speak directly with someone regarding licensing. Specifically, I’d like to know whether it’s possible to obtain a license and what the pricing options are.Could someone point me in the right direction?Thank you,Max

Hello Celonis users, Good day. There is no chance for me to change anything in the data model and I mainly work in PQL Editor. My goal is to use fields from N-side tables to filter data and visualize it. More details:Data model: Table A [N] → [1] Table B [1] ← [N] Table C Table A:Material code            Warehouse            Procurement type1                                  Australia                    External1                                     USA                        Own produced2                                      UK                          Own produced2                                      USA                         Others3                                   Austrialia                   External3                                       UK                          Own produced Table BMaterial code              Responsible1                                        Martin2                                         Mary3                                         Julia Table CMaterial

Hey everyone! Has anyone tried using the Microsoft Entra authentication to create a connection between Microsoft SQL and Celonis? (https://docs.celonis.com/en/connecting-to-microsoft-sql.html#UUID-9e582e53-55d8-d3e9-7b6c-1e122f4219d9_section-idm4544307539120034248385337057)We are trying to enable this and Celonis Help source documentation we stumbled upon provides how an Entra authentication works (https://learn.microsoft.com/en-us/sql/connect/jdbc/connecting-using-azure-active-directory-authentication?view=sql-server-ver16) but we miss the steps on how do we set it up in Celonis directly. Any insights on the actual setup would be very much appreciated. TIA! Good day! 

Hi,I would like to select an item from a dropdown list, then have the from date and end date already marked in the date range component for that selected item, is that possible in Celonis? and how? Thanks a lot.

Hi everyone,in our Procurement analysis we are evaluating price developments and also compare them with external reference data provided by the German Federal Statistical Office (Destatis). The data is available as CSV flat files, which we currently download and manually integrate into our data model.I was wondering:👉 Has anyone already built an automated data ingestion pipeline for this kind of use case (regularly pulling official statistics or external CSV-based sources into Celonis)?👉 If yes, what approach or tools did you use (APIs, connectors, scheduled pipelines, etc.)?Any insights or best practices would be highly appreciated!Thanks in advance 🙌

Shipped Not Invoiced App version 1.0.0 (2023-08-01) App version now available for object-centric process mining A Shipped Not Invoiced app version that supports object-centric process mining is available now from the Celonis Marketplace. The object-centric version of the app uses the Order Management perspective that’s supplied with our object-centric data model. Before you set up the object-centric version of the app, you’ll need to load the object-centric data model with your data and validate the Order Management perspective. The app uses the objects and events that you’ve already built from your source system data and stored in the OCPM Data Pool. To get started, see Quickstart: Extract and transform your data into objects and events. To use this version of the app, you'll need a Celonis EMS subscription that includes object-centric process mining. If you can't see the Data > Objects and Events option in your Celonis environment, your team doesn't have this feature y

How can we apply colours to charts/process explorer/tables in Views?

Hello everyone, I’m using an augmented attribute  “Sendout y/n” which is based on this record identifier: EORD → Material || Plant || Supplier. This attribute is used within a dashboard and can be manually set for the default value “no” to “yes”.  In the case a user changes this combination: Material: 123456, Plant: XY, Supplier: SupplierA → 123456XYSupplierA → Sendout (Augmented Attribute): Yes, I can then use this attribute for a connected AF. Let’s say the SAP EORD table data changes → orderbook changes the record identifier would now be: Material: 123456, Plant: XY, Supplier: SupplierB → what would now happen? Would the combination 123456XYSupplierB be on Sendout: Yes? Or would the augmented attribute as it is based on the MATNR, WERKS, LIFNR know that the identifier itself changed and be by default No again? When changes occur I would need the combination 123456XYSupplierB to have the augmented attribute with: No by default. I’m assuming that this will be the case, however, I’m no

I’m trying to create a data connection between Celonis into Power BI. When I put the hyperlink into the ‘get data’ prompt, the navigator pane is blank (ie shows no data available).  I’m curious if I have the microsoft connection enabled. How can I check this? Important to note - I do not have analyst rights in Celonis hence why I’m attempting to import data into Power BI. 

Hello All,Could you help me to understand how to select recent 5 years in Pivot Table(New View). Currently i can see older data also like below.I want to limit it to last 5 years only. Please help.Regards,Apurva

Hi all, I’d like to confirm the common release process.I’m a article, and I’ve released the sub process but I couldn’t activate the process in Process Navigator. I’ve alredy checked the Permitted set and there is no permission set. What are common issues?I can’t click in Process Navigator  

My event log is too granular compared to the BPMN model. How can I  aggregate multiple small system events into one logical activity that matches my BPMN model? Is there any documentation or training on the most common challenges faced during the conformance checking with Imported BPMN model?

Hi Team,We would like to generate the Reports in Process designer i.e Standards and Standards Chapter matrix , Process performance analysis .Can you guide us how to create the above mentioned highlighted contents in report.

Hello all, I'm really excited to announce a recent feature update for Action Flows. It is now possible to trigger an Action Flow directly from a table in View using the dropdown input feature.This allows users to choose an option from a predefined dropdown list when taking an action from a view. This choice is then passed on to the Action Flows as an input and therefore enables advanced human-in-the-loop use cases.  You can find further documentation here.  

How can I get the process copilot to use the record attributes saved on a knowledge model to search for the “output” rather than using the sample from the prompt? I have tried removing the sample from the prompt and it does not work. I have used the attributes on the knowledge input section of the process copilot as well and it also seems not to be enough.

Hi everyone I have a challenge that I’m trying to figure out related to pycelonis.I’m currently trying to get the component values from a view using pycelonis. Unfortunately, I couldn’t find any information inside the documentation that can help me with this.It seems that the documentation only explains how to work with analysis or knowledge models. Does anyone know how to work with components of a view inside pycelonis?Best wishes!

Hi Team,I’m working on creating a generic Action Flow with a writeback module. Depending on the OLAP table, I need to send different inputs to select the correct table for the writeback.

Hi All,Which one is the most optimized way in Object centric while making the changes in celonis catalogue Object. for example in Deliveryitem Object i want to make changes to CDPOS table which is celonis provided one i just want to add one more attribute to the existing one do i need to use Overwrite or copy pasting the whole code in Custom changes along with my attribute. which takes less time while executing the transformation ?Could someone help me here ?Thank you in advance 

Hey, I’ve an table I hope that is being creating initially using excel import. Now that I want to update the data in the same table. Can anyone please guide me to do that. Thanks in advance RegardsChethan

Hi,Is it possible to look at the list of Cases in Process Adherence Manager, just like it was in Conformance checker?  Thanks

Hi allI have a very basic question – sorry for that, I’m quite new to PQL and I cannot apply the information available online (or did not find it).I have two tables incident_CASE with column CASE_ID (1-side) and workorder_CASE with column WORKORDER_ID (n-side) (1 incident can have 1 or more workorder).How can I count the following:Number of incidents with exactly 1 workorder Number of incidents with 2 or more workorder Many thanks for your supportBestroger

Hello, I’ve registered today to access the Celonis Free Plan demo platform (with demo data, etc), but I can’t seem to find the link needed to get to it. I’ve tried using https://id.celonis.cloud/ but it only gets me to a User Management screen. Thank you

Hi everyone,I’m trying to connect MongoDB to Celonis. At first, I assumed that I’d need to use a custom JDBC driver (based on a thread that I’ve read here and the Celonis documentation).However, when I reached the step to select the “Database Type” in the connector, I couldn’t find a fitting option for MongoDB.Has anyone successfully set this up?Should I use a specific Database Type in this case? Or is there another workaround to get MongoDB connected?Thanks for any tips or guidance!