General Product Q&A

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

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 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?

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  

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, 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 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

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​ 

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

MasterplanWhile CoEs are the key accelerator to drive success, daily work might drag you too much into process- and technical discussions. In order to drive sustainable Value a CoE should keep an eye on five complementary streams. The following one pager can be used as template for discussing and managing all relevant streams.Hope it helps, keen to get your views

Hi Team -  I am working on developing a business case to develop a business case at my company. I want to show the value and the business benefits exist in developing a CoE. I understand the value and have a vision on what I want to accomplish with a CoE. Does anybody have a business case or presentation I can leverage in developing a business case to our leadership to getting a CoE established? Any other feedback is greatly appreciated.Best,Paresh

Hello, Celopeers! This is my first attempt at what will (hopefully) evolve into a series best-practice forum posts. If you have any questions about anything I share here, please do not hesitate to ask. I also encourage you to follow along with this post, so please log in to the EMS! In my four years here at Celonis, I've asked (and have been asked) many, many questions about our platform and its capabilities. The top 5 questions I've seen (and continue to see) asked are: Can we establish a connection to source system ABC-123? How do we do this? Is there a step-by-step guide?How can we manage access to our team? Is there a step-by-step guide to setting up SSO?Do we have a PQL function that can do XYZ? Are there examples of function input and output?What are our options for editing a specific component in our analysis?What features of the Celonis EMS are currently available? Can you tell us about them? I'm happy to say that the answers to these questions (any many more which

Hi All, While working with multiple systems and Vertical Scenario (where different steps of a process are tracked in different source systems), do we have any documentation/ best practices on how to set up a data model? The training covers the Horizontal scenario in detail but I couldn't find any material for the Vertical scenario.  Any tips/suggestions would be helpful!!

Hi everyone, I would like to know if there are connectors ready to extract data from the Oracle HCM platform. We´re planning to use EMS to map and analyze personnel moves through positions, including transferences, promotions, demotions, etc. Thanks.

Hi everyone, I created a Chart and face the problem that the expression of the KPI does not fit into the tooltip.   Option 1: Is there a setting to change the size of the tooltip box? Option 2: Alternatively I wanted to limit the characters of the variables. Could you help me to insert a LEFT or RIGHT statement? My syntax does not work. <%= MyVariable %> --> Full text is shown<%= LEFT(MyVariable,10) %> --> Only show the left 10 characters

Hi community,  I created a dashboard and would like to use a variable so that the end-user can easily switch between first-to-first // first-to-last occurrences. Could you help me with getting the syntax right. Thank you!

Is it possibile to receive commercial deck and presentation in Italian?

Anbei die heute bei unserem virtual cocktail gezeigten Folien zu CoE