Product Q&A

Where can I get Sample data from try celonis ?

one of my team members registered as a Student, We wanted to register as a 'Partner'. I am looking for ways to change that.

Hi, I have an Action Flow with 2 modules: 1. A "Execute Process Automation Skill" module --> which launches a Python Notebook2. A "QueryData" moduleWhen I launch the AF, module 2 starts without having finished module 1 with the launch of the Skill: Note: Output says is "Queued "but de AF is (bad) finished Is there a way in the Action Flow that module 2 does not start until the previous one has finished? Thanks in advance.

Can anyone help me out with AML Banking related KPIs? or anyone have few demo dashboards to share related to AML Banking process?

Automation Rate, Simple Ratio formula is as follows: KPI("Ratio", "_CEL_AP_ACTIVITIES"."USER_TYPE" = 'B') -- result: 64.07% We are trying to replicate the same simple ratio with a standalone query instead of visual editor to understand the mechanism of the Simple Ratio. We have tried two formulas and both of them gave us different answers. Using PU_COUNTSUM(PU_COUNT("BSEG" , "_CEL_AP_ACTIVITIES"."USER_TYPE" , "_CEL_AP_ACTIVITIES"."USER_TYPE" = 'B')) / SUM(PU_COUNT("BSEG" , "_CEL_AP_ACTIVITIES"."USER_TYPE")) -- result: 65.45%  Using CASE WHEN statementAVG(CASE WHEN "_CEL_AP_ACTIVITIES"."USER_TYPE" = 'B' THEN 1.0 ELSE 0.0 END) -- result: 65.51% As it can be seen from above, that each query gave us different results and we were not able to replicate the Simple ratio as well. What is the actual backend formula used for Simple Ratio? A

Hi,  I have a Multi Event Log setup and want to show multiple event logs in the variant/process explorer.  Unfortunately merge_eventlog("table1"."activites",merge_eventlog("table2"."activites",merge_eventlog("table3"."activites","tableN"."activities")))) does not work as expected. There is no error message, but not all activities are shown in the explorer.  Thanks for any response. Simon 

Hi All,we have sales order data model and Accounts Receivable data model with separate activity tables. Wanted to combine these two models with multi event log capability. how should the SO tables VBAP/VBAK connected to AR tables BSEG/BKPF?

Request is to delete data from 2018-2020 and we were exploring of a better way than creating and scheduling scripts to delete the data, which seems manual. If there is a better way to automate the process for future as well, that will be really great!

I have created a KPI list in the view using the existing KPIs in the Knowledge model. Since a KM is connected with multiple Views, thus a KM KPI is used across multiple Views. But I wanted to have different display names for KPIs depending on the View it is connected to.Is there a way to do that? Screenshot for you reference.

Hello, for a complex formula, I need to substract two percentages in order to multiply it afterwards However, the formula including a filter is successful and consistent for a Count but not for an Avg (the result is inconsistent, far from the to-be result) :   Also, I tried to put the filter in a Case When where I obtain the percentage thanks to a division between the ‘Change Items’ (= Count) and the ‘PO Items Not Auto’ (= Count_Table’) but I have the error :    Please note that my client has the OnPremise Celonis, therefore some functions available on the Cloud may be not available here. Any help would be the most welcome, thank you and have a good day ! Best regards 

Hi,Using the embeded component iframe I can embed an analysis from the process analitics into a view.However if i do the same with an analysis from the studio it embeds the entire studio and not just the analysis. Is there a way around this? The views have the same problem but this can be fixed by using the embeded component "View" but this component doesn´t acept analysis. Best,João

We want to create a use case where we have to assign a case to user depending on some criteria automatically in Celonis views/ analysis,

Hi, Is there a way I can have a central repository of variable that can be used across Action Flows? Ex : I may have a variable with a 'Client ID' - I'd like the same client id to be used across multiple packages/Action Flows.  How can I achieve this? I see there options within an Action Flow to 'Set Variable' -but that is just for that specific Action Flow - and not something that can be shared with other Action Flows. Thanks,Bhasker

We need a Celonis extraction connector and/or app for Microsoft Dynamcis365 FO (Finance and Operations) and CE (Customer Engagement). For IT service management, ServiceNow is used. Same need there. Any existing Celonis assets for these applications?

How to check whether a certain activity has occurred more than once , twice for a single case using PQL ??

I want to get the days in this current month like if the month is june i want all the dates in june . How can I get that??

Is there a way we can highlight top 3 defaulters by company code based on the volume. So far i have seen the option which says background color if the value is less than, greater than , equal to etc etc. Any help here will be much apprecaited.

I am not sure to ask this query here, I am planning for certification exam, shall we get mock test papers/dumps for practice. Please let me know, if anyone have. Please don't mind if it is not relevant one to ask. Thanks

Hi, In the Set Variable module in my Action Flow, the 'If' expression below evaluates to 'A' whereas it should evaluate to 'B'. Where am I going wrong? if(1=2; A; B)  Thanks !Bhasker

What is the difference between Skills and Action flow? Can we perform any action in action flow based on the signals we receive from Analysis?

Hi Team, Could you please let me know how we can get the list of Whitelisted Violations that have been done in Conformance? Just like we have a function READABLE ( conformance_query ) where we can get the text of Violation, similarly we are looking for some function so that we can identify which one of them are whitelisted and which one is not.

The current way of developing transformations in Celonis for event logs is to do this per case key. The event log for PO headers has transformations with the po_header_id as case key. The event log for requisitions has it’s own transformations with the requisition header id as case_key and the event log for AP invoices has it’s own transformations with the invoice id as case key. All these three event logs share multiple activities. We would like to make this more flexible and easier to maintain. The main purpose is to have the complex joins only at a single place and to have the definition of the activities also at a single place to avoid having to maintain the different SQL statements in the transformations. The way we are thinking to set it up is to create 1 single activities table and this contains the usual columns like activity name, eventtime and user name, but not the case key any longer. Instead it has multiple columns for the different object id’s that will be populated depen

Right now I did it like this:  PU_LAST(DOMAIN_TABLE("ADR6"."SMTP_ADDR"), "ADR6"."SMTP_ADDR") The problem is for example when I've an old E-mail adress like "oldemail@hotmail.com" than after this E-mail changes to "newemail@hotmail.com" it still only shows the old E-mail in the Celonis.  Are there any ideas why? Thank you very much!

We would like to have a separate user group/role in EMS to just grant access to dashboards in EMS. Currently, admin access has full access but we would like to restrict service desk team to only grant access to dashboards and not do any development.

Configured the action flow to send an email where it would summarise at the top the total amounts and below it will be the details in a table format. The table format displays everything correctly, however the sum at the top omits when the table has duplicate values and so is incorrect.