Product Q&A

I have successfully set up an Action Flow to output my Celonis Query in an Outlook 365 email. I use The Celonis Query Data module  → CSV module (create CSV) → Tools module to compose a String for the CSV file to be inserted as a file attachment in Outlook → MS 365 Email Outlook module to Create and Send an email. (see image below).This all works great and we filter to output specific customer data. Today, we manually fill in the customer email contact info.However, we would like to use the Customer Contact data from the Query (name/email_address) to automatically populate the MS 365 Email Recipient. I have observed that the Tools module is limiting what data flows into the Outlook module and within the Outlook module I do not have access to all of the individual Data values from the Celonis Query.When I remove the Tools module, all of the Celonis Query Data module data is readily available for use in the Microsoft 365 Email Outlook module. (but I don’t have the CSV file formatted the w

Hi, Came across the below slide in Partner asset library but couldn't find any file in the below format. Can you please let us know where to find activity definitions for a particular process along with the conditions used. Thanks.Regards,Deepti

Can anyone has this mapping information?I would like to see the list that shows the mapping of Celonis activities (eg: AP process) to SAP tables.Like while calculating the clear invoice steps which tables, timestamps are used in SAP. Similarly for other activities. This will be a good reference document to begin with and help to customize the activities in Celonis if we need to do so.Appreciate your inputs here.

Hello, How can I extract data from a field from a datapool table without updating the Data Model in an Action Flow?Is it Possible? Thanks

Can I automate the process of doing UCC e-filing on a state website through setting up an Action flow or any other fearure present in Celonis?

Hi All,I’ve following error message when trying to reload the OCPM data model: The Data Model Load experienced an issue with the Data Pipeline Orchestrator. Celonis Support ID: 22950f46-9f10-46af-96de-887c2e2d81a5 Does anyone know what could be the issue here? Thanks,Sunil

Hi, I am not able to finish the Exercise - Push Flat Data via ML Workbench and Exercise - Push Nested Data via AWS CLI as in both the cases even though I am doing all the steps correctly still it is giving me S3 file upload error.

Dear all , Is there a handy reference for Oracle EBS tables related to procurement , order management and inventory for process mining ? 

Hi all,I want to use the Process CoPilot with the built-in python tool in order to execute ad hoc calculations.https://docs.celonis.com/en/tool-activation.html#UUID-3c37cb75-0631-254f-a5b1-1a70ffd8d5f4_UUID-5523d1d0-d4b7-e2d3-4ebe-f999dffd6357and https://docs.celonis.com/en/tool-activation.html#UUID-3c37cb75-0631-254f-a5b1-1a70ffd8d5f4_UUID-b801ca95-08b6-fe38-c5c5-89bffe3f22aaI don’t understand the examples...My question:HOW can I implement this? HOW is the data going to be accessed and loaded in order to generate a dataframe? The examples in the docs don’t help me at all … Why is a df generated from a “KPI”? There is no relation between “get_data” output and the “code” …  HOW should I use get_data and python? HOW do these tools interact?Thank you in advance and best regardsJan  

Hi All,I wanted to know if there is any way to implement looping concept in vertica SQL in celonis. I have a use case where I have to compare two tables on the basis of a certain date type column and this comparison must be done for every month in the data type column. So, in this scenario I wanted to use the looping concept as in other coding languages like python.Thank you in advance,Akshay

Hello fellow Celonis users, I am trying to create a snooze function for my clients so that certain data will not be taken into account for analysis for the snooze set amount of time. I was wondering if it was possible to set a timer on an Action flow so that could be made possible or if you would suggest taking a different route? thank you in advance

Hi, Is there a way to arrive at hierarchy of accounts as shown below using SQL (or) PQL?I need to identify the first sold to account (ZSLD) for partner 2 using Table1 and Table2Example  

It is possible to create a table that is filled with defined variables that count certain tasks.You see, in my organization we have 2 people responsible for the tasks, which would be the User and the Supplier. The User is responsible for 3 tasks and the Supplier for another 2, so I would like to make a table that appears Responsible   #Quantity of tasks completedUser                       30Supplier                   5 I can only add them as a columnCOUNT (DISTINCT CASE WHEN "_CEL_CRED_ACTIVITIES_ARIBA"."[APRO] Estado de la tarea" like 'Approved' OR "_CEL_CRED_ACTIVITIES_ARIBA"."[APRO] Estado de la tarea" like 'Reviewed'and "_CEL_CRED_ACTIVITIES_ARIBA"."ACTIVITY_EN" like 'Revisión Usuario' THEN "_CEL_CRED_ACTIVITIES_ARIBA"."ACTIVITY_EN" ELSE   NULL END )

Hi all,I am working on this project where I need to process KPI via email. I have taken CSV file as a data model.But I am unable to perform iterations on my data. Please help me on this part

Good morning, can someone please help with the PQL to return the case with the minimum cycle time? Thank you. Denise

SKILL:OUTPUT ATTACHMENT:Can someone explain why this is happening that encoding is not perform - what do I missed?

Hi I am trying to create a line chart to compare avg throuput time between two activities how it fluctuates between different months. My Dimesion is this formula: ROUND_MONTH("AE_process_dataset_with_realistic_time_variabilities"."TIMESTAMP") My KPI formula is : PU_AVG (DOMAIN_TABLE ("AE_process_dataset_with_realistic_time_variabilities_CASES"."CASE ID" ), (  CALC_THROUGHPUT (    FIRST_OCCURRENCE [ 'Arrival at A&E' ]    TO    LAST_OCCURRENCE [ 'Initial Assessment' ] ,    REMAP_TIMESTAMPS (      "AE_process_dataset_with_realistic_time_variabilities"."TIMESTAMP" ,     MINUTES    )  ))) But I only get a graph for the first month:  Please can someone advise what I am doing wrong?

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.