Product Q&A

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?

Dear Celonis team,​I am developing views / instruments (analysis) in Studio and I found that I could not transfer my filter selection in one view to another view / instrument and vise versa. ​It is bottleneck of my migration from Process Analytics to Studio, because Process Analytics can transfer filter selection by below screen. Do you plan to do it in Studio / Business View too ? Best regards,Kazuhiko 

According to the documentation the API GET /api/v1/data-push/{poolId}/jobs/  Should return the data jobs contained in the Data Pool And according to the below screenshot the data Job ID should be in the position of the 2nd box in the image attached:   Source: Help resources, section: Data Job Execution API  When we run the API above, it returns Extraction tables, not Data Jobs, and the data in the response has nothing to do with the actual data jobs we have in our team.   Can you please explain what the API above returns? Also, when we try to delete a data job it drops in the database and doesn’t show in the GET requests sent after that. However, this doesn’t reflect in the interface on the system.  Please Advise.     

Hi! I am using the same simple formula to calculate the average throughput time in the OLAP table and in the Gauge Component. OLAP table has dimensions (e.g. Job Family). The case is a Vacancy ID, and there are 2 basic tables in the data model: dimensions table (containing Job Family attribute) and facts table (activity table for the Vacancy status changes) where Vacancy ID is a key. So the data model is pretty simple as well. Could you please help me to figure out why I am constantly getting different results when I am comparing throughput time calculated based on OLAP table selection with the throughput time calculated by a single component (e.g. Gauge or Throughput Time Search)?  Throughout Time formula: TRIMMED_MEAN(CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start'] TO ALL_OCCURRENCE['Process End'], REMAP_TIMESTAMPS("GTO_Application_Workflow_csv"."CHANGE DATE", DAYS)))  This topic can be related to https://www.celopeers.com/s/question/0D50700000GC6p

I would like to compare an attribute (e.g. price) of one activity from e.g. caseID 123 with another activity from the following caseID e.g. 124 - is there any way to solve this problem in Celonis?   

As dimension I have: PU_FIRST("case_table", "activity_table"."activity_time")The KPIs I am plotting/I want to plot are:throughput time: CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start'] TO ALL_OCCURRENCE['Process End'], REMAP_TIMESTAMPS("activity_table"."activity_time", MINUTES))AVG of throughput times as a constant function:If I use here AVG(... throughput time ....), then (not so surprisingly) Celonis computes these for the single cases in the "dimension set", i.e. returns the single throughput times --> is not what we wantclearly the same happens if I set up a variable with text/replacement "AVG(... throughput time ....)" and call this when defining the KPI in the plotif I set up a variable with a static value being the PQL query AVG(... throughput time ....), then I get a constant function, but it does not filter with selections, i. e. the value of the constant function stays the same independent

Hi! I have a use case when a specific field within 1 case can be changed multiple times during the case lifecycle (e.g. fields containing metadata around the Vacancy case). The aim is to figure out what is the influence of specific field changes on the Vacancy throughput time. For this, I am using range buckets calculated based on the number of specific field changes per Vacancy.  I've created 2 tables with buckets: the first table allocates a Vacancy to a range bucket (OLAP table dimension) using PU_COUNT function and the second table does the same using CALC_REWORK function (all formulas are provided below). Then I calculated the # of vacancies in each bucket and the average # of field changes in a bucket (both tables show the same result). Then I am adding throughput time calculation to the tables, and the result is the same at a first glance. But when I hide the column with average # of field changes in a bucket from the second table, throughput time is recalculated. Please, se

Hi, is there a way to add weekdays to a date?E.g. Goods Issue date is on a Fridayand we need to add 2 weekdays (Monday through Friday are weekdays)to the Goods Issue Date, so that we end at a Delivery Day of Tuesday (Friday + 2 weekdays)ADD_DAYS would give us Sunday as output, and ADD_WORKDAYS only works with a workday calendar (needs TFACS table which we do not have)REMAP_TIMESTAMP even with the ADD_DAYS function would bring us to Monday as the next weekday.

I have the following case:A Variable Input component is configured to write to a variable called "Target"AN OLAP table with one of the KPIs calculating the difference in days between the actual throughput time and the "Target" inputThe formula I am using is: TRIMMED_MEAN(CALC_THROUGHPUT(CASE_START TO CASE_END, REMAP_TIMESTAMPS(""."", DAYS)), 5, 5) - <%=Target%>)However, the table output will fail if the user wipes out the value from the Variable Input component (which for sure can be the case).  I've tried with different operators to handle CASE WHEN the variable is empty (blank): IS NULL, != '', !="" - it's not working (e.g.  CASE WHEN <%=Target%> IS NOT NULLTHEN(TRIMMED_MEAN(CALC_THROUGHPUT(CASE_START TO CASE_END, REMAP_TIMESTAMPS("GTO_Application_Workflow_csv"."CHANGE DATE", DAYS)), 5, 5)- <%=Target%>)ELSE NULLEND) The only solution I was able to found in documentations deals with

It seems that date picker filter is not applicated in the same way for:the KPI in the high side of the sheet (Sales Order Items value and Number)the KPI in the table that shows year by year Sales Order Items value and Numberthe values (Sales Order Items value and Number) for a specific customer if we add also this filterBecause for some customers each of them shows different values ..

Hi,We have Excel files with few columns are always/sometimes blank. When we try to upload the excel, Celonis automatically identify and select the datatype for each column based on the first x records . Even though column has null values Celonis considered them as INT and then during the data model load this gets failed. We have many columns and manually checking data type for each column is very time taking. Is there any solution to this?

Hi, I am trying to filter the data using CASE WHEN statement in the component filter section but it is not working.Scenario: when DATE_1 is not NULL then show data only till yesterday using DATE_1 (DATE_1 < TODAY()) else show data till yesterday using DATE_2 (DATE_2 < TODAY()). This works file if I execute single statement like FILTER DATE_1 < TODAY() but it is not working when I combine into CASE WHEN like below: FILTER CASE WHEN ISNULL(DATE_1)=0 THEN DATE_1 < TODAY() ELSE DATE_2 < TODAY(); Any help is really appreciated. Note: We are using Celonis on-prem 4.5

Can we add comments against activities to cite the reason as to why the activity occurred? If so how to do it?

Hi everyone, we have a lot of use cases and dashboards created on our CPM that we updated to 4.6 and we want to migrate our analysis from CPM to the IBC. Before the update from 4.5 to 4.6 we used a python script with pycelonis to transfer the analysis. After the update the script is not working anymore. Is there a specific adjustment to the script or is there any other way to transfer the analysis?

Hi There, I am trying to Filter on component level. The filter has two parts and looks like this: 1.Filter : Filter all cases, which contain only activities, which does NOT match user_type = A FILTER PU_COUNT ("AP_VIM_CASES" , "_CEL_AP_ACTIVITIES"."_CASE_

Hi Guys,we wanted to use PU_LAST filter condition with Max function, can you help here.