Product Q&A

I have so many KPIs created in my KM but not sure which KPI is used in which view. So is there any way to list dependencies for each KPI ???? and helpful if we can list all KPIs not used anywhere.

Hello everyone, I'm trying to count the number of materials per purchasing group that have been active in e.g. the year of 2023: PU_COUNT_DISTINCT("T024", BIND ("_CEL_P2P_ACTIVITIES", "MARC"."MATNR"),"_CEL_P2P_ACTIVITIES"."ACTIVITY_EN"='Create Purchase Order Item' ANDYEAR("_CEL_P2P_ACTIVITIES"."EVENTTIME")=2023)) I want the aggregation to be made per purchasing group (T024). MARC provides the information which purchasing group is responsible for each material number. I need _CEL_P2P_ACTIVITIES table to filter the eventtime within my view. This aggregation works, however, when wanting to build an average (per purchasing group) like this, it does not work - error: "The aggregation function COUNT cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs": PU_COUNT_DISTINCT("T024", BIND (&q

Can anyone explain how to see details of those objects in that explorer,,,?

YAML for the dropdown that does not have 'Select all' option: id: dropdown-list-7b5fb6f2-ff12-464a-bdfb-84ff28262328type: dropdown-listsettings:  data:    columns:      - id: f89c920d-8b0b-4c7d-9399-ca6a9df35b7d        order: 100        onClick:          update:            selection: multiple            variables:              - name: benchmark_1              - name: Benchmark1_selection                attribute: ct_case_table.${dimension_benchmark}        displayName: ${Benchmark1_selection}  styles:    overflow: scroll    position:      vertical: center      horizontal: fullknowledgeModelKey: test-km-ah 

Hi Celopeers, I wonder if someone had already use case where Action Flow can generate Salesforce Tickets?

Hello, I am trying to connect to salesforce commerce cloud b2c using extractor builder, when I tried the api with postman, I am getting data when we send body in post request, but in celonis I don't see option to add body and send post request, I am getting MethodNotAllowedException for get request. Is there any other way we can connect to system?/ how to send the post request to the end point?  Thanks in advance

Please provide me some documentation on Record To Report (R2R) Process.

I have Python version of 3.8.6 by default I want to upgrade my version of python . I tried using this command in the terminal. It is asking password for it. Is there any other way to implement this?. Please let me know. Thanks, Ajith Naidu.

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.