General Product Q&A

When I upload files to my data connections, my data pool still says that I don't have any data connections yet. How can I fix this?

Can anyone please explain what is Set Identifier? which is new option inside a data model

Here is my YAML codeid: input-box-1d9cff2d-89eb-4104-9954-e79ad9fb5b9atype: input-boxsettings:  type: number  onChange:    update:      variables:        - name: FTE_cost 

Hi everyone, I need an help: I want to indentify and calculate time between an activity 'A' and others that start with 'REC' (like image below) I'm able to identify the cases with PROCESS EQUALS: PROCESS EQUALS 'A' TO ANY TO LIKE 'REC%'but I can use the function LIKE in CALC_THROUGHPUT CALC_THROUGHPUT ( FIRST_OCCURRENCE ['A'] TO FIRST_OCCURRENCE [ 'REC%' ] , REMAP_TIMESTAMPS("Activity"."timestamp", DAYS))It gives me the warning "Target Activity "REC%" could not be found in the activity column and it doen't calculate the time.Another use I would like to make of it, is to use it inside match_process_regex, likeMATCH_PROCESS_REGEX("Activity"."activity", 'A'>> 'REC%')it gives me the same error of calc_throughput and it doesn't identify the right path. How can I solve? How can insert the LIKE function in other functions? Thanks

I'm trying to add labels based on the 'EventDescription' column for task mining:However, this column doesn't appear in the dropdown menu of the 'Create Label' interface, which seems to limit the available columns for labeling: Does anyone know how to include this column or any similar unlisted columns in the labeling rules? Looking for any advice or workarounds. Thanks!

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

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.

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.  

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

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.

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.