Product Q&A

I was checking materials such as value tree in Asset Library,Currently, I can't find materials such as value trees in the Asset Library. Where can I find the latest version of the document?

Is the Celonis approach accepted by clients? If we have to take the standard approach using COGS, is this connected to order management? The standard formula seems to combine AP with O2C. Please clarify.

 I mean the table which you call <%= unit_name_1 %> etc.

I’m trying to use filter table.column = LAST(table.column) im getting errortried taking last(table.column) in a variable to use in case when but getting error that dimension function cannot be used with aggregation function

How to convert string(format YYYYMMDDHHMMSSSS) into the timestamp(date) value using either PQL?

Is it possible to take SAP material master update detail with sale order as reference .

Currently we are using the csv module to generate the report, however it does not allow formatting of numbers and headers. We also tried to use the excel 365 module but it only allows inserting information row by row which does not allow generating a large volume of data.  

Hello Team, How to use the Line (Horizontal Rule) in Views?As there's no component available under the drop down in Create Component in Visual Editor for Line Component. Thanks!

I am trying to connect snowflake to EMS through key pair authentication but not able to success. could you please provide the solution.

Hi,I am working on a dummy data and while executing the vertica sql code, getting above error.Can anyone please help me with this.

I would like to move the contents (data models, packages) of on team to another team.Since the teams are on different clusters (eu-1 and eu-5) this does not seem to work with the regular "copy to" function. This question has already answered that this is possible with the Machine Learning Workbench.Is there another way we can do this without using the ML Workbench?Thank you!

In the body of celonis process automation skill module. it is not considering styling part of html code, is there any possibility of adding styling ?

Hi,Is there a way to use conditional formatting with icon sets, similar to what it's done in Excel? I need to replicate the RR column of the table Status X Area (last column of the picture).ThanksLDRH

Hello, I would like to know if its possible to get a count of all the flows that are in total in the whole Process explorer. (Including all reworks and cases flows). To show it in a Card.

I actually found a solution for a similar question here. Proposed was the following formula: FILTER "xx"."yy" =CASE WHEN <%=option1%> = 'a' THEN 'value'WHEN <%=option1%> = 'b' THEN 'value2'END; However, as a whole list of purchasing groups needs to be excluded instead of '=' or '!=' we would need to work with NOT IN / NOT LIKE... Meaning something like: FILTER "xx"."yy" NOT INCASE WHEN <%=option1%> = 'a' THEN ('Value1', Value2', ...)END; But somehow I don´t get the syntax, right? Can anyone help?  Thanks a lot :)  

Hello everyone,i have a small problem with the representation of activities in my Celonis. For some reason a few activities are not in order when i look at them via the Variant/Process Explorer. However, if i look into my data via SQL Vertica in the Data Jobs, the Activities are in order. I believe this, because each Activity has a sorting number (descending). Usually i would expect the Activity/Process Explorer to show me the Cases in accordance with their sorting number, however this is not the case for every activity/case. Some are Ok, but some don't fit. Is there any (easy) solution for my problem? What causes this deviation?

Hi,I would like to show a dropdown in analyses with options as Last 30 days, Last 60 days, Last 90 days etc which should then filter analyses based on that date range. My code for the dropdown looks like this but it seems it is not displaying results correctly as results for say October month differ if I select Last 60 or Last 90 days. CASE WHEN   "Case"."Submission_Date_Time" > ADD_DAYS((TODAY()),-30) THEN  'Last 30 days' WHEN   "Case"."Submission_Date_Time" > ADD_DAYS((TODAY()),-60) THEN  'Last 60 days' WHEN   "Case"."Submission_Date_Time" > ADD_DAYS((TODAY()),-90) THEN  'Last 90 days' WHEN   "Case"."Submission_Date_Time" > ADD_DAYS((TODAY()),-365) THEN  'Last 365 days' ELSE 'Greater than 365 days'  END Any help in this regard is appreciated.

Hi all, Is there any standard way to use start and end eventtimes for activities in an activity table so that the duration of activities and connections are displayed properly in the process explorer? The activities table we have has (a.o.) the following columns:Case Key - Activity - Start Eventtime - End Eventtime We could define a custom process explorer KPI that calculates the (avg) duration of the activity, bit this has no impact on the displayed connections and the calculated duration of the connections in the process explorer. E.g. when the number of days between the end eventtimes of two activities is 10 days, this is what is displayed for the connection in the process explorer. But when the second activity has a duration of 2 days, the connection should display 8 days. And the 2 days should display as duration of the activity it self. Is there any standard functionality that can handle this? Best,Marcel 

Hi everyone. Happy Friday! I have a rather simple question which cannot solve on my own...For my scatterplot (see below), I would like to display the risk ID on each point, however, when I tick on 'Display data labels' only two risk names are displayed. Do you know why?  Also, two risks share the same scores (3,3), but when I put the cursos on this point it is labeled as Risk 5, instead of Risk 5 & Risk 2.  Thank you very much in advance!  Kind regards, Victor   

Hello together, after I changed the password for the SAP User, which is stored at the Data Connection, Data Load Errors occur again and again. The SAP user locks itself again and again. Does anyone else have such a problem and knows how to fix it? The password was maintained under Data Connection.Does the user need to be updated in another place? Best RegardsJonas

Dear Experts,We are planning for Celonis Task mining product demo to one of our client , We wanted to understand whether Task mining capabilities is also part of Celonis EMS product package or do we need to procure separate license to make use of celonis task mining capabilities.Thanks in Advance. Regards,Navalan Veerapandian

Dear sir. I am a student please change my categery. Acadamic

I know you can set filters in the graph, but these seem to be for the whole graph. I would like only one line to have this filter (So I can compare different days/ groups with the average values). Is this a possible feature in Celonis?

Hey Peers,  I´m trying to connect the right PO to the corresponding SO in the IM Datamodel. I tried to BIND the EKKN to the EKPO, since there is an 1:N relationship, I get following error  My current statement is  PU_LAST ( "MARC",   CASE    WHEN      BIND ("EKPO", "EKKN"."VBELN") = "VBAP"."VBELN"      AND       BIND ("EKPO", "EKKN"."VBELP") = "VBAP"."POSNR"          THEN      "EKPO"."EBELN"  END) Can somebody correct the syntax or push me to the solution?  Thank you :)