Data Ingestion & Infrastructure

Was just curious that can we dynamically mention threshold value in color mapping? instead of mentioning static number. Just like in this image

Dear Community,  does anyone have any idea on how to create a chart in a view with running sum logic, that means for: January 24: i would like to display the sum of purchase order value of the last 12 months from Jan 23 till end December 23 February 24: the sum of purchase order value (for example) from February 23 till end january 24 March 24: the sum of purchase order value ((for example) from March 23 till end February 24 and so on for the coming months. I can imagine that i have to build the logic in the KPI itself. Furthermore, i would like also to create a chart in a view with YTD Logic: January 24: Data, like purchase order value, just from January 24February 24: Sum of purchase order value of January & February 24March 24: Sum of purchase order value of January & February & March 24...... Thank you so much!

Access the Order Management demo to answer this question. What are the top three late delivery root causes by case occurrence for customer Wallenquist Organization 11746?

I have a customer who also uses celonis. We would like to push them tables from our instance into theirs. Of course we could also make the raw tables available and they could extract them directly. But was assuming there was also a capability to share a data pool externally from my instance. Is that a possibility? I could not find any documentation on this...

Example: KPI_A: 0% (weight 1)KPI_B: 90% (weight 2)KPI_C: NULL (weight 1)-> Expected outcome: 60% (2*0,9+1*0)/3 KPI_A: 0% (weight 1)KPI_B: 90% (weight 2)KPI_C: 0%(weight 1)-> Expected outcome: 45% However all I came up with is:((KPI_A*1)+(KP_B*2)+(KPI_C*1))/4 which is resulting in NULL if any of the KPIs is NULL. I could sove is using extensive nested CASE WHENs catching every possible combination but that seems quite cumbersome and hard to read/maintain. Does anyone have a better appraoch or PQL function I am missing? 

Hello all, I would like to compare how certain attributes of selected cases compare to the overall share of cases with that attribute. For example:All cases have a certain color. I would like to know what is the share of each color for my selected cases compared to the share of that color for all cases. The result should look like (simplified):Color | Selected Cases | All Cases | Differencered | 15% | 30% | -15%green| 85% | 70% | 15% Therefore I created a OLAP table with the dimension "color" and the following KPIs: The KPI for my selected cases is:(COUNT ( DISTINCT "table"."case_id" ) / GLOBAL(COUNT ( DISTINCT "table"."case_id" )))-> works fine For all cases the KPI is:PU_COUNT_DISTINCT (DOMAIN_TABLE ("table"."color"), "table"."case_id") /PU_COUNT_DISTINCT ( CONSTANT(), "table"."case_id")-> which also w

I have a process with mulitple QUEUED per caseI want to find the last QUEUED, and find the first 'INPROG' directly after the last QUEUED.There could be many INPROG, so I don't need the LAST_OCCURENCE() - which does workIs there a NEXT() row kind of option? I tried this, but is not allowed AVG ( CALC_THROUGHPUT (  LAST_OCCURRENCE [ 'QUEUED'] # event X  TO  LAST_OCCURRENCE ['INPROG'], # I want the first event after X, not the last in prog, but the first INPROG after LAST QUEUED  REMAP_TIMESTAMPS ( "eventlog"."timestamp" , MINUTES ) )) Tried also with ACTIVITY_LEAD but that is also not possible AVG ( CALC_THROUGHPUT (  LAST_OCCURRENCE [ 'QUEUED']  TO  ACTIVITY_LEAD ( "eventlog"."timestamp",1),  REMAP_TIMESTAMPS ( "eventlog"."timestamp" , MINUTES ) )) Is there a option to calculate this formula and show it in a KPI Olap table? 

Could you please suggest learnings for PQL beginners? I need to learn more about it.

Is it possible to dynamically make an OLAP table component column visible / invisible based on a variable? Also, is it possible to make a KPI component visible/invisible based on the same variable?The objective is to use one Analysis but limit certain data from being displayed for different end-customers? I know I can filter component by the customer name but I haven't found any mention in the ONLINE HELP on dynamic visibility of components.

We have a problem where we are using a case when statement to derive columns with aggregated buckets. When we try and group the buckets into case numbers, it groups the entire count of case numbers into a single bucket. Rather than splitting the data into multiple different buckets. CODE USED------------------CASE WHENSUM (  CASE  WHEN "TABLE"."ABC"='A' AND ACTIVITY_LEAD (CASE  WHEN ("TABLE"."ABC" IN ('B')) THEN "TABLE"."ABC" ELSE NULL END) IS NULL THEN 1 ELSE 0  END ) between 1 and 5 then '1 TO 5' ELSE '6+' END

Hi there,is there any statement to count the occurances of a process pattern within a single case?e.g. set price block - change price - remove price block occurs 3 times for case #123Potential Use Case:How often is a price block removed without a price change.So far I can only count the cases for which this pattern occurs at least once (PROCESS EQUALS/MATCH_PROCESS) but not how often.Very thankful for some advice!Best regardsManoah Rudisile

I created an action flow which gets data from the data model and creates a pdf file every day. In the second step it sends the pdf to my email adress. Once in a while the data load doesn't succeed. So the pdf send by the action flow is not up-to-date (data is from the day before). I tried to put a router in between and have two email options. One for the pdf and one with an error message. As a filter I used "now earlier than addHours( timestamp ; 24 )". How could I get the time of the last data load as "timestamp" in this filter?Thank you so much!

The following questions contain hands-on exercises that require a personal EMS Training Environment, also called an "EMS Team". Please go to Studio and create a new analysis based on the data_EN”. Add a variant explorer to

Hello all, I have a dropdown for choosing a time dimension (day, week, year etc.). My charts change with changing this dimension so I can see my data on a more or less aggregated base. The only thing I struggle with is the conditional formatting of the dimension. I tried with setting a second variable as the target formatting but dont know how to insert this variable in the formatting field of my chart dimension. How can I do this? Thanks in advance!

Hi,is there a way to combine a PU Function with a CALC_CROP Function? CASE WHEN PROCESS # 'Change Requested Delivery Date' THENTO_TIMESTAMP ( PU_FIRST ( "VBAP" , "_CEL_O2C_ACTIVITIES"."CHANGED_TO" , "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" = 'Change Confirmed Delivery Date'), 'YYYYMMDD' )ELSE"VBEP"."EDATU"END This is the formula without CALC_CROP. But doing this, Celonis is looking at the first "Change Confirmed Delivery Date".I would like to look at the first "Change Confirmed Delivery Date" Event after the last "Change Requested Delivery Date" Event.

Hi,I'm extracting data from SAP ECC, but when I try to pseudonymize fields from tables I receive an error of aborted operation from SAP system, with log "Error: Error during Hash calculation for value 100"Someone please know why? Thank you!

Is there a possibility of collating data from different data pools so that a dashboard can be built for task mining which will then enable us to see how many users have installed task mining and analyze the captured data which is residing in separate data pools for each teams?

I have two data pools.(A) One data pool extracts P2P data from an SAP system. This connection is shared.(B) The other data pool uses the first data pool as a connection. The tables are synchronized. After extracting the table EINE in A, it is not automatically updated in B (see screenshots).The documentation states that it should be done automatically "If new rows are added to the tables and views of the exported Data Connection, the data will be available automatically in the importing Data Pools" https://docs.celonis.com/en/transfer-data-between-data-pools.htmlIt seems that there is a routine which updates the table in B at a certain moment. But I do not know how to control/trigger this.

Hi,we would like to connect our Jira project to Celonis with API.  we couldn't find a standard connector so we've created a New Extractor with Extractor Builder using REST APIs calls. For autentication we used API token as specified in the documentation. The connetion tests run succesfully but, when we try to Build the response we have this error message:"Cannot get samples from source system: Unable to read the response"  Can anyone help us to solve the problem ? Thanks for you time.Giulia 

I am trying to use uplink connection to create the connection between celonis platform with MSSQL database, but it's failed, can anyone help? thanks a lot!

Hallo together,I like to select a dataset(date) within an App via dropdown. However the dropdown always sorts ascending. Is there any posibility to have earliest days on top?So like:2024-02-272024-02-262024-02-25...2018-01-01 instead of  2018-01-012018-01-02...2024-02-27  

Hello team Is there any way to fetch user login history to data pool?  Thanks In Advance  Regards,Ankit Chatterjee

Filter on the most common variant #3 and #4. Make sure the two variants are superimposed on top of each other. Looking at the Process Start and Process End dotted lines, which of the below statements are accurate? Select TWO options.

answer

We are currently migrating to Celonis EMS, however we are experiencing an issue with the Impala connector. Celonis creates queries such as  Select * from "schema"."table" where Impala interprets " as string delimiter. Other tools that are talking to our Impala database, including Celonis on-premise, do not have this issue. Does anyone know how to configure the Celonis Impala data connection to change this? Many thanks in advance! Joos Buijs - APG