Product Q&A

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 :)

Hi all, I am looking to remove some old data tables from our data pool and clean up the data pool. What is the best way to achieve this? When I run a script to drop the tables, I am unable to execute it and receive the following error"Cannot drop Table AFKO because other objects depend on it" I have removed it from the data model and performed a full reload on the data model. Thanks,Michael

Process Mining Data Engineer (m/w/d) im Team Process Automation & IntegrationZurich Gruppe Deutschland Location: KölnDescription: Mit von dir konzipierten bedarfsgerechten Process Mining Lösungen auf Basis von Geschäftsprozessen und Fachbereichs-Anforderungen trägst du mit dazu bei die digitale Transformation von Zurich täglich weiter voranzubringen. Apply here

Werkstudent Center of Excellence for Robotic Process Automation focus process mining (m/w/d)Deloitte Location: MünchenDescription: Du machst den Unterschied. Ob im Business Audit & Assurance, Risk Advisory, Tax & Legal, Financial Advisory oder Consulting: Wir bei Deloitte unterstützen unsere weltweiten Mandanten dabei, sich kontinuierlich weiterzuentwickeln. Entdecke ein vielfältiges Arbeitsumfeld, das ständig in Bewegung ist und immer um ein Zentrum kreist: dich und dein Know-how. (Check out the full description following the link) Apply here

Hi ,I need a tech support here. Here is the stiation. I have cases like Case 123Activity 1 - Attribute A = XActivity 2 - Attribute A = Y Case 231Activity 1 - Attribute A = WActivity 2 - Attribute A = Z Case 321Activity 1 - Attribute A = QActivity 2 - Attribute A = X Now I need to create an olap table likeCAse 1 -Attrubute A - Case 2123 ------- X ---------321 because their both Attr. A = X right ?but how ? I think domain table is not for it.

Hi, I have a SF connection set up to extract data (non-realtime). What type of Salesforce API does Celonis use for data extraction - Bulk / SOAP / REST ? Thanks,Bhasker

How to remove leading zeroes from any column in OLAP table?

Hello, I would like to know if there is any way in which when adding data to my excel sheet, the information is also updated within my visualizations in celonis.

We need to find the best way to form a connection. How do we go about this? Would it be best to do it on-prem and download the extractor server? If so Would a JDBC connector work? But don't we need to open up access to any firewall ports if needed for that-which is a problem in our case-right? We have thought about the ServiceNow connector offered by Celonis however I think we cannot use it due to the firewall issue. Would an extractor builder work? Celoxtractor via python? What alternatives can we use?

I am looking for any information or documentation which Celonis might (could be connector, or general information advice) on developing process mining for Procurement process using data from Fusion. Any help would be appreciated. Thanks

Hi, is there a free trial version for Celonis EMS to install locally rather than a cloud instance of Celonis EMS ?

All, I am asking some basic question to see if experts are doing something different.Question 1) Consider a P2P Process - Do you take PO -OR- PO-Line items while building case key (I take Line item by the way)2) Date filters - Do you use creation date as standard filter or you change it depending on use case, For example, I take PO creation date for generic overview of analysis but for "rework" I take date of rework in rework analysis sheet.  What's you view?Regards, 

I delay the data that i set in my transformaitión datables with replication dependencies., but i need as realitme data as posible, and five minutes on delay in same tablas generate me incorrects action on Action Flow.

Hi all, Now I'm checking Celonis feature and I found delta/full load option when I try to execute data job with data connection. Does anybody know how to use and how it works? I Checked document portal but I don't find any technical suggestion.  Best regards,