Data Ingestion & Infrastructure

Hi all, I have a small problem with the calculation of the minimum variants depending on the company codes. My goal is to display the minimum number of variants as KPI. With my formula the number differs significantly compared to the KPI("Number of process variants") function. I think I need to add a distinct, but I don't know how exactly to do it.  Here is my code: MIN(  PU_COUNT(    DOMAIN_TABLE("VBAP"."BUKRS"),    (      SHORTENED(        VARIANT("_CEL_O2C_ACTIVITIES"."ACTIVITY_EN")      )    )  )) Kind regards Ilker

Hey, does anyone know, if - and if yes, how - it is possible to implement a subselect within an OLAP table in Process Analytics?Basically, we would like to build an OLAP table, where one column is being queried with input from another column from the same table. Specifically, we want to display EKKO.EBELN, EKKO.KONNR and EKKO.EKGRP, where the EKKO.EKGRP being displayed is not the EKGRP from the corresponding row, but from a different row, where EKKO.KONNR (from this row) = EKKO.EBELN.  In SQL, it would look like this: SELECT ebeln, konnr, (SELECT ekgrp from ekko WHERE ebeln = konnr) FROM ekko  

Dear Experts Does anyone know if Celonis OP system or the IBC Hybrid deployment supports Oracle database? Is there any customer references? Thanks!

Mass Transaction Qualifier - We are currently trying to configure the mass transaction functionality. I am curious how others have coded this. Today it appears that it simply qualifies all activities done by a SAP user within 10 seconds (we can config the amt of time 10 seconds was recommended to start). All of these activities are classified as a mass transaction and they are all coded as user type "R" (again I believe this is the standard).  However, when you look at the actual business process and execution many if not all of these mass transactions are initiated by a manual user performing at least one of the steps.  Example: in P2P user marks "delivery complete' which triggers second activity automatically of set "final invoice indicator' in SAP even though user name is the same for both activities. Currently Celonis calls both of these activities "R" whereas we would like the initial activity to show as "A" because a user perf

Hello, I want to create a variable that defines Area_of_Business. it would be a combination of the Department and Type of the Business. It is not a problem to create the variable but rather to integrate it into the graphs and diagrams as I cant use "CEL_CASES"."AREA"=Variable (dont have a column called "AREA") or "CEL_CASES"."DEPARTMENT"=Variable or "CEL_CASES"."TYPE_OF_BUSINESS" =Variable in the quiry. Any ideas how to implement it? Best,Maria

Please see error message:Data model load failed during table export: Data model tables: Quote_Header_xlsx_Quote_Header, Customer_xlsx_Customer contain more rows than the allowed maximum per table of 0. Please reduce the number of rows. Both tables are not bigger as the case table, so I cannot understand why the number of rows should be an issue.

Hi everyone, i am trying to create cathegories for my pie chart. The categories would describe the Value of the "Case" based on payments (can be NULL) and the rest of the reserves 8also can be NULL) for the Case. I have started with the following description of the Categories:(CASE WHEN (  ("CEL_SHUK_CASES"."ZAHLUNGEN" + "CEL_SHUK_CASES"."RESTRESERVEN")>=0 AND ("CEL_SHUK_CASES"."ZAHLUNGEN" + "CEL_SHUK_CASES"."RESTRESERVEN") <1000  OR   (("CEL_SHUK_CASES"."ZAHLUNGEN") IS NULL AND ("CEL_SHUK_CASES"."RESTRESERVEN")>=0 AND ("CEL_SHUK_CASES"."RESTRESERVEN")<1000)  OR   (("CEL_SHUK_CASES"."RESTRESERVEN") IS NULL AND ("CEL_SHUK_CASES"."ZAHLUNGEN")>=0 AND ("CEL_SHUK_CASES"."ZAHLUNGEN")<1000)  OR   (("CEL_SHUK_CASES"."RESTRESERVEN") IS NULL AND (&quot

Hi, I want to calculate the throughput time between a certain activity and "now"; ideally speaking I'd like to do a query like this one that is forbidden: CALC_THROUGHPUT(FIRST_OCCURRENCE['activity name'] TO TODAY(), REMAP_TIMESTAMPS("ACTIVITIES"."ACTIVITY_START", DAYS)) How can I resolve this? Thanks a lot

Hi guys, We are trying to connect Ariba with Celonis IBC to extract Supplier Contracts related data. Now we were able to test connection successfully, but while creating the data extraction task we are not able to see any tables to extract.

Hello Community, I am a new member, learning Celonis. while doing the exercises(I am following a PDF document) I got the following error when trying to apply filter on join table. Error parsing filter: CDHDR.UDATE >= 01.06.2014 caused by: Lexical error at line 1, column 16. Encountered: \\u2018 (8216), after : The following is the statment i gave: CDHDR.UDATE >= 01.06.2014 Could anyone please help me to rectify this. Thank you, Malini

Hi,I am looking for a PQL code to solve the following.We have data for multiple dimension over a period of time. I would like to get the data aggregated on one dimension per month.All the data is within one table.|Dim1|Dim2|Dim3| Month | KPI ||----|-----|-----|------|---|| A    | X1   | Y1   | Jan-21 | 300 || A    | X2   | Y2   | Jan-21 | 200 || A    | X3   | Y3   | Jan-21 | 400 || A    | X1   | Y1   | Feb-21 | 200 || A    | X2   | Y2   | Feb-21 | 100 || A    | X3   | Y3   | Feb-21 | 500 || B    | X1   | Y1   | Jan-21 | 300 || B    | X2   | Y2   | Jan-21 | 200 || B    | X3   | Y3   | Jan-21 | 400 || B    | X1   | Y1   | Feb-21 | 200 || B    | X2   | Y2   | Feb-21 | 300 || B    | X3   | Y3   | Feb-21 | 500 | What I would like to get is.jan-21feb-21diff.A900800-100B900100200 I have been trying with the domain table and PU functions but I was not able to make it work.Thank you

Hello community, I have a question regarding on-prem Celonis extractors. When you say extractors are they similar to the data base connections as shown below. Or does this apply to something different? If so, what is the difference? Thanks, Anna

WELCOME to our new TASK MINING discussion group. @andreas.plien11​ , our Celonis Senior Product Manager and the community is here the answer questions and share best practices.

Hi Celopeers, We will run three PQL-related sessions at Celosphere 2021: Thu Apr 15, 9:25 AM - 9:50 AM GMT +2   (25 Min)PQL: Become a PQL Power User with a New Assistive Editor Thu Apr 15, 9:25 AM - 9:50 AM GMT +2   (25 Min)Performance: Learn How to Optimize KPI Calculations to Scale Thu Apr 15, 9:25 AM - 9:50 AM GMT +2   (25 Min)Multi-Event Log: Analyze Multiple Integrated Processes in a Single View Sign up here! 

Did you know that the Celonis Process Query Language (PQL) turned 5 in February?

Is there any way to get the value of text components or variables defined inside process analytics sheet from machine learning script.Similar action for OLAP table is possible as mentioned in the below documentation:https://celonis.github.io/pycelonis/notebooks/01_Pulling_data.htmlHow can we perform the same for text components or variables?

My activity table is having three columns ACTIVITY_EN, CHNAGED_FROM, and CHANGED_TO. Now I want to filter all cases which are ever passed through the Cancelled value in CHANGED_TO or CHANGED_FROM column. How can I filter these cases?

Hello everybody,I have the following problem. I hope you can help.I would like to use the component filter to hide the documents that have a clearing document.I have no idea for the formula.When I FILTER BSEG. AUGBL = then it only deletes the line for me, but not the entire receipt.Was a formula turned into a formula?Do I have to take GJAHR into account with the formula? Because the document in 2021 does not yet have a clearing document and should not be deleted.image779124 2.89 KBGREETINGS

Hi, I want to select SUM of the top 3 cases based on their count in the single component KPI.I am using the INDEX_ORDER function to get index of each row, but when I apply the filter on analysis the count doesnt get changed. I assume it INDEX_ORDER is performing static in nature. How can I make it to dynamic. RegardsMukesh

I want to create a dashboard where user can input the data and on clicking the submit button the input provoded by user should go to machine learning script where the values are being used in the code.Is this possible with celonis? Please provide any documentation/code related to it.

Hi everyone,for our development data model we would like to dive into our top X (e.g. 100) of open development projects in regards to their expected value. Currently I only know the function for an OLAP-table to show a limit number of rows. If we filter on certain areas/regions/plants this option remains, always showing the top X for the current selection. But we need additionaly KPIs above the table as:Total expected value of the top X projectsCertain Process-KPIs like (Average development loops per project) etc.Now Im searching, if there is any functionality to put a component filter or sheet-filter that we respect only the top X projects of the current selection.This might be interesting for everyone who wants to have a look/comparison within their top X cases.Best regards,David

Hello community,I am trying to build a table that will have a ranking of company codes. I use Celonis 4.5 on-prem. The company codes are my dimension. This ranking is based on the below KPI logic:CASE WHENMAX(WORKDAYS_BETWEEN(R2R.Tables::BSEG_KDAS.CAL_ID, R2R.Tables::BSEG_KDAS.LAST_DAY_OF_MONTH,(PU_MAX( DOMAIN_TABLE (R2R.Tables::BSEG_KDAS.ENTRY_DATE,R2R.Tables::BSEG_KDAS."_CASE_KEY"),R2R.Tables::BSEG_KDAS.ENTRY_DATE)))) = 3THEN 1WHENMAX(WORKDAYS_BETWEEN(R2R.Tables::BSEG_KDAS.CAL_ID, R2R.Tables::BSEG_KDAS.LAST_DAY_OF_MONTH,(PU_MAX( DOMAIN_TABLE (R2R.Tables::BSEG_KDAS.ENTRY_DATE,R2R.Tables::BSEG_KDAS."_CASE_KEY"),R2R.Tables::BSEG_KDAS.ENTRY_DATE)))) = 4THEN 2ELSE NULLENDthe above statement works as expected, however i need to include another variable where it also checks for the time stamp.I have tried the below statement, however am receiving an error message saying An aggregation is not a function.Can you please suggest a solution that incorporates both the max day

Hi, I am using a combination of Import from Database for the Cases & Activities tables with Import from File third file (an Excel file with a primary key connecting to the Cases table). This works perfectly, as expected. However, after a couple of hours, all my Variant & Process Explorers stop working with the following error: Undefined exception occurred. Could not open swap file: 7e2f96 Clicking Reload from Cache in the data model resolves this, and the dashboard works again perfectly. But in another few hours, it breaks again with the same error. Im wondering what could be causing this error, and it its perhaps a known issue when using Import from File from Excel? It doesnt make any sense to me that it would work, then stop working with an undefined error, then start working again when the cache is refreshed (since the data doesnt change). Any advice is appreciated Thank you, Matthew

Dear all, We currently face an issue creating the data model for SAP SRM. We want to analyse the approval workflow for shopping carts in SAP SRM. Using tables like: CRMD_ORDERADM_H /SAPSRM/D_WF_000 /SAPSRM/D_WF_003 /SAPSRM/D_WF_008 /SAPSRM/D_WF_013 We currently cannot determine the right timestamp for each approval step. Therefore my question if somebody already implemented that topic to Celonis and wants to share the experience with the data model for SAP SRM. Thank you Matthias

Hi all, I want to have a dropdown button with the values 0 to 12, which I can generate using RANGE(0, 1, 12) however when I run/use the dropdown button it does not show any items. Is this supposed to work? (were running CPM 4.5) Kind regards, Joos