Product Q&A

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

Hi all, I want to set a value based on different conditions. If I do Median( case when Eventlog_casestates_GDP_csv.CASE_STATE = running then case when (<%= Durchlaufzeit_Median %> > DAYS_BETWEEN(PU_FIRST(Eventlog_cases_GDP_csv, Eventlog_activities_GDP_csv.TIMESTAMP),TODAY())) then <%= Durchlaufzeit_Median %> else NULL end else CALC_THROUGHPUT(ALL_OCCURRENCE[Process Start] TO ALL_OCCURRENCE[Process End], REMAP_TIMESTAMPS(Eventlog_activities_GDP_csv.TIMESTAMP, DAYS)) end) but actually I want to set the days between as well. So if I do Median( case when Eventlog_casestates_GDP_csv.CASE_STATE = running then case when (<%= Durchlaufzeit_Median %> > DAYS_BETWEEN(PU_FIRST(Eventlog_cases_GDP_csv, Eventlog_activities_GDP_csv.TIMESTAMP),TODAY())) then <%= Durchlaufzeit_Median %> else DAYS_BETWEEN(PU_FIRST(Eventlog_cases_GDP_csv, Eventlog_activities_GDP_csv.TIMESTAMP),TODAY()) end else CALC_THROUGHPUT(ALL_OCCURRENCE[Process Start] TO ALL_OCCURRENCE[Process End], REMA

Hello everyone,I have a question about quick display of dates in a certain form.There are two date-time fields, A and B. I need to calculate the difference between them and to display it in user-friendly format HH:MM:SS. For example, A = 12:30:05, B=14:20:00, then I want to have 1:49:55.Using the celonis function DATEDIFF(ss) or SECONDS_BETWEEN I obtain a big number like 6595.an I get this time difference in the desired format HH:MM:SS in some natural way, without using tiring formulas like SECONDS_BETWEEN(A,B)/3600 || : || SECONDS_BETWEEN(A,B)/60 || : || SECONDS_BETWEEN(A,B)%60 and so on?Thank you,BestPolina

Is there a way to delete already uploaded files on Event Collection>File Uploads.

I would like to upload CSV data to SNAP workspace account of mine. I want to do it in an automated way. If there is REST API, i can do it. Is this possible? If so can anyone point me to the documentation to achieve this?

Hey @all, I need a filter that looks at the event time of the activity I am looking for. With this filter I can determine my KPI worklist. At the moment i have a filter, but the wrong filter. For Example. image984209 7.49 KB In this picture we can see my Celonis activity table. (ID activity timestemp) In my other table AUFK I have the column ERDAT in which i can see the start date of my order -->(28.Feb.2019 07:51:48) My actually FILTER YEAR(AUFK.ERDAT) = Year(Today()) keeps the Start date of my ID 6254008060 with the activity Erffnet. But I need the timestemp Technisch abgeschlossen for my filter. > FILTER YEAR("timestemp from technisch abgeschlossen) = Year(Today()) On this example the Year is the same, but I have enough IDs where the start Date ist in 2018 and the activitity technisch abgeschlossen is in 2019. That means I could get rid of AUFK.ERDAT and use directly the timestamp of my activity table. But I dont know the Function. Pls can u help me.

Hello,Im trying to use 2 olap tables (one in front of the other) and a button dropdown with two variables and I want that one olap table come to the front layer when I select one of the variables in the dropdown button and when I select the other variable in the dropdown button the other table comes to the front layer again. Is this possible?Thanks in advance

Hi Celonis Community, I am currently analysing a P2P process where some orders have just been created, but not been ordered. These orders still have monetary values assigned to them in the Casetable. If I now add up the values to get how much money was spent e.g. on a certain article, these values distort my results, as they are also accounted for, but have not been ordered. Is there a way to restrict e.g. a certain table or sheet or the whole analysis to only values which run through the process step invoice received to only add up cases which have actually been ordered? E.g. with the Component-, Sheet- or Analysis-Filters? Thanks a lot. Best regards Jonas

Hi Team, 1-In OLAP TABLE how to Add Grand Total Row with sum of Numeric value. 2- Let Say in Table - I have 5 Rows , and want to exclude 1 Rows . 1- A - 10 2-B -20 3-C-30 4-D-40 5-Null -50 I want Show olap table as below 1- A - 10 2-B -20 3-C-30 4-D-40 Total - 100

Hi everyone, is there a way in IBC to access the current selections displayed in the selection bar via a variable, etc? Wed like to list current selections for example in text components. Best, Benedikt

Hello,I would like to filter a field after comparing it to a variable.The variable value is only a part of the field value, that is why I would like to use the "LIKE % % function.I tried to define % and % as wrapping characters for the variableI also tried to write % and % manually in the component filter formula.( FILTER TABLE.FIELD LIKE % <%=VAR%> %; )None of these worked. Is there a solution for this?Thank you very much for your help,Best RegardsRobin

We have a question in regards to matching percentages when combining two tables with a one to many relationship. Fig 1. Tables one to many relationship When performing a count on the keys used for joining, we get the correct counts when using two number components. For example: Number Component 1: COUNT( TableA."_case_key") Number Component 2: COUNT( TableB."_case_key") However, when we combine the counts in a single component, and divide them by each other, then we receive the wrong count. So the component 3 is wrong: Number Component 3: COUNT( TableA."_case_key")/COUNT( TableB."_case_key") We suspect the error might be lying in the way the tables are joined. Please guide us in finding a solution, to get the right division.