Product Q&A

Dear Celopeers, on September 16th 2021, we are hosting our first Webinar on how to automate with Action Flows!This will be the first part of a new series of Webinars. The first session will coverWhat you can do with Celonis Action Flows (presentation)How to set up your first Action Flow (live training)Where to find further material & trainings (link to resources)Q&A (live) You can directly register here!

I have a global date filter which pretty much is selection between a date period (Eg: - 01/01/2021 - 01/31/2021). This filter applies to my entire analysis when selected. However, I have an OLAP table where the columns are built upon formulas which include the use of DOMAIN_TABLE

Hi All,I am looking for filter condition which can filter out records from activity table once specific activity is first time occurred.Tried with REGEX, PU_FIRST but some how this doesn't work.Is there any one applied same kind of filter condition? Below is what I am expecting:Anything after first event 'Approved' is what I wanted to exclude. 🙂

 How is it posible to use WORKDAY_CALENDAR and WORKDAY_CALENDAR without problems.? I want to use both calendars at the same time. I have use INTERSECT, and i have join both calendars adding the id_calendar to the tables, but i get always the same error. Error in formulaTo use the calendar ID column [constant SP-MAD], it must have a join relationship to the table containing the timestamp column ["IssuesFunes"]. The formula is the following.  REMAP_TIMESTAMPS (   "IssuesFunes"."created" ,    HOURS ,    INTERSECT ( WORKDAY_CALENDAR ("WDCalendar") , WORKDAY_CALENDAR( "WORKDAY_CAL_TFACS" ) ) ,  'SP-MAD')

Quick Tip!  For faster run times, move filters from the where clause into the appropriate inner join. The top example is an optimized version of the bottom code. Let me know if you have any other tips or questions!  

I have an OLAP table that is sorted by # of days (in screenshot named first). But I am trying to produced the same table, but in the format represented in the screenshot labelled as second.  Essentially I want the tables sorted from lowest to highest # of days and also removed the NULL (-) values associated with each client. I have rewritten the queries for each column to support PU functions and was planning to use a DOMAIN_TABLE for this purpose, but when I use the DOMAIN_TABLE within the component filter to remove nulls when ISNULL(...)=1 it still remains the same as first

Can the Celonis EMS authenticate to an On-Prem Active Directory?

Looking for connecting Celonis EMS to DuckCreek Insurance platform... Is there a API library or connector available?

Please mention the way to connect. Is there a connector available ? Can we create a custom connector?

Is there any way to reference a calculate column in a filter inside a component like olap table ? My problem is that when i want for example filter a olap table with activity and %automation than %automation rate was less than 100% i can no filter like  FILTER KPI("Ratio", "_CEL_AP_ACTIVITIES"."USER_TYPE" = 'Automated') > 0  Cause it raise an error saying that a filter can no use aggregate funcion like SUM.  If i can reference a filtre for a calculate colums %Automate = KPI("Ratio", "_CEL_AP_ACTIVITIES"."USER_TYPE" = 'Automated'), and in the filter i can filter by column like   FILTER '%Automate' > 0  Then,¿is is posible to filter data by column ? ¿ How can i do it ?   Thanks in advance 

I have 2 columns in which I am looking to find the difference for. Since some values of each column contain a null they are not reflected accurately for exampleColumn 1 Column2 Diff2 1 14 NULL NULL (should be 4)NULL 5 NULL (should be -5) I have the formulas associated with getting values in Column 1 and Column 2 within saved formulas as "KPI(.......)". My initial idea was to substitute NULL as 0, but when I surround KPI(...) with a CASE WHEN it fails saying that CASE is not supported with INT or STRING Any ideas?

I have a skill that add data table, run ML script that update some other tabls and reload the data modal but updates on other table are not persisted in data modal. My assumption is that action engine do not wait for ML script to complete rather it just start it and move to subsequent steps.  Any thoughts, suggestions on this scenerio ? 

Dear Team,  Please give me an advice about how I can get the timestamp which represents when was the last execution of a specific data job Thanks in advence!Regards, Roman

Please see the screenshot showing sample data, we want to show waste transfer movements which go out of a source storage unit (Movement type 319) to a destination (Movement type 0) and then return. I can make the PU function work well when there is one waste movement however there are many times that the stock is moved out and back, and out and back and I can't make Celonis line up the 2nd out and back movements

Hello everyone, iam wondering if there is any way to sort the entries in a button drop down? i.e. when loading dates, displaying the most recent dates first instead of the oldes dates. Many thanks!

I have a formula stored in a variable that is giving me an accurate result of what I need to get when I check via static value based on a date filter I am putting in. However, when I pull it to my OLAP table it is showing me another value even though the same date filter is applied? Example: 83000 is stored in <%=Var_1%>. When I apply the date filter is changes to 17000 (which is correct), but when I try to store the same value as a KPI in my OLAP table it still shows 83000

Column 1 has values where the KPI is as such for a company 1 (after clicking calculate shares in percentage checkbox):SUM(Days related to certain case numbers)/COUNT(DISTINCT (No. of cases))  Column 2 has values where the KPI is as such for a certain company 2 (after clicking calculate shares in percentage checkbox):SUM(Days related to certain case numbers)/COUNT(DISTINCT (No. of cases))  Column 3 has the difference Based on what I saw the values for column 1 and 2 are read in correctly, but the difference in column three is wrong Any suggestions on this would really be appreciated

I am trying to get the percentage value of the no. of cases in a happy path by dividing by the total no. of cases for that process and display in a single KPI. Any suggestions/formulas on how I can do that?

I followed the SAP Extractor documentation. It is very helpful and detailed. However, there is one thing I noticed isn’t mentioned: While installing the SAP Extractor there is a screen: Configure the Agent UplinkIn there are two fields:App KeyAgent Name These aren’t mentioned in the Docs. Are these specific to my Celonis team or to the SAP installation?

As we know, Process Mining has the tremendous advantage of providing an objective and realistic view on the processes, as opposed to the traditional BPM analysis, which is very dependent on human judgement and prone to bias.However, building a process model from an event log is not a straightforward task. It requires an algorithm, and algorithms are based on assumptions have to somehow deal with things like noise. Conformance checking can also be done in different ways. Therefore, to better understand my results, I would be very interested in learning the algorithms used by Celonis. Thanks!

Hello everyone, the goal for my master thesis is to analyse and simulate different process variations. After identifying weak points, the process should be adapted and a simulation should take place. Is it possible to simulate different process variants in the academic version of celonis?  Thanks in advance!

Example: CASE WHEN YEAR("X"."y") >= 2019 THEN FILTER ROUND_DAY("X"."y") != ROUND_DAY("A"."b") OR ROUND_DAY("X"."y") != ROUND_DAY("M"."n")OR ROUND_DAY("A"."b") != ROUND_DAY("M"."n") ELSE FILTER ROUND_DAY("A"."b") != 2019-01-01 OR ROUND_DAY("M"."n") != 2019-01-01 END Neither CASE WHEN nor IF worked for me. I'm trying in a Component Filter, though a solution on a Sheet level could also solve my problem.

Hello all,I'm looking for a way to search for certain activities without having to show all the variations and then read over them with my eye. An example from P2P process:I search "Delete Purchase Order Item". But I don't know from which variant it becomes visible in the explorer. How can I search/find something like that? 

Based on the example table below:I am getting the values in 'Column_2' by using PU_COUNTHow would I go by converting each value in 'Column_2' to a percentage amount?