Product Q&A

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. 

Data-model is not working for task mining. The activity log is appearing in Data models, but when I create analysis based out of data model, I am getting 'No Process is Configured'. Anyone, Any thoughts?

Hello, I am looking for something similar to a lookup function in Celonis. Is it something possible? I have a child table "X" linked to Parent table "A" another child table "Y" linked to same parent table "A". Both links are based on different keys. I want to lookup a value from X to Y is it something possible as in is there PQL formula which could help me do that? Thanks.

I have been trying to carry out the data engineer course and in when doing the "Access Source System" step in the Process Connection basics, it tells me to go onto the event collection page and create a data pool. However, an error appears in the bottom left corner as shown below  

We are trying to connect to SAP ECC using uplink connector, post Test Connection got successfull, tried to create Data Job and trying to load tables but not moving ahead from log "Job not yet started in SAP. Current status: SCHEDULED", so it could be issue in SAP RFC module, unable to understand the issue please suggest.

I have currently one data pool where I have 3 Data models. I want to use data in O2C and P2P together. How do I make it possible. please see both data models attached. Is there any additional information that you might need? I want to be able to use data in VTTK/VTTP tables together with P2P.

HI, I have embarked on learning the usage of MERGE_EVENTLOG in Celonis Snap environment. I cannot set two tables as Activity Table at the same time, making it unable to go further investigation.How could you set several tables as Activity Table (and Case Table as well) at the same time?

Hi team,How to extend the result rows for more than 100 or to export the transformation query result to excel?If not from transformation, is it possible to do it via Machine Learning workspace? Is it allowed?Thank you

Hi, I would like to know what I have to put on the "realm" box when installing a connector from the EMS to connect to an APP. Thanks

Hi all. We have created 6 activity tables, and allowed the data model to create a merged activity table. When I add the Case explorer component, it isn't using the merged activity table, but defaulting to one of the 6 we've created. Also, for the conformance component, I've allowed celonis to mine, and this too is defaulting to the same activity table. Do any of you know how to get these two components to use the merged activity table?

Hi Community, I would like to align my text vertically. Is there a way to do this in the BB code function. I am using Celonis 4.5 Thanks, Anna

Do you have a tips how I can create the sorting numbers? Do I have to create the sorting number while i running the procedures to create the event log entries afterwards when the event log is created? But I don't know how to define the sorting number with SQL.

Hello All, I have a csv file (attached a screenshot of the same) which has the Case ID (column A), Activity (Column N) and the Timestamp (column O) in the correct format. There are also other columns in the file that I will be using for my analysis. The error (screenshot attached) says that there are more than 100 empty cells within the Acitivity, Timestamp and CaseID columns but I have double-checked and can confirm that, that is not the case. Has anyone experienced this before? What could be the issue over here?  This is an urgent matter so any quick responses would be much appreciated! Thanks!@1460045682​ ,@joos.buijs​ , @hugo.victo11​ 

Best 20% and worst 20 % Cases based on their duration Hi everyone, we are looking for a solution to the following problem. We would like to get the best 20% and worst 20% of the Cases based on their duration, including all cases that fall between the scope, e.g. in a pie chart.So we could filter on the specific cases that are in the defined scope and as an output we would like so see them individually (with Case Key and their specific duration) in an OLAP table. Does anyone know what formula to use to get the relationship to each other?

Hello everyone, Can someone please share details of week one courses?

Does anyone know how can you remove disk space (hence reduce APC consumption) removing specific rows from a table? I would need to remove permanently rows from a table based on a specific sub-query. I have limited space available so i cannot use operations that require, even for a small period of time, twice increase in space occupation Thanks in advance