Product Q&A

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?

Hello everyone, I wonder that when I create a skill with Manual Sensor, can i schedule trigger of this skill ? For example I want to trigger this skill once in a month automatically . If I can't is there any differenw way to do that Thank you 

Hi everyone!I have a doubt about a calculation related to the duration between activities. Normally the CALC THROUGHPUT formula is used to calculate durations between 2 activities. However, I need to calculate the duration between more than 2 activities in a single KPI (e.g. the duration between activities A and B to activity C, or from A and B to C and D), but I can't get the formula.  I already have tried the following formula to calculare the duration between activities 'A' and 'C' to 'B' AVG (CASEWHEN PROCESS EQUALS 'A' TO ANY TO 'B' THEN CALC_THROUGHPUT(FIRST_OCCURRENCE['A'] TO LAST_OCCURRENCE['B'],  REMAP_TIMESTAMPS("activity_table"."timestamp"))  WHEN PROCESS EQUALS 'C' TO ANY TO 'B' THEN CALC_THROUGHPUT(FIRST_OCCURRENCE['C'] TO LAST_OCCURRENCE['B'],  REMAP_TIMESTAMPS("activity_table"."timestamp", HOURS)) ELSE 0 END )  Can you help me?  Thank you v

I use a manual sensor to reopen tasks in Views. Right now I try to create a solution that would reopen tasks based on the Smart Sensor.  In order to do so, I duplicated the Manual skill and changed the trigger from Manual to Smart sensor choosing the same Knowledge Model and Record Identifier and applying PQL filters. The skill preview shows a number of tasks as I would expect.  The issue I have is that at Get Task stage there is no identifier passed and the skill cannot get reopen even though I use the same identifier as I use with skill created as Manual Sensor.  

Is it possible to use SQL Procedure in data transformations? If not, is it on the roadmap? Thanks!

I tried something along the line of( PU_COUNT(target_table, source_table.column))/SUM(PU_COUNT(target_table, source_table.column)) But I got an error saying:"The aggregation function SUM cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs"

Hello.I'm currently testing the ServiceNow Connector for IT Service Management - Incident Management. Unfortunately, the model cannot be loaded: Data model load failed during table export: Data model tables: _CEL_INC_ACTIVITIES, sys_user_group, BACKLOG, incident contain more rows than the allowed maximum per table of 0. Please reduce the number of rows. The data jobs ran errorless.Any idea what is wrong?Best regards,Heiko

Hi!! I'm interested in filtering an activity out of an analysis. When I try to filter out the activity from the attribute selection, the activity still shows in the Process Explorer. Is there a way to do a crop selection type filter in the load script?

Hi, We have installed Extractor for JDBC connection for Oracle inside Oracle Data base Server, oracle DB server installed in a Physical server, during connection test with uplink connector we are getting below error. 2021-07-12 14:31:32.680 INFO [,,,] 30305 --- [uplink-thread-0] c.celonis.uplink.manager.UplinkManager  : Uplink could not connect: 'I/O error on POST request for "https://tcscboprod.us-2.celonis.cloud/uplink/api/public/uplink": Read timed out; nested exception is java.net.SocketTimeoutException: Read timed out', waiting 3000ms before retrying --EOM-- We have enabled the port & IP for source and IBC Please suggest for possible solution to resolve the above error

Hi!I have a doubt about a calculation related to the duration between activities. Normally the CALC THROUGHPUT formula is used to calculate durations between 2 activities.However, I need to calculate the duration between more than 2 activities in a single KPI (e.g. the duration between activities A and B to activity C, or from A and B to C and D), but I can't get the formula. I already have tried the following formula to calculare the duration between activities 'A' and 'C' to 'B' AVG (CASEWHEN PROCESS EQUALS 'A' TO ANY TO 'B' THEN CALC_THROUGHPUT(FIRST_OCCURRENCE['A'] TO LAST_OCCURRENCE['B'],  REMAP_TIMESTAMPS("activity_table"."timestamp"))  WHEN PROCESS EQUALS 'C' TO ANY TO 'B' THEN CALC_THROUGHPUT(FIRST_OCCURRENCE['C'] TO LAST_OCCURRENCE['B'],  REMAP_TIMESTAMPS("activity_table"."timestamp", HOURS)) ELSE 0 END )  Can you help me? Thank you very much!!

When user click on this single number KPI it should lead to another tab?