Product Q&A

what is the PQL formula to find the rework time? for eg : we have the activity name as the dimension and i want the first occurrance of that activity to last occurrance of that activity (rework time) as the kpi in the OLAP table please help

Hi, I have a client calendar with their working days uploaded to my data model in a SAP TFACS format.  This TFACS table is also added to the model but not connected to any other table. I have done a complete reload properly already. When I go to my analysis and see the throughput time, it didn't change, even if I put all the working days to "0" in the TFACS table. It seems that isn't tacking into account my calendar. How can make it works in my analysis? Do I have to use functions to make the analysis use the new schedule?  Many Thanks, Paula.

Hi All For Action Flows can you see in the audit files which business executed the Action Flow? Looking at the history I see the fields to change but not the Celonis UserID Thanks in Advance  Michael Gordon 

I would like to know if there is any material related with customer retention. Any demo, success story or other material. Thanks.

We are trying to create an usecase as following:Calculate payment term mismatches between PO, MD, and Invoice with respect to time log of MD.How many times MD is changed per vendorFor this we have extracted the CDHDR and CDPOS data for zterm changes in LFM1, but unable to link the changes with invoices in BSEG and PO's in EKPO/EKKO table. Can anyone help me in this.

How to make 'Create CSV' Action Flow module create column as float rather than string? Numbers always get wrapped in double quotes which causes the back-end to interpret them as strings rather than floats. How to get these numbers recorded w/o the " "?

Good day, I recently signed up to the Celonis Partner portal from SoluGrowth. I am looking to complete the Sales Professional Course but cannot seem to find it in the Academy library?

1) Raw file (scrubbed):Role=MEMBER; LOC=IL;CLMC=C;Role=MEMBER; LOC=IL;CLMC=C;Role=MEMBER; LOC=IL;CLMC=C;LOC=IL; CLMC=C;LOC=IL; CLMC=C;LOB=LOB1; LOC=IL;CLMC=C;CLR=Y;LGLSST=ASGN;LOB=LOB1; LOC=IL;CLMC=C;CLR=Y;LGLSST=ASGN;LOB=LOB1; LOC=IL;CLMC=C;CLR=Y;LGLSST=ASGN;LOB=LOB1; LOC=IL;CLMC=C;CLR=Y;LGLSST=ASGN;ID=1234,TYPE=PROP;ID=1234,TYPE=PROP;LOC=IL;CLMC=C;LOC=IL;CLMC=C; 2) Desired outcome:

When I create a new analysis with pyCelonis ("create_analysis(name, dm_name)" function) , adding the model I need, it seems good but the model does not be properly updated until I click the option "update" into the analysis settings sheet.  Can I do it with code too?. Please, anything I miss?. Thanks,

Hello everyone, we have an analysis sheet that we export as a pdf via action flow. In this sheet we normally filter on a specific plant number before exporting. We want to add the plant description in the analysis as a text field, but only if just cases of one plant are selected. When there are multiple plants selected, the text field should show "Multiple plants selected". I have tried to create a formula and add the result in the text field: CASE WHEN COUNT(DISTINCT "AUFK"."WERKS") > 1 THEN 'Multiple plants selected'' ELSE "AUFK"."WERKS_TEXT"END  This throws an error as I am mixing aggregate and case based info. I have also tried to add a PU_FIRST to the ELSE statement, but this does not help. Is there a way, how this can be done? Thank you for your help.

Hey there, does anyone know if it is possible to set a filter on single columns of an OLAP table? Thanks in advance! Best regards 

I'd like to set a button dropdown to a certain value when loading a page in a Studio Analysis.  I see the documentation talks about setting a selector's value, but I see no examples. What is the method of doing this?  celonis.cloud/help/display/CIBC/Load+Scripts 

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,