General Product Q&A

I'm trying to add a filter to a table so I can do something similar to the search function for numeric dimensions (where I can select to filter greater than x). I haven't been able to code the filter. I want to be able to filter by Total or/and Total Canceladas >= x -NOM_SOLI: "CL_Auto_Autorizaciones"."NOM_SOLI" -Total: COUNT_TABLE("CL_Auto_Autorizaciones") -Total Canceladas: COUNT(DISTINCTCASE WHEN PROCESS EQUALS 'Cancelada' THEN "CL_Auto_Autorizaciones"."_CASE_KEY"ELSE NULLEND) -Porcentaje Canceladas: COUNT(DISTINCTCASE WHEN PROCESS EQUALS 'Cancelada' THEN "CL_Auto_Autorizaciones"."_CASE_KEY"ELSE NULLEND)/ COUNT_TABLE("CL_Auto_Autorizaciones") "CL_Auto_Autorizaciones" is the case table

Hi all, I would to show my 2 bar graph with the same time span, like next 12 month visible without moving scroll bar, even it doesn't have any data of a month. Where can I find the setting? or Can't I in celonis?

Where can I find all the reading material (ppts, pdfs) and templates provided by Celonis ?

Recently we decided to activate the SCIM functionality in Celonis so that user and groupsare provisioned automatically by the identity provider. Unfortunately it is not working and no connection to the Active Directory can be established and the functionality is not working. Are there any specific settings that need to be set in the Active Directory so that SCIM API can work as intendet?

How to schedule an action flow to trigger on a particular day? we are not using knowledge model.

This is how is set in the documentation:  and this is how I set the module: 

Team, I am using Content CLI to Pull and Push assets between different EMS. Is there a way to overwrite only one asset when pushing to a different EMS? I can see there is an option to overwrite packages with "--overwrite", but we want to push only one asset multiple times. Best regards!

Hi, i want to create in Open Order View (Open Order Processing) a Dropdown List where i can select a ORDER_ITEM Record which sets the X-Axis on a Graph. My problem is that it doesnt accept the variable as an axis, but if i use the record itself it works

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. 

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