Product Q&A

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.

Dear Celonis Community, I have a problem with the Casecount of certain items. Attached you find my data-model where I have linked the Casetable to the Masterdata Tables (Articles, Adresses, Projects and Shipments) and the Activitytable. If I now display the Casecount for different features (see file Problem Casecount Article- and Adress-Table), the Casecount is displayed as having a lot of missing data for the Article related features (left third of the Screenshot) and also for Adress related features (right third of the Screenshot). For the Project related Features it works perfectly fine (central third), but all of these three Tables are linked in the same way to the datamodel via a Foreign Key, which is a number, but which I have declared as being a String-Variable, as I do not need to calculate values for these columns. Can you help me find out, where the wrong values for the Article related or Adress related features come from? Thanks a lot and best regards Jonas Data Modell1920

i have list of activities in my workflow and i want to write the pql for finding list of activities where avg throughput time is more than 1 day. let say the activity A and B has avg throughput time is 1 day and for Activity B and C is more than 1 day. so it should show activity B and C as per pql with their case id

Hi All, i am trying the load the data in celonis system. After successful data is loaded, it shows some error like The timestamp and sorting columns dont define a distinct order of the activity. Eventhough the sorting is properly defined, still the error exists. Could you please help me out? Thanks in advance Celonis Error851179 14.6 KB

Hi,Id like to create a component filter, that only displays cases in the process explorer that dont have any activity with a manual user type. The result is, that we only see the process, where every activity is automated.I tried:FILTER ISNULL(PU_COUNT(VBAP, activity.user_type, activity.user_type IN (<%=AutoTypes%>))) = 0;but it didnt work. I think, pu_count must be wrongHas anyone an idea?Best regards,Carina

Hi,According to the data engineering track, the Celonis transformation uses Vertica SQL. I searched online and find Vertica SQL website: https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/ConceptsGuide/Other/SQLOverview.htm?tocpath=SQL%20Reference%20Manual|_____1I follow the Vertica SQL examples and syntax, but for some examples, I cannot execute them in Celonis transformation statement editor part. Why this happens? Where can I find the exact documentation/manuals for Celonis transformation?Thanks.

Hello Dear All,I am doing an analyze for a supplier companys inventory. The data-set is like this in the image below.Screenshot 2020-01-07 at 14.08.041495829 62.5 KBThe data set is for the last 4 years, and I just want to calculate the daily cases for each product, for determining the amount of Sale order per day for each product.I would appreciate if you could advice me a way to calculate avg daily sale order for each product id.Thank you so much and have a nice working days

Hi All,Currently I have an OLAP table with, amongst others, Sales Order value, Invoice value and a check if these two are equal. For the first two columns (SO value and Invoice value) I just changed the formatting of the column in order to apply 2 decimal rounding. Hence, its showing 3319.94 for both SO and Invoice.However, as per standard SAP these field actually have 15 positions. The results in a problem when Im applying some filtering. Currently I have a filter in place to show only cases where the delta is bigger than 0. Although for the above case the delta is 0, it still showed up in my table. Reason being that actually the SO has a value of 3319.94000000000545 and the Invoice has a value of something like 3319.939999999999929.Question now is how to make use of the rounded decimals values instead of the actual values in a filter or formula. Stated in Excel terms, I want to filter on cases where:abs(round(SO value, 2) - round(Invoice value,2)) > 0It seems like the Round functi

Hello Dear All,I am doing an analyze for a supplier companys inventory. The data-set is like this in the image below.Screenshot 2020-01-07 at 14.08.041495829 62.5 KBWhat I want to do is to determine the valuable products according to frequency and price rank. So, for this purpose I firstly aggregate the all products with price rank and created new column represent the frequency counted.Screenshot 2020-01-07 at 14.56.44435820 18.6 KBAnd frequency is calculated with this KPI: COUNT_TABLE(PM_Last.csv_CASES)And now I just want to apply a manual RFM algorithm to determine most valuable products. So, I need to use the values of this two column and create a monetary value in another column. For this, I just need to multiply the 2 column, such as the formulation that I tried COUNT_TABLE(PM_Last.csv_CASES) * PM_Last.csv.BuyPriceRankBut, I receive this error message : Screenshot 2020-01-07 at 14.12.45786133 9.82 KBI think, what I want to do is not complex but I couldnt find a way to use aggrega

Hi, I would like to create an analysis for three of our depts. together.The department is one of the characteristics of activities and the whole process is not only happens in those 3 depts of interest.If I use filter ACTIVITY_TABLE.DEPT IN (1,2,3) Celonis cuts all the activities that were performed in other departments. I am rather interested in all the cases that were ever touched by my 3 Departments no matter if some of the activities were performed somewhere else - the process should be shown completely.Thank you!