General Product Q&A

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.

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

Hi all,we've experienced an issue with an augmented attribute, couldn't figure out how to overcome it easily and hence, wanted to go back to a previously published version. However, the Publishing Date displayed seems to be completely off (displaying October 2023 instead of Friday last week etc.) and we are not sure we can rely on these previous versions now.For testing purposes we've done 2 more changes today and published - one is displayed with date April 10th, the other one correctly with today's date. => screen shot attached.Has anyone made similar experiences and, more importantly, recommendations how to overcome this, please? Thanks.Cheers, Ines Plath