Unanswered Questions

Good day, I have an OCPM data model with 2 objects, a case and a user. I need to select my case eventlog as the default eventlog. How do I do that? I know I can create an eventlog in Perspectives and make it the default eventlog but I dont want to create an additional eventlog , I want to select the existing case eventlog as the default eventlog. Thank you

Hi everyone, I have an issue that I would like to share in case anyone knows how to solve it.I’m currently looking for a way to send messages to multiple end users by Google Chat. I don’t want to send messages to a group, but instead to end users. I noticed that Celonis provides a module called "Inject Message Into Room", but I need the webhook URL from each user. Additionally, I cannot send messages bigger than 4096 characters.Does anyone know if there is another module where I can use just the email address from users to send a message through Google Chat to each one of them, and change the length of the message body limitation, since there are some messages that might exceed the 4096 characters.Thanks! 

Hello all, I’m currently working on combining various cycle times (e.g. from PO Item creation to Goods Receipt, or from Goods Receipt to Invoice Receipt) with key figures from my Case Table in a single OLAP table.To achieve this, I’ve tested two different approaches:Cycle Time Calculation Based on the Activity Table: This method allows me to control which occurrence to consider — for example, in cases of multiple GRNs for the same PO line, I can choose to include only the first one. The formula delivers the expected results. However, I’m unable to combine this approach with other key figures from my Case Table (e.g. Company Code, PO Item Count, etc.) in the same OLAP table. Additionally, if the cycle time is negative (e.g. GRN before PO Item creation), the formula returns “–” instead of the actual negative value.   AVG(CALC_THROUGHPUT ( FIRST_OCCURRENCE [ 'Create Purchase Order Item'] TO FIRST_OCCURRENCE [ 'Record Goods Receipt' ] , REMAP_TIMESTAMPS ("_CEL_EKPO_ACTIVITIES"."EVENTTIME"

Hi    We are seeing a strange issue where we are using the exact same formula as in Analysis for a KPI, however the data on excel generated by action flow is about 2% different from that on the analysis sheet. Has anyone encountered similar situation and what was the resolution? 

Hi everyone,I’m exploring the idea of creating a view for supplier evaluations where the supplier’s logo changes dynamically – meaning the correct logo is displayed depending on the selected supplier.My idea was to use a variable in the image component to call the specific URL for each logo. Currently, this doesn’t seem to be possible.Is this something you are looking into, or are there any workarounds? I’d love to hear your experiences.Thanks & best regards,Jan

Hey all,I have a process where I have four activities labeled: A, B, C, D.In the event log I have for one case equal timestamps for B and C: 08:11:00 until 08:23:00.My problem is that Celonis visualizes this process as A → B → C → D, however I expect the process to look like A → B, C → D. Is there any way to do this, and if so, how?

Hi,We are very interested in becoming a services and consulting partner for Celonis in South Africa. With our mix of Industrial Engineering and data management expertise across mining, manufacturing, logistics, hospitality and financial services we believe we could provide an incredible service in this country by implementing Celonis and working with customers to realise real returns. There are a significant number of Tier one companies across the above sectors that would benefit.I would ask someone from Celonis to contact me please to understand how a potential formal relationship would be structured and would work.  Many thanks,Alex StampEntity IM (Pty) Ltd (www.entitysa.co.za)

Hello,I'm trying to make the DSO indicator, but I need to get data from several tables and I'm having problems...The DSO formula is made up of two parts, Revenue and Accounts Receivable. I need to calculate each one individually and then divide one by the other.I'll use the example of Accounts Receivable:Quando eu uso os campos de Filtro, com os seguintes filtros, funciona sem problemas:FILTER "o_celonis_SalesOrder"."CompanyCodeText" IN ('CompanyNameZYX');FILTER "o_celonis_SalesOrder"."SalesDocumentType" IN ('XXXX', 'YYYY');FILTER "o_custom_CustomerAccountItem"."BaselineDate" <= {t ${end_date}};FILTER "o_custom_CustomerAccountItem"."ClearingDate" > {t ${end_date}} OR "o_custom_CustomerAccountItem"."ClearingDate" IS NULLHowever, when I try to place the same filters in Case when, to generate the indicator that will be combined with Billing, there is a connection problem between the tables (o_celonis_SalesOrder and o_custom_CustomerAccountItem).sum( CASE WHEN "o_celonis_SalesOrd

Hi Team,I’m trying to send data from one Action Flow to another without using a webhook. Is that possible? Thanks in advance for your help!

Hi team,I’ve solved duplicates in Object table, Object Change table and Events tables with ROW_NUMBER() OVER (PARTITION BY A."CASE_KEY") meaning each row is unique, and still I receive the below error from Celonis: The data model contained joins that could not be executed in the user-defined direction due to duplicates in the dimension table. Please review the foreign key connections in Data Integration. The joins of the following tables have been executed successfully in the reverse direction: [Event table]1 --> N[Object table] Does someone have any idea on how to solve it?When there are duplicates on both tables, the model doesn’t even upload. In this case the duplicates seem to be in the Dimension table (I assume, is this the object table?) and therefore the model has been uploaded, but I’m not sure all the connections have been applied.  Any ideas to solve this? Thank you in advance!

I have 2 different data source and initially i build my objects and events in one data source and next i have expanded it to other data source. When i made changes and published to development the perspectives have failed and this had impacted the views that are built on Production perspectivesOnce the issue is solved with perspectives the views are again back to normal is there any link between test perspectives and production perspectives. 

Hello,Im no longer able to access past Celosphere (2023 & 2022) video on-demand. I belief it used to be https://www.celonis.com/celosphere/2023/recordings/watch and https://www.celonis.com/celosphere/2022/recordings/watch respectively. Currently URL redirect to 2024. Is there any chance to watch year 2024 and 2023 past recordings? Thank you. 

Hi, I currently have a dashboard in Studio Analysis for which I built an Action Flow that picks up a distribution list with certain filters so that i can send out automated emails with a pdf attachment (each with different filters). Now I wanted to do the same with a View and this is not possible.50 users should receive an automated pdf of a View on a weekly basis filtered only on their set of Divisions/ Product Groups. What is the best alternative to automate this?BR  

Hi all,I am trying to extract an olap table data from a view can you guys please help me with the appropriate python/pycelonis code. Thanks,Akshay

Hi all, I try to find an easy solution for the following situation:I am triggering an Python script in ML Workbench via Action Flow.This Script is using pycelonis and extracts an OLAP table out of an Analysis. The OLAP table is containing exactly the information, columns etc. how we need the data. My first idea was to create an .xlsx file directly within ML-Workbench from dataframe and get the .xlsx file that is then stored within Jupyter File Browser via another Action Flow module. So far I haven't found a solution to access the files stored on ML-Workbench. Using Celonis Query Data -> CSV Advanced etc. is a total pain because in both modules I have to add all the columns again and do the mapping and all this stuff although the structure itself is already available on Analysis OLAP table level. Another issue is that I wanted to do this within one Action Flow and the Action Flow is not waiting till Python script execution is completed. Current workaround is the use of Sleep modu

Feature Request: User Creation Date in Celonis Admin & Settings DashboardThis request proposes adding a new feature to the Celonis Admin & Settings Dashboard that would display the User Creation Date for each account.Purpose & Benefits: Provides administrators with visibility into when a user account was created. Helps in audit readiness and compliance checks by tracking account lifecycle. Assists in troubleshooting and access reviews by correlating account age with activity. Reduces dependency on separate audit reports for basic account details. Expected Outcome:A new column/field labeled “User Creation Date” available in the Admin & Settings Dashboard, enabling administrators to quickly filter, sort, and review users based on when their accounts were provisioned.

Dear community, I would like to set up a data pool parameter to allow me to switch between test and prod environment? So I would need two global variables for my data jobs:var_data_source: to allow me switch between test schema and prod schema var_table_name: to allow me when creating table to add _test at the end of the table nameI have only found the way to create parameters in EACH data job under transformation and refer to the data pool parameter. Is there a smarter way? I am still using the data integration (not OCPM). Thanks a lot!   

Hi everyone, How can I add something to the existing data model? Thanks!

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  

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