Product Q&A

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  

  Latest trend: #AI 

Hello everyoneI'm relatively new to building custom Celonis components in Studio and I've hit a wall with something that seems like it should be straightforward. Hoping some experienced folks here can point me in the right direction.The issue: I'm trying to replicate the built-in throughput time explorer with a custom component, but I'm getting different results:Built-in explorer: 12k cases (1-day filter) My custom component: 13k cases (same filter)What's confusing me:I exported both results and compared them - all 12k cases from the built-in are in my results My component has ~1k additional cases that seem valid when I check them manually These "extra" cases definitely meet the 1-day criteria, so why does the built-in exclude them?My current filter:FILTER CALC_THROUGHPUT(FIRST_OCCURRENCE [ '${start_activity}' ]TOFIRST_OCCURRENCE [ '${end_activity}' ],REMAP_TIMESTAMPS("TABLE"."EVENTTIME", MILLISECONDS) )/ 86400000.0 BETWEEN ${min_days} AND ${max_days}; Questions:Did I make a mistake in

Does anyone have the steps to do the data integration with the Dynamics 365 for order to cash process?

Dear Celopeers, We already extracted the relevant tables from the customers system. Nevertheless, as the cutsomer is using Infor, we are lacking the expertise with this software.Are there any scripts available which we can use in order to facilitate the next steps? Thank you! Kind regardsRaluca

Hi,I have an action flow with a Router module, and I want one of the branches to just end the Action Flow without going through the rest of the Modules in the Action Flow. Because I have an Aggregate module, it always continues executing from there, so I want to just stop the Action Flow at specific condition. Thanks

These two tables are related in 1-N relation(VBAP:1 and VBRP:N). Also in some cases there are no entries in VBRP(AUBEL and AUP) for some entries in VBAP(VBELN and POSNR). I am creating an Olap to find all entries in VBAP (VBELN and POSNR) which does not have related data in VBRP(AUBEL and AUP) but they dont show up in olap. If i remove the VBRP columns from olap then they show up.

Hi!I’Ve been struggling with setting up the correct PQL for visualising a KPI on a line chart showing a timeline as the formula became quite complicated. Would appreciate any help on understanding what query I need or why it is not working.  The KPI I want to display on a timeline chart is a cancellation rate. The view contains an input dropdown as a variable  ${outlier_analysis_selection_main.pql} which the dashboard should adjust to. The dimensions of the line chart are ROUND_MONTH("CASE_TABLE"."DSL_ORDER_DT").  In the line chart, I already have the overall cancellation rate.This does not adjust to any user filtering done through the dashboard, nor the selection through ${outlier_analysis_selection_main.pql}. I also have another cancellation rate line which does adjust to any user filtering done. I can therefore compare the development of the cancellation rate for whatever is selected to the overall cancellation rate. Now I want to add a line that always shows me the cancellation rat

I have the following lines of code for which I would like to create a table in which we see the total amount of transaction codes, another column with total amount of transaction codes per company code and the amount of transaction codes as a percentage of the total transaction codes, per company code.In the back end I have managed to write these codes, however, because of a lack of the 'Over' function I can't seem to be able to make it work in the front end. These are the codes in question that are currently working in the transformation scripts ( back-end ):select TRANSACTION_CODE,ACTIVITY_EN,Company_code,Count(TRANSACTION_CODE) as count_tcode,SUM(count(TRANSACTION_CODE)) OVER(PARTITION BY Company_code) AS total_per_Company_code,ROUND((count(TRANSACTION_CODE) * 100.0 / NULLIF(total_per_bukrs, 0)), 2) AS percentage_per_Company_codeFROM _CEL_AP_ACTIVITIESGroup by TRANSACTION_CODE,ACTIVITY_EN,Company_codeHow would you go about creating a PQL script that could tackle these lines of code

Dear Celonis users, I only know how to create a filter in KM and apply it to a table.  I would like to restrict the scope of filters, so that they will only have impact on one tab, when I put those filters in the filter bar. Is it possible to achieve this goal on Celonis web version?

Hi,What I’m trying to do is essentially pick the last but one non-automated user from the event log and pull it to object level. The previous non-automated user needs to be different from the last non-automated user.In the sample data shown below the desired output would be JANE.I’ve tried looping one PU_LAST and using it as filter for another PU_LAST but doesn't seem to be working.PU_LAST( OBJECT ,  EVENT_LOG , EVENT_LOG NOT IN (PU_LAST( OBJECT, EVENT_LOG,EVENT_LOG NOT IN (‘AUTOMATED’) ))  ,  ’AUTOMATED’).EVENT LOG ID USER 1 JACK 2 JANE 3 JOHN 4 AUTOMATED 5 JOHN  Any insights would be much appreciated.

Hi folks,what’s your thoughts about the OCEL standard for object-centric event data? Should Celonis support it and that way enable us to do ETL and keep log data outside outside the Celonis cloud, for instance in MS Azure?It would be interesting to hear if Celonis has given a thought about implementing OCEL or not.https://ocel-standard.org/1.0/

I have the following problem: I would like to upload a .XLSX file into my workspace via an ActionFlow. The .XLSX file is located on SharePoint Online. I can download the file using the "Download a File" action (Microsoft SharePoint Online) in the ActionFlow. However, I'm stuck at that point. In the output, the data is in "binary" format. How do I convert it from binary back to something I can import into a workspace? I have tried many things, but I just can't find the solution. Does anyone have any advice?

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