Product Q&A

Hi,Id like to create a component filter to filter a dashboard sheet and its KPIs for a Subprocess.E.g. our KPI Touchless Order Rate should only be calculated for the subprocess process start to create delivery.I can get the right result, if I use the crop selection but I want to have this as a component filter.Can anyone help me with the right PQL filter formula?Thanks ,Carina

Hi, i am trying to connect to a Postgres Datasource via jdbc. It is not possible do get a connection. I always get the information unable to connect. With our Hana Source everything is working fine. Any advice? Beneditk T.

Hi Team,I have a rather complex OLAP table that I am looking to build and need your help. Its a two step issue that I am hoping that someone has some guidance.Part 1.We have a table in the back end that contains pmt term information. We have ranked the payments terms from 1 best to 30 worst. I have also created a drop down variable for the user to be able to select 1, 2, or 3.Essential, what i need to happen is, based on the current payment term that we have for the invoice, if a user selects 1, in the variable, then the next best pmt term will be populated in that column. if they select 2, then it would skip to the 2nd better pmt term that is on that list. so on and so on.image697258 7.47 KBCan you please advise if you can help me solve this issue.Part 2:Given that the first part can be done.The next part would be to calculate the days difference between the net due date of the original pmt term and the new payment term net due date. The original payment net due date we already pull i

Hi, is there a possibility to show the last load date of a process model in the analysis? Reason: The viewer should know when the last load of the process model took place. Thank you in advance Steffen

Dear Colleagues,I have a problem: I am calculating days with CALC_THROUGHPUT function. For some events I need to use LIKE function. But As I see, it is not possible to use one, only in func. FILTER or CASE WHEN. But How to apply event in CALC_THROUGHPUT when you need to cut a part of name?For example.AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[Event1]TO LAST_OCCURRENCE[Event2:%],REMAP_TIMESTAMPS(EVENTS_EVENT.EVENT_DATE, DAYS)))Or maybe it can be done by another function of Celonis.Thanks

Dear community, I would like to create an OLAP table to calculate throughputs from Process Start to"Process End" of each client. My data model is single eventlog, Case_table, which consists of Process group, Activity, Time stamp, and Client. Every records of case table have client name( client1 - 4) in client column. I tried to make OLAP table like this. DIMENSIONS (1)Cient: CASE WHEN Case_table.Client = Client1 THEN Client-01 WHEN Case_table.Client = Client2 THEN Client-02 WHEN Case_table.Client = Client3 THEN Client-03 WHEN Case_table.Client = Client4 THEN Client-04 ELSE END KPIS (1)Throughput: AVG(CALC_THROUGHPUT(CASE_START TO CASE_END, REMAP_TIMESTAMPS(Case_table.Time stamp, Seconds))) It looked working, but the result was wired. The throughput of each client is higher than average throughput. When I delete dimension, OLAP table shows average troughput lower than each clients throughput. Does anyone know how to solve this problem? Thank you for your support. Sugano

Hi Celonis Team, Do we have an option to calculate the approximate time to be taken before extracting data from external sources /tables ? It will help us to plan the time accordingly and if needed, to skip the mammoth data and continue with rest OR schedule specific tables extraction during non-working hours. Attached example: DD03M takes a day to complete the extraction. Log file21191080 151 KB

Dear community, I would like to create an OLAP table which counts cases with/ without specific activities. In this case, Id like to count cases which through both Confirm Reservation and Sell Ticket. tickets_log524644 11.8 KB Id like to get the result like this. Confirm Reservation (Booking Number) : 1 Confirm Reservation (QR Code) : 2 Else : 2 *D-004 is treated as Else because D-004 passed though only Confirm Reservation The name of activity is different from my raw data, so please dont use wildcard like "Confirm Reservation" If I could, Id like to show the result as pie chart. Thank you for your support. Sugano

For a throughput time prediction I have to get the next-to-last activity (the last activity is a running one). How can I do that? I thought about doing it in the data transformation with python but Id rather use Celonis directly.

Hi, I have a table that can either show Volumes or Ratios of Sales Orders fulfilling a particular criteria. I have a drop-down which allows the user to select Volume or Ratio and the numbers in the table update accordingly. The issue is that when I flip to Ratio, I am not able to dynamically format the numbers as a %. Is there any way to specify the number format within the function editor?

Hello All, I would like to compare the #of sales orders created (with special condition) VBAP TABLE in june 2019 with number of goods issues created in june 2019 LIPS TABLE Thanks upfront.

Hi Team, I got doubt while loading data model. I have created a data model and added only activity table and stated loading from hana to data model. But data model loaded case table along with activity table without adding the case table to the data model. Is the case table loading automatic if we add and load only activity table to the data model?

Hi, We are using Celonis 4.5 on premise and we have implemented ECC-O2C data model. To get further, we would like to implement ARIBA-P2P data model, but we dont know which is the correct approach to extract the data to Hana. Do you have some technical information about how to extract this data? Thanks in advanced! Diego

Hi Team, Greetings! I have a Celonis Sandbox instance (https://ey-in-sandbox.demo.celonis.cloud/process-mining/ui) and we are trying to connect this to HANA DB and SQL Server by providing the credentials but are unable to get the connection working. Below are the details. 1>>The HANA DB is on Azure Cloud, we had selected database type SAP HANA and entered the other details which didnt work and we got a simple error message unable to test the connection . What other configuration needs to be done (please specify the details) 2>> The SQL Server 2012 is deployed on a Windows server system (on Azure cloud), we opened the TCP port 1433 at both the OS level and the Azure level for the same for this but the connection has not worked. Could you please help.Thank you!

Hi Experts , We need to connect our Celonis Sandbox instance with CUSTOM TABLES in S/4 Hana. 1>What the different ways of doing it ? 2>What extra steps would be required in such cases for the final analyses creation in comparison to the connection apps available for standard tables/processes for e.g. S/4 Hana P2P connector 3> Is the above scenario also possible for Custom tables in SAP ECC ? Could you please help! Thank you.

Hi, I am encountering a generic error support code while extracting data from an Oracle ERP database. Celonis Support ID: 19442d8c-7c0e-4145-a964-85883ac4cfab Any idea on why is this coming and how to resolve this? I have also raised a support ticket but havent received any response yet. Error log does not say anything else, hence it is not possible to debug the problem. Please help. Thanks, Abhishek Mitra Tata Consultancy Services Ltd.

Dear Colleagues,I have the following problem: I am calculating the DAYS_BETWEEN certain events and if they are more than 1 day, it is to be counted in KPI.image89879 5.73 KBThere are exceptions to this standard rule for month end closing period. I would like to list those dates (or allow users to select them accordingly to closing calendar) and if the date of order is for these particular cut off dates, then is it also acceptable.I created a dropdown and even tried to convert it to date, but I think it is kept as string by definition. Is there any other way to include these exception dates?

Dears, We have created a list of KPIs that are visualized in a world map. The user select using the buttons the KPI they are interested and the map is updated accordingly. (screen 1) Tolerances are setup manually, using variable assignments (screen 2) Our problem is that we want to Generate dynamic thresholds based on KPIs results. For example, the result of the select KPI for all records is 0.513% and I would like to use this value to set it up as the upper tolerance, when user selects Automatic Thresholds , I tried different ways but I always get the variables place holders are writing using Text and not with the value of the KPI. (Screen 3) Is it possible to write the results of KPI to a variable? 11581611 236 KB 21475594 97.3 KB 31342577 96.8 KB Thanks in advance, Cristian

Hello,Im having an issue when I try to use my code in the component Single KPI returning a number.When I use that same code in an olap table it works, when I copy past that code into the single KPI it shows me the value I want in the preview but when I click done it doesnt show the number only a dash.image1205898 63.3 KBThanks in advance

Continuing the discussion from Master data analysis: Can you please send me the documentation about how to enable Master data actvities in IBC.? Scenario: I am from SAP America and customer already bought Celonis licence and we are trying to leverage Celonis for Master data convergence from 14 SAP ECC/ERP into a single ECC with SAP Master Data Governance tool for Master data Maintenance .

Hello,i would like to calculate the combined average time that it takes to move from:Step 3 -> Step 4 (3 days)Step 3 -> Step 5 (5 days)The result i am looking for should be 4 days (for illustration, both process happen once above). I have written the following code but get an error returned to me:AVG(AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[Step 3] TO LAST_OCCURRENCE[Step 4], REMAP_TIMESTAMPS(TABLE_TRANSFORMED.AUDITTIMESTAMP, DAYS))) AND AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[Step 3] TO LAST_OCCURRENCE[Step 5], REMAP_TIMESTAMPS(TABLE_TRANSFORMED.AUDITTIMESTAMP, DAYS))))Would anyone be able to advise on this?Best,Dominic

The median function in the Celonis IBC appears to not work correctly when there is aneven count of items in a data set. MEDIAN() appears to take the top middle number and display it instead of correctly calculating the average between the two middle numbers to get the true median of the data. Here is an example picture showing the difference between Celonis and Excel. Is there a fix for this or a way to calculate the true Median of a data set in Celonis when there is an even number of items?Median_Calculation1137897 77.9 KB

Hi dears, I am not really sure how to custom field name in OLAP table. I guess its syntax maybe likes activity name >= 100 as Custom field name But I could not find a correct syntax to achieve this. Could anyone give me some examples? Thanks a lot. Louis

Hello everyone, I would like to filter a table where COUNT(ACTIVITIES) >=5 but the filter load give me errore. I also tried directly in the KPI : CASE WHEN COUNT(INCIDENT_ACTIVITIES.ACTIVITY_EN) >=5 THEN COUNT(INCIDENT_ACTIVITIES.ACTIVITY_EN) ELSE NULL END But in the table I have the line with NULL I do not want. Thanks Laura

Hi , i am trying to use sql cursor in transfornation job but every time i execute it it shows " error near or at @". I am using @ to declare variable for eg @sample int