Product Q&A

Dear Celopeers, Currently I am trying to extend the simulation capacity of Celonis in the Machine Learning workbench. To do so, I need to import an event log through, I think, PyCelonis. I would like to use the UI of the Process Explorer in a premade analysis of Studio to define the activities and connections that are imported.The following link suggests this used to be possible within PyCelonis 1.7 using the ‘Share your selection’ URL. (Analysis: Pull data - PyCelonis) This appears like a very elegant and user friendly solution to me.However, I can't figure out how to do so using the newer PyCelonis 2.12. I did find out how to navigate to the correct space, package, and analysis through different IDs. But the Python methods attached to the analysis object created through .get_analysis() do not make apparent how to perform the filtered data extraction I alluded to above.Any ideas or references on how to do this? Thank you in advance, Bas

H fellow Celonis useri, I am a newbie mainly using the visual editor for creating KPI's. My question is, is it possible to create a KPI for calculating the average cycle time of orders with only the visual editor (no PQL). A screenshot of the date is attached. Hope you can help, thanks! 

Hello, While creating plain text runtime variable, it is not visible in the analysis filters. Even after publishing the package it is not appearing. Is there any recent changes done to runtime variables in Celonis ? Thank You Usually the runtime variables used to be mentioned on the left panel  

Hello. Id like to confirm significant between cycle time and throughput time in Celonis. Would you tell me correct answers If I misunderstand it below. Cycle Time It means the time spent the whole workflow (ex. P2P, O2C, etc) 2.Throuput time It means the time about detail each workflows. (Ex. activity, case, another dimensions etc.) best regards.

Any work on open order app in OCPM?

Hi all,I am lately thinking of how to make my life as Data Engineer easier and get a up-to-date documentation of the current backend relationships. The goal is to see: which tables from source are transformed into which VIEWS / TABLES downstream. I want to have a quick and accurate answer to:Which tables are sources for a given table in the datamodel and how are they connected? What is the potential impact on downstream tables if I change something on a given extraction. Which tables are not in use? Potentially even better would be a granularity of column and not only View/TableI believe those questions belong all to the concept of Data Lineage. Which in my opinion is currently very poorly supported within Celonis.I would like to open the discussion on how to best do this and if this is a relevant problem to more people:What is you workflow when you face the questions above? (How) are you guys documenting the SQL Backend? Is it done manually?

Hi, I want to build an action flow that run at the end of the specific period based on the company period e.g. every month could be different October 23 is the end of the month and following month is end at November 27. How can I built this with Celonis built-in scheduling setting?? Thanks 

Hi all, I am trying to convert my currencies to ZAR using CURRENCY_CONVERT. Here is my code: CURRENCY_CONVERT ("o_celonis_SalesOrderItem"."NetAmount", FROM ( "o_celonis_SalesOrderItem"."Currency" ), TO ('ZAR'),"o_celonis_SalesOrderItem"."CreationTime" ,"o_celonis_CurrencyConversion", "o_celonis_CurrencyConversion"."ExchangeRateType", "o_celonis_CurrencyConversion"."SourceSystemInstance" )But it does not work.  

Hi, I'm using an API to extract datafor this purpose, the scope of Celonis, I am trying to adapt the configuration parameters that are 100% functional in POSTMAN, but when building Extractor I am finding it difficult to adapt 1) The API Resource first requires a POST request to generate the Bearer Token: Request POST: https://prod.api.wehandle.com.br/loginParamsAuthorizationHeader:Body:Scripts:Result Body Response:2) The second request uses the generated Token to GET data from the API Request GET: https://prod.api.wehandle.com.br/integrations/main/employees?page=1&limit=50&changes_to=2025-01-14T23:59:59.000Z&changes_from=2025-01-01T00:00:00.000Z&employee_address=true&employee_services=true&employee_manager=true&employee_supplier_company=trueParamsAuthorizationHeadersResult Body ResponseI'm having trouble recreating this integration successfully via Extractor BuilderPerhaps my starting point would be to decide the Authentication Method betweenBearer Authentic

Hi everyone, I need help with a filter.I want to put a filter on a kpi that only allows it to show the previous months data. The filter must be dynamic so that when I select a month from the date picker that it would always calulate the previous months data.I am currently using this PQL: FILTER "CEL_ACTIVITIES_OTT"."first_eventtime" >=ADD_MONTHS(PU_MAX ( CONSTANT ( ), FILTER_TO_NULL(ROUND_MONTH("CEL_ACTIVITIES_OTT"."first_eventtime"))),-1)AND"CEL_ACTIVITIES_OTT"."first_eventtime"<PU_MAX ( CONSTANT ( ),FILTER_TO_NULL( ROUND_MONTH("CEL_ACTIVITIES_OTT"."first_eventtime")))The problem is that I have to select both months from the date picker and Ideally I would like to only select one month. 

Hi All,I have created one column Month_Year in one of my tables which I am using for creating the analysis dashboard. The Month_Year column is of type Varchar and so when I am creating a drop-down component in the analysis rather than getting the Month_Year column in date order I am getting it in alphabetical order. Sure I know there would be answers to this query saying to change the datatype to date and then do the to_date function in the front end but in that scenario, I am getting unwanted things like day, time, hour, seconds and all. I only want the month and year to be displayed in the dropdown and that to in date order. Can anyone please help me on this query

Hi,I want to create an action flow by querying a data within a specific range of date (e.g. total number of PO created from 01 November 2024 to 01 December 2024). How can I achieve that?    

Dear all,I am currently working on building a view for the management team to track KPIs across the entire organization. The organization consists of multiple entities, each using different systems (e.g., SAP, MSSQL, etc.), and as a result, we have multiple data models in the backend.In the overview view, we want to visualize data from these different models in a single interface. I have created a space that contains one view and multiple knowledge models. I would like to confirm whether this approach aligns with best practices and if it is possible to achieve my goal with this setup.Looking forward to your insights.Thank you,Yuyao

Hi There, does anyone know if Celonis can take snapshots of values? We determine inventory but its always the newest and latest figures and I cant find a proper data to use for a timeline graph of inventory. So I was wondering if its possible for Celonis to take a daily snapshot of a figure for use in a graph. 

I’m trying to build a Website journey with OCPM. I expect to have various objects like Web Object, Order Object, etc in the flow. Considering just the Website frontend, in case centric approach, to show the traversal throught the various webpages, I could imagine having the webpages as the activity, however when moving to OCPM, I’m wondering how the scenario should be modeled. Since (I assume) the webpage traversal would be events affecting the Web Object itself and there is a possibility that there is far too many webpages to manually keep adding to events, is there a better way of building this journey with OCPM?

Has anyone implemented JD Edwards P2P connector? I need to understand how it works and recomendations coming from real project experience.

I’m trying to add a total line to a table in Celonis, similar to a total line in an Excel pivot table. In my table, my first column is a dimension and the rest are aggregated KPIs. But my end user needs to see the overall total, too. Any thoughts?

Hi,We have a scenario where records can be created/deleted in source system multiple times.We are currently using the replication cockpit for extracting changes, but for deleted records we do not get the full information of the deleted records, we only get the primary key of the table and a change indicator = ‘D’ (Deleted) and we would like to know what the values of all the attributes for the specific records were prior to the deletion. We have located the following staging tables and views:_CELONIS_TMP_{TableName}_NEW_DATA  _CELONIS_TMP_{TableName}_TRANSFORM_DATA {TableName}_DELETED_DATA Unfortunately, it seems like the _CELONIS_TMP_{TableName}_NEW_DATA table only includes records with change indicator = ‘U’ (Updates) and not change indicator = ‘I’ (Inserts). This makes it difficult for us to map what the historical values were, if we have both inserts and deletions within the same execution of the replication cockpit.Does anyone know of a staging table for inserts we can use, befor

I am trying to filter records using predefined filter assigning value thru parameter in popup view. But the value is not properly assigned to the filter. Its filtering everything and not showing any data. However filter works fine when i assign value in the filter. The value to the view thru variable is passed properly and I can see the value in text box.This works fine: FILTER "o_custom_DeathNotification"."DeathNotificationId"='58b22b1d-771b-4b1a-8937-9fb90d82b491'This doesn't work: FILTER "o_custom_DeathNotification"."DeathNotificationId"='${var_dn_id}'

How to add a custom KPI in the OCPM process explorer?

Hello all,I am struggling to calculate the average count of activities for similar cases. The calculation returns a wrong result. It doesn’t matter if I use PU_COUNT on the activity table or CALC_REWORK. Example DataCase ID Parameter Number of Activities in Activity table 1 A 10 2 A 10 3 A 20 4 B 15  I would like to know the amount (count) of process steps (activities) on average for cases with a certain parameter.Expected ResultParameter Average activities count A 13.33 ((10+10+20)/3) B 15 (15/1)  What I getDimension: ParameterKPI:  AVG(CALC_REWORK())Parameter Average activities A 15 B 15  It does consider the ‘10’ activities for case 1 and 2 only once. So if the number of activities is the same for multiple cases (which might very well be the case), the calculation is wrong. If I remove the Dimension, I get the correct overall result of 13.75. But as soon as I add the Parameter as a dimension (which I need), the result is not correct anymore

Hey, I can see that we have alert subscription option for action flows. But can we get the error information somewhere for each email sent ? I am currently working on creating an action flow tracker, for which I want to track and visualise the number of emails sent with each action flow stream and what error that action flow stream faced that too. Let me know if any ideas for the same. Thank You

Hi all, is it possible to alter the push csv to Data Integration but instead of using one drive using sharepoint. I tried it but it always tells me that file cannot be found. Also the id that i have to use for the make a request in the documentation does not exist Push CSV to Data Integration (celonis.com).Thanks in advance :)

I'm using a SharePoint connector and the Microsoft 365 module to read data from XLSX files. These files are constantly updated, and I needed a way to get rid of them after a certain time. I know that Microsoft 365 has a function to delete a table, but it deletes a sheet, not the whole file. The SharePoint module has a "Delete an Item" action, but it doesn't seem to bring the correct files. Is there a way to do this? If not, is there a way to move files from one path to another inside SharePoint, still using only Action Flow?

Hi,I am working on a KPI (A), which is calculated based on the result from another KPI (B) but this KPI (B) should not affected by Dimension selections. Do you know if this is possible? Thanks