Product Q&A

Hi!  Is there any list or documentation on the use cases when Skills are better than Action Flow or visceversa? Thank you! 😀

I would like to add a filter in the 'load script' section in a sheet. that filters the content by the current month. How do I do that?

Suppose I have data for 3 months and using some connection I have imported the data in the Celonis for that 3 months and created Data Model. Again I got additional data for next 3 months, now I want to create another data model only for the new 3 months data. How can we use Incremental loading for these type of scenarios...?

I have a big data model already in use and have to make a change in several tables used in there. Previously, it was possible to change the source table using a dropdown in Name, but the dropdown it's not showing anymore. This option was disabled?  It was a very useful function and the turn off of this cause a more hours of manual work that can be avoided.  

We need to create a dynamic variable in the views as we used to create it in the analysis to hold multiple dimension values (as an example). Since the way of building views has been changed, any idea on how to build this dynamic variable in the new views? Note I tried the "Input Dropdown" component in the new views but the manual entries does not allow multiple variables option. Instead we can only input text values. 

Object-centric process mining (2024-03-05) Get a separate object-centric data model in every data pool (Limited Availability) If you’re using object-centric process mining, and you need the analysts in different groups in your organization to have access to different data, or to model objects and events in parallel without impacting other teams’ work, you can request our interim solution to segregate your teams.Normally, there’s a single object-centric data model in the OCPM Data Pool, which all analysts and admins access and edit through the same Objects and Events environment. If you request this new solution, we’ll enable object-centric process mining for all the data pools in your Celonis team. (You can’t pick specific data pools - it’s all or none.) With this setup: Each data pool gets its own object-centric data model, which only refers to the data in that data pool, and a separate and independent Objects and Events environment for modeling.You can use the existing data pool perm

How do I calculate throughput time from start to end for cases that did not meet a certain criteria. e.g I want to calculation the throughput time for cases that has a STP Fail = 'Yes"

Hello, I have installed an application from marketplace and got this error while assigning data model to the knowledge model. Please let me know what could be the issue.   Thanks

Hi,is there any best practice when to use a Skill and when to use an Action Flow? As I understood so far, both technologies enables me to automate a process. Thanks for clarifying.Marco

Hi, I have recently created a trigger with filter to compare a date field with today. The issue is that this trigger is considering all the rows where this date field is being updated and sending multiple emails (over 100) I just want one email when my model loads. Is there any way to somehow restrict the action flow to only one execution ? 

SUM(CASE  WHEN       PU_COUNT ("EKPO","_CEL_P2P_ACTIVITIES"."ACTIVITY_EN", "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN"       IN (${VARIABLE_CHANGE_ACTIVITIES})) = 0      AND ACTIVITY_COLUMN () NOT IN (${VARIABLE_EXCLUDED_ACTIVITIES})     THEN 1.0    ELSE 0.0  END)

How can I upload a list of values instead of selecting each value individually? For example, when clicking on the hidden activities icon in the process explorer and choosing a list of activities to hide.

I want to know the latest activity between A and B, in a process and create a filter. which PQL function i should use.

Is there a possibility to hide KPIs in a line chart. I have a line chart with several KPIs mapped to a time dimension. Now I only want to see only a few KPIs at once, otherwise there is no clarity in the chart. The OLAP table allows to hide KPIs via the eye symbol, in contrast this isnt available for line charts (or any other chart) Please let me know if and how this is possible. Thank you in advance!

I am trying to create a component filter for "the running past 24 months". - I can get a "since 2022" to work, but I can't get a floating filter, like "for the past two years" to work. Can you help me with the general syntax? Thank you.

As of now, task mining is showing active time but we have a requirement to show Idle time KPI next to active time. Where exactly it is storing the idle time.

Is it possible to configure the ML workbench app so that users have read-only access to notebooks? In production environment, these notebooks should not be editable, but users should be able to monitor them by viewing the output of each cell.

Whai celonis infterface ? And to connect celonis Interface with client ERP system ?

Dear Celonis Community and especially Celonis developers. For those who are not up to speed, 19th April new version of studio and “Enhanced views” were released for the training environments. (https://academy.celonis.com/pages/news-and-announcements and https://academy.celonis.com/courses/studio-view-building-experience ). From what it is indicated under one of the videos, it is going to be release for public production environments on 12th May of this year.  I have went on a deep dive (well as deep as I could in such a short time) into these new features and must admit that I am deeply concerned, to the point that I want to ask is this a practical joke? A late April fools of sorts? I see that what is being implemented is not even a change or update to views, but a complete revolution. To such a degree that I am concerned about if and how will older assets work now? As the difference between old and new views are as big as it was between analyses and views when they were introduced.

What is the main differences between a validation cockpit and a process cockpit in an App or Demo? I looks like duplication to me but I am not sure if I am missing something.

Hello everyone  I am trying to perform a duplicate checking of vendor master in the machine learning module following the tutorial in the link:  https://celonis.github.io/pycelonis/1.6.0/tutorials/data_deduplication/00_Tutorial_Duplicate_Checking/ The problem i encounter is that all the libraries used in this tutorial seem to not function in the new version of Pycelonis 2.8.0   Is there any new tutorial for the data deduplication with Pycelonis ? otherwise how can i perform that using python without calling the library shown in the tutorial ?  Any help will be extremely appreciated :)  Best  Omar

Hello Celopeers, I would need your help in understanding formula similar to percentile functionality within Celonis. Preferably within Pivot table. Thanks!

Hello everyone, I have incorporated a KPI List to a View and for those KPIs shown in the list, I do not want them to be filtered with selections. In the analysis design this was possible via a check button. Where can I set this the same way in a view? Is it YAML coding? Thank you! Best regards,Julia Bauer

Hi team, I want to create a KPI to measure the proportion of items with missing routes. BUT I want the scope of my data to be filtered only on specific order types.I could add a filter on the component, but to make sure the KPI is always measured the same everywhere, I want to have the filter within the KPI calculation. I understand the below formula is not correct ('The aggregation function SUM cannot be used together with a dimension function input.') but I am struggling to find the solution. Any suggestion ? Thanks heaps CASE WHEN "VBAK"."AUART" IN ('ZCS','ZECH','ZEDI','ZCSG','ZEDC')THEN SUM (CASE WHEN "VBAP"."ROUTE" IS NULL THEN 1 ELSE NULL END)/ COUNT_TABLE ( "VBAP" )ELSE NULL END

I used the following formula: SUM(COALESCE(PU_SUM("EKPO","EKBE"."MENGE"*("EKPO"."UMREZ"/"EKPO"."UMREN"),"EKBE"."VGABE" IN ('1','7') AND "EKBE"."BEWTP" IN ('E','O') and "EKBE"."SHKZG" = 'S'),0) -COALESCE(PU_SUM("EKPO","EKBE"."MENGE"*("EKPO"."UMREZ"/"EKPO"."UMREN"),"EKBE"."VGABE" IN ('1','7') AND "EKBE"."BEWTP" IN ('E','O') and "EKBE"."SHKZG" = 'H'),0))  The KPI is aggregated at a material level and hence a CASE WHEN statement is giving me a warning. I had to use COALESCE becuase null value in the second part of the formular is making the entire value as NULL. Does this formula create rounding errors or with the existence of 29-Feb in the data? If I sele