General Product Q&A

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

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.

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.

How to uninstall Celonis agent without leaving data

We are trying to only display invoices that are currently in verification and then calculate how long its been in verification for, but we cant find a suitable function for it.  Any help would be greatly appreciated

Is ROUND_MONTH("PurchLines"."CREATEDON_MST") the norm to use when creating trend analysis (Chart)? I am getting unexpected results when I use that as a dimension when I am just trying to determine the number of Open PO's by month.

Why, in Industry Wheels Charts, some processes are in bold and others no? What does it mean? Thanks

Hello.I was wondering, is the ability to set alerts from SmartSensor no longer available?The official site has a screenshot of SmartSensor with the CreateAlert option, but the option does not exist on the actual EMS. https://docs.celonis.com/en/create-alerts.html