Product Q&A

Hi Team,We are working on reviewing our landscape with respect to Celonis best practices.Currently we have multiple data pools and extracting data from multiple connections.In many cases we can have a situation where:1)Getting data from same connection but using extracted data for different data models.2)Getting data from different connections and combining extracted for single data models.3)Often times buiness requirement for same process may vary for different units and they would want to see different views / analysis / actions for them in those case how the data pool should be structured. Are already there best practices along these lines with pros and cons?

Dear Celopeers, We have an SAP On-Prem extractor which make RFC calls with multiple SAP systems within our organization. We want to now add a new connection/SAP System but the connection has to be SNC. We already have the instructions for setting up SNC, but the question is Is it possible to use the same extractor and configure so that only one system needs an SNC and others work without those server certificates? Or If we want to add a new connection/system with SNC setupeither we must have the server certificates imported for all the existing systems or we we should have a separate extractor with SNC?  How does this work? To clarify, only system 3 in the picture needs an SNC. 

In one system I have two processes with two number logics. First one is called S_ID and shows Process A ("From Receiving Technical data to releasing technical data for invoicing". 2nd one is called "L_ID" and shows process B "Creating data set to invoice sent"  If data has status 4 in the system, the data has been transformed from process a to process b and every s_id is combined with a L_id.  I checked with a table if ir possible to see status4, s_id and L-id in one table and cheked in the source system if the data is correct- it is.  In the Data model I created two activity tables and zwo cases tables, one with S_ID logic, the other one with L_id logic.  The last step should be to combine the data so the customer is able to see the whole process from receiveing the technical data to invoice sent.  I tried it with this script, and I know it is not correct yet:  case when"TableS_id"."STATUS"= 4then Bind("TableS_id", PU_first(&

Hi all, I'd like to calculate through put time of workday, I have a table that contains holiday. I found something workday setting but I'm not quite sure how that is work. If anybody know something like this, please give me advice. Thanks

I am trying to extract the date from a string. the date comes after '-'. The challenge is that there can be more than one instance of '- '.So, tried to find the '-'followed by a space and '/'after 3characterString sample: $$$$$ $$$$$$$: $$~$$$$ - $$$$ $$$$$$$$ $$$ $$$ ~$$$$ $$$$$$$$ $$/$$/$$$$ - 07/01/2022 $$$:$ $$$:$ $$$:$.$ ( i want to extract the date after the second '- ') Code I used:(code gives me error)CASE WHENMATCH_PROCESS_REGEX ( column, '.*- .{3,}/' )=1THEN TO_DATE(RTRIM(RIGHT(STRING_SPLIT (column, '- ' , 0),11)),FORMAT ( '%d/%m/%Y'))ELSE NULLEND Thanks In Advance

Hi all,is it possible to extract large object data types from oracle to celonis ems with jdbc extractor? Thanks,Markus

Hello, I tried to start the Get Data into EMS partner exam today and it stated I only had one attempt remaining. As far as I am aware we are supposed to have 2 attempts. Is this message showing because the attempts are counted as "1" and then "0" remaining?  Or is it because I passed the "Build Analyses" exam earlier today and I was supposed to wait a little bit more?

I'm looking for an easy way to import previously used KPIs, Variables, etc. from analyses and importing them into Knowledge Models. I remember there was a way to do it in PyCelonis 1.7.6 but I seem to have lost the post where I previously asked the question and I cannot find the script I used as well.  The idea would be to make it much easier to create knowledge models without having to manually input all the data points. If there's a catalog/repository of all the formulas/variables/etc, should be able to mass insert them into a knowledge model.

Notwithstanding the Custom Built Templates, which a user can create themselves in Views, is Celonis intending to release a 'Dashboard Catalogue', which new joiners or even existing can utilise (i.e., prefabricated dashboards)?

How can we only display cases that are currently in a particular activity? We have tried using PROCESS EQUALS TO & SOURCE / TARGET ACTIVITY functions to filter and only display these cases, but they fail due to the following... The 'current' activity is irrelevant for PROCESS EQUALS as it technically hasn't been reached yet (e.g 'Verify Invoice' is in progress but not actually complete, so it wont appear as a triggered activity in the log) There are multiple routes in our process that lead to this 'current activity' that also have many routes out to other activities. This means that both PROCESS EQUALS TO & SOURCE / TARGET ACTIVITIES cant be used to filter out just cases relating to the current activity, as they require singles routes with a clear starting point (Activity 1) and end point (Activity 2) to work effectively, not multiple possible paths.  We also want to calculate how long this case is been in the 'current activity' but run in to

I am using router to put condition but it is sending empty file as an attachment which should not suppose to happen.

Hi all, I have setup an Action Flow that extracts data from a data model containing several fields and filters. The result is used to generate a CSV file.At the end I get a table containing a lot of duplicates.I haven't found any setting in Query data nor in CSV Advanced to filter out complete duplicates. I also haven't found any other module I might can use after CSV creation to remove duplicate rows. Do you have any idea how to get rid of duplicates? Thanks,Dennis

Currently, we have extracted files by SAP table as follows and uploaded them.    It then asked me to select a table to use, which I did as follows  However, I'm stuck on the part where I specify the activity table. When I uploaded using quickstarts, celonisEMS automatically created a table called "_CEL_P2P_ACTIVITIES", but I don't know how to solve it when I proceed with a normal upload.  If you know of a workaround for this, please let us know!Thank you!

I'm trying to plot a simple vertical bar chart with it's labels displayed above each bar, but I can only plot it horizontally the way I want, otherwise the wrong information goes into display... Any idea how I may overcome this? This is what I have at the moment:And this is what happens when I swap its axis:How should I write the YAML marks and encodings to sort this out? 

Hi, I have an eventlog, with two IDs: JR ID and App ID. JR ID is always present, whereas App ID is only present in certain activities. The relationship between JR ID and App ID is 1:N. I have created a new ID as a combination of both, to use as my case ID for the eventlog. Then i created 2 eventlogs within Celonis using simple formula:  EL_APP:CASE WHEN "Eventlog"."APP ID" is NOT NULL then"Eventlog"."ACTIVITY"end EL_JR:CASE WHEN "Eventlog"."APP ID" is NULL then"Eventlog"."ACTIVITY"end The idea behind is to show a transition between both newly created eventlogs. Sadly, Celonis doesn't find any common ground for transition and both the eventlogs are shown without any transition. So my questions is: On what basis does two eventlogs create a successful transition? What am i missing here? Sadly this link doesn't help me with my investigation. https://docs.celonis.com/en/process-explorer.html#UUID-fa936c2

Hi, I have a following conundrum that I'm trying to resolve. In studio analysis I have a tab in which I have two Button dropdowns. First one is for selecting a categories like company code, business unit, country etc. Based on selection from the first dropdown users can select specific company codes or BUs etc. in the second one (this drop down is a multiple choice one). That selection is stored in a variable which feeds the bar charts. So for example someone is selecting 4 company codes and my chart shows bars for each company code selected for each month. In a basic form all bars are the same color. I would like to color it the way that each selection from second dropdown (i.e each cmpany code) has its own color. I cannot use series palette as user can select from 1 to n number of company codes (or BUs or countries etc.) so the number of colors needs to be automatically adjustable. The original idea was as following - lets create 5 to 10 variables and each would take one value fr

Hello Team, Is it possible to add styles using Custom Objects for view component "Textbox". It seems there is no Custom Objects property allowed in Textbox.

Hi, I'm unable to upload dataset in in the tool, ERROR- Remote application on http://integration/integration/api/internal/data-pools/data-models/655b7a20-e1d7-4c50-b4d6-328a000bb992/load-info-sync[GET] responded wi

Hello everyone, I would like to understand what are the best practices when developing a business case.Example the Celonis team built for the company I am in todayA single data model for 4 different fronts. They share the same ERP (SAP), but I find it difficult to maintain and develop new cases and tables because of this.Is it ideal to have a Data Model for each business front? Or is this shared model common among other companies?

I see that there can be more than one activity table in a data modelAre there any examples on how to use this feature and the impact when creating variant components or process explorer in the analyses?I have a need for more than one activity table.Just pointing me toward the right document (detailed) or training module is enough for me to understand when and how to use that. Thanks

Access the Order Management demo to answer this question. How many cases are covered by the five most common variants. A. 734,890 B. 988,000 C. 404,562

I need to split the column by a separator in to multiple columns and then unpivot them to rows.

How to upload files in SFTP bucket created during Storage Manager Set up?

One of my project is having CRM data connection and client migrating the source, they are going to store the data in CDP Cloud.I couldn't found anything related to CDP in Celonis documentation.Is there any Prebuilt apps available in Celonis, if not what to do? please help.