Product Q&A

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

Hello, While testing the upload of several data sets in Celonis, I have encountered the following issue: we dont always have one row the per event. What is the most efficient (and standard) way to write generic scripts to transform an event log that doesnt have one row per event? I encounter the following cases: One row of headers, 2 rows per event: Headers: Event ID / Timestamp Event 1 / Time started DD.MM.YYEvent 1 / Time ended DD.MM.YYEvent 2 / Time started DD.MM.YYEvent 2 / Time ended DD.MM.YY Or even the following: Headers: Event ID / Attribute / Value Event 1 / Event type / CreateEvent 1 / Timestamp / DD.MM.YYEvent 2 / Event type / ClosedEvent 2 / Timestamp / DD.MM.YY I have been able to do some things in Excel but as I want to load bigger files (to work on real cases, not only test samples) this becomes an issue. Is there anything we can leverage?

How can i rank users based on the Date appeared in the table.This table is not a activity table unfortunately.The table has users and multiple date assigned to them and i want to know the Date they first appeared in that table. I can use OLAP table and just use a MIN Function but i also want to show it in a Column Chart. Basically that Column Chart will have a week as dimension and no.of users in KPI.I should be able to differentiate New Users vs Existing for a Particular week. Any Advice Please ?

Dears, Is it possible to use a variable to as a column header? In the example below , Variable Visualization_KRI_Main_title , contains the name of the selected KPI (i.e. Ratio of XXX) , we want to use this variable as a header. screen1076720 64.7 KB Can you please advise? Thanks!

Hi together, I have a general question regarding your approach for the temporal dimension of KPIs. If you take for example in the O2C process the SO Creation Date as dimension for the automation rate the KPI will change retroactive because over time there will be more and more activities for a sales order. This makes it really complicated to report those numbers. Same applies for the change rate. Due to that fact we applied for some KPIs a background filter which filters on orders which are finished for example where there goods are already shipped. Doing that you wont have the problem with retroactive changes over time but your KPIs might differ from some KPIs you can show for example in the process explorer. What are your thoghts on that? Do you have any recommendations? Best regards Friedemann

Dear Celonis community, Is it possible to define custom KPIs in the process graphs nodes? E.g. I imported an event log containing a column with numeric values (price) but I cant find an option to display them instead of the case frequencies. Thank you for your support. Best regards, Daniel

Hello, I struggle with a the creation of a formula to determine double postings. (in this cases potential double vendor invoices posted.) My check is to see all case ID (invoice items) with the same invoice reference field (text field) and the same amount. Out put of the formula should be number of cases where this duplication appears. Anyone who has an idea how to create such a formula? Thanks! Kind regards, Ren

I like to know how Celonis can be used for Master Data Analysis in a multi SAP ECC sytems for building the Master data archietcture stratgey. Looking for Master data foot print such as unique master data across the systems and duplicate master data acroos systems.

When using the python API for partial loads the documentation tells you to pass the table ids in the body of the request. Does anybody have the exact syntax? Ive tried: test = requests.post(url, headers={authorization: Bearer {}.format(api_key), table_id:"[{}]".format(tableid) }) test = requests.post(url, headers={authorization: Bearer {}.format(api_key)}, json = {table_id:"[{}]".format(tableid)}) test = requests.post(url, headers={authorization: Bearer {}.format(api_key), body:"[{}]".format(tableid) }) But I always get a 500 error. Regards, Joo

Hi all, I would like to know the day between 2 dates but using the PQL DAYS_BETWEEN it is not working. I need to know how many day passed between a creation of anagrafic vendor (LFA1.ERDAT) and creation PO (EKKO.AEDAT), an between creation of anagrafic vendor (LFA1.ERDAT) and invoice (RBKP.CPUDT). Thank you Laura