Product Q&A

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

Hello, I see that the mine process for the conformance checker can create the Parallel symbol. If I create the process from scratch, I do not see how to add such a parallel symbol. Any help is appreciated :). image61513 2.47 KB

Activating your account is really easy. After you sign up, you will receive an email from no-reply@celonis.cloud like the screenshot below. Pro Tip: If you didnt receive an email, check your Spam and Junk folder. image15721356 265 KB Just click on Join the team and you will be redirected to accept the Terms of Use and the Privacy Policy. After Agreeing, click on Start. image1370886 125 KB You will be asked to enter your Name, a Password and a Picture (optional). Once youre done, click on Join. And thats it! image16121270 167 KB You can now log into your Snap team. Pro Tip: If you want to log in, you can go to Find my team and log in with your email. For questions, you can always contact the snap team via snap-support@celonis.com Happy Process Mining!

Hi everyone, My client would like to know if the change price or quantity is less or greater than the previous value indicated in the order. The issue is that Change_from and Change_to in the Activities table is an int value and not a number. What formula can I use knowing that > and < can not work? Thank you Laura

Dear team,We have an indicator related vendors who has been paid with both, MM and FI invoices and we calculate this as a ratio, so far so good.The problem is when we want to provide the list of those vendors for further review, We have the dimension Vendor and one calculated column that states whether the vendor has FI and MM invoices or either FI or MM which we understand is not subject to review and its listed as OKas the vendor has both FI and MM is calculated as an aggregation. (See formula below) I can not implement a filter just to show only those that are FI + MM , in the screenshot below i would like to exclude those that are OKDo you have any suggestion?All the best ,image1418575 31 KBCASEWHENSUM( CASE WHEN BKPF.AWTYP != RMRP AND BSEG.BSCHL = 31 THEN 1.0 ELSE 0.0 END ) > 0 ANDSUM( CASE WHEN BKPF.AWTYP = RMRP AND BSEG.BSCHL = 31 THEN 1.0 ELSE 0.0 END ) > 0THEN FI + MMELSE OKEND

Hi, I want to Display the Number of Cases that exist in the Cases Table but not in another Table. Celonis_Table_Comparison847184 2.24 KB For example with the data shown in the picture I want to show 2 since Cases 4 and 5 exist in the Cases Table but not in Table 2. Currently my problem is that when I count the total entries of both tables in separate single KPI fields they show the Correct Values: COUNT (DISTINCT (CASES.ID) = 5 and COUNT (DISTINCT (TABLE_2.ID)) = 3 But as soon as I combine both formulas to get the difference as: COUNT (DISTINCT (CASES.ID) - COUNT (DISTINCT (TABLE .ID)) It returns 0 which of course isnt correct as I would expect to get 2 (5 - 3). After some trying I noticed that when I add both values it returns 6 so it seems that the value for the total amount of cases changes from 5 to 3 which also explains the 0 it returns when subtracting. In the Data Modell Cases.ID is connected with Table_2.ID I have also tried solving it with a Case When Statement. COUNT (DISTI