Product Q&A

Dear all,I am encountering curious changes of results depending on the number of KPIs and Filters. I put an identifier in EKKO-VERKF for differentiating process patterns. Each pattern goes through maximum four, minimum two process flows. In other words, one CASE_ID contains from two to four activities.Here is the problem: the result changes after you add another KPIS, namely M04 disappears, from M01 to M03 gains/loses a few. I am wondering why one KPI affects the others, or rather if I write this code wrongly.Best regards,[KPIS]CASEWHEN SUBSTRING(EKKO.VERKF, 3, 3) = M01THEN CALC_THROUGHPUT(FIRST_OCCURRENCE[A] TO FIRST_OCCURRENCE[B],REMAP_TIMESTAMPS(ACTIVITIES.EVENTTIME, HOURS)) - 7*24WHEN SUBSTRING(EKKO.VERKF, 3, 3) = M02THEN CALC_THROUGHPUT(FIRST_OCCURRENCE[A] TO FIRST_OCCURRENCE[B],REMAP_TIMESTAMPS(ACTIVITIES.EVENTTIME, HOURS)) - 14*24WHEN SUBSTRING(EKKO.VERKF, 3, 3) = M03THEN CALC_THROUGHPUT(FIRST_OCCURRENCE[A] TO FIRST_OCCURRENCE[B],REMAP_TIMESTAMPS(ACTIVITIES.EVENTTIME, HOURS)) -

Hi, thank you for dropping by this topic. Im trying to use KPI Format as Start of MOVING_SUM. MOVING_SUM(COUNT_TABLE("_CEL_SD_ACTIVITIES_CASES"), KPI("Number of process variants") *-1,0) This KPI returns me an error: that start parameter should be an integer, which I firmly believe I am giving it integer. Using COUNT DISTINCT instead has not solved this situation btw. This should show the same result as the formula below. MOVING_SUM(COUNT_TABLE("_CEL_SD_ACTIVITIES_CASES"), -2,0) Best

Hi Team, I am working on uploading the file data to build eventlog in IBC. In the file, one of the file holds seconds and I would like to convert to time as hh:mm:ss, after that I need to add this time to existing timestamp to get the correct Eventtime in event log. Example : Field 1 Field 2 625 2019-11-20 13:41:25 I need to convert field 1 (625) to Time format hh:mm:ssthen add the time (in step1) to Field2 , this is not only adding, date should automatically change if the time exceeds 24 hrs I tried with the possibility of using ADD_Seconds function but it throws message as the function does not exist. Your suggestions are welcome!add_seconds1313228 10.6 KB

Dear all,I would like to create an OLAP table with the activity as dimension. And I would like the following KPI as a column:If all activities with the name of the activity in the dimension ran automatically for a sales order item, then count 1, otherwise count 0.For example:So if the activity Change Price occurs 3 times for an order item, and all price changes are delivered automatically, then count 1.But if at least 1 price change was manual, count 0. The following code does not work unfortunately. I suspect that is because the dimension is on activity level, and the calculation on item level.2020-12-22_11-09-13761117 28.7 KBSUM(CASEWHENPU_COUNT(VBAP, _CEL_O2C_ACTIVITIES.USER_TYPE, _CEL_O2C_ACTIVITIES.USER_TYPE NOT IN (<%=AutoTypes%>)) = 0ANDPU_COUNT(VBAP, _CEL_O2C_ACTIVITIES.USER_TYPE, _CEL_O2C_ACTIVITIES.USER_TYPE IN (<%=AutoTypes%>)) > 0THEN 1ELSE NULLEND)But is there any way to calculate this?Many thanks in advance!Best regards,Jonas

Hello everyone We were checking the description what stands for Case vs Activity Frequency Case Frequency simply counts the number, that this activity is hit by any case, the Activity Frequency counts the distinct cases that pass this activity. The Activity Frequency will thus always be equal or smaller than the Case Frequency. In reality, it looks the other way around activities nr are higher Case vs Activity Frequency.docx (533.0 KB) thank you Tatiana

Hi, Everyone. Im trying to use a dynamic parameter within a transformation task, but I cant make it work. It doesnt matter how I input the Table Name, I always get the same message when executing the task: Table XPTO to calculate dynamic parameter Test does not exist (yet) - using default. Ive used the table name with and without schema name, with and without quotation marks, even tried with the tables internal ID but nothing seems to work. What am I missing? Thank you for your help. Joaquim

Good morning, I am facing a problem where I need to display subprocesses in process explorer in Celonis. In the process, all cases have a similar path through the same steps. However, at the end of the main process, some cases continue in a subprocess. I found out that there is a function RESPECT PARALLEL PROCESS in Activtivities table. Has someone used this possibility, please? Thank you for advice. Tomas

Hi all,I want to calculate the cycle time with the workdays_between function. Is it somehow possible to calculate on a minute level?WORKDAYS_BETWEEN(VBAP.FABKL, PU_FIRST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN IN (<%=Non_ESOP_Activities%>)),PU_LAST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN IN (<%=Non_ESOP_Activities%>)))Thanks a lot in advance.Best regards,Jonas

Hi Team, My activity table contains casekey, Activityname_EN, Activityname_locallang, Eventttime. I managed to read the process explorer activities in locallang by using Activityname_locallang field in activity table. But in Selection views, all the activitynames are reading as English text instead of local language. Can you suggest a way forward to read the text of activitynames in locallanguage?

Im trying to load some files, the model is correctly loaded with correct foreign key, have loaded both files with the same datatype INTEGER for _CASE_KEY column. While trying to load data, im facing the issue mentioned below: Data model load failed during load to engine: Could not load data model. Load failed. Error Message: Error while joining table PO_DISTRIBUTIONS_ALL_xlsx_Export_Data with table _CEL_P2P_ACTIVITIES_xlsx_Export_Data. Data type of column _CASE_KEY doesnt match data type of column _CASE_KEY. Celonis Support ID: 8e12a1b3-589b-4720-be56-8b90a0fd6e7d Please help.

Hello everybody,i want to subtract two simple COUNT formulas but it doesnt work.However, if I look at the individual results, then I have a result.Funnyimage996864 63 KBimage273758 4.34 KB image287723 4.39 KBwhat am I doing wrong?ThxSteven

Hello, I would like to know when the Ui Path System connection is again available? A few weeks ago there was the possibility to connect Ui Path in Celonis Snap, but now there is no connection anymore possible?

Hi, Is there any way in Celonis to show last day of that month based on a particular date column. Example- We have below values in a date column 13-Feb-2020 5-May-2020 28-May-2020 17-July-2020 4-Aug-2020 and, We would like to see below values as an output 29 31 31 31 30 Thanks, Amogh

Hi everyone,i hope you can help me with a FILTER function.image716234 8.28 KBI need a FILTER function with PU_LAST that deletes my cases (in this case it is 98068) when the last activity of Vorgangsart_gend. in column Wert Neu is like /RWEE/DGF.Can you help?

Hi everyone, I am completely new to Process Mining, Celonis and PQL. After spending a few days building an example analysis I have two questions that came up: I have seen screenshots of Celonis and other tools where you can choose a Start Activity and End Activity timestamp column. The tool then calculates the duration of the activity. Why can I not select a End Activity column in Celonis? For example in Process Explorer, Celonis calculates the connection between two activites as throughput time Start of A to Start of B, whereas I would like to see End of A to Start of B. Now the more complex question. I am struggling with a few rather simple calcuations. These are my tables: image1008156 4.1 KB With KPI Duration = SUM(MINUTES_BETWEEN(EVENTLOG_csv.START, EVENTLOG_csv.ENDE)) So far so good. Next step I would like to aggregate the durations for the diffrent activites on case level (works with same KPI as above) and calculate two more KPIs. image1011135 3.47 KB I cannot get the desire

Hi all, I have an OLAP table, showing the Case Count of the BSART Column by Month. I need a column chart showing the same values, but it does not work. Is it not possible with Celonis? Kind regards, Konstantin

Hi everyone,I hope someone can help me in this case.Parenttable: AFKOChildtable: Activity_TableNecessary columns within the Activity table: Activity_Start , DelayAt first I want to search for the smallest value of Activity_Start for each Case in AFKO:PU_MIN(AFKO,Activity_Table.Activity_Start)Next, I want to get the corresponding value of Delay.How must a formula look like?Thanks for your help!Alex

Hi Team,We have been using Conformance checker sheet in Celonis for testing conformance on our processes. When we perform the conformance check we usually use the crop selection filter on the top to limit our process to a certain set of activities(i.e. a part of the process) which we need to test on the basis of the process model. However, in certain scenarios, we need to also substitute this with a query in the load script which we are doing it using the below mentioned query:FILTERCASEWHEN CALC_CROP (FIRST_OCCURRENCE [ START_ACTIVITY ] TO FIRST_OCCURRENCE [END_ACTIVITY],CASEWHEN Activity_table.activity_column = ATHEN START_ACTIVITYWHEN Activity_table.activity_column = BTHEN END_ACTIVITYELSE Activity_table.activity_column END) = 1THEN CropELSE NULLEND= Crop;The above query is working fine and we can see the cases getting filtered in all the components. However, if we deep-dive in some violation from the conformance sheet there is an issue with the analysis where we have the load scrip

Hello Everyone,I need to compare for each Vendor the amount of POs of last week to the average number of POs per week of the 12 weeks before (from today -2 until -13). Im only not totally sure on how I can solve this issue?I use this formula for the amount of POs of last week.PU_COUNT_DISTINCT(LFA1, EKKO.EBELN,(CASE WHEN ROUND_WEEK(EKKO.TS_AEDAT) = ADD_DAYS(ROUND_WEEK(TODAY()),-7) THEN 1.0 ELSE 0.0 END)=1.0)And tried using Moving Average for the average over multiple weeks, but Im not getting this solved in a way which would provide me with just 1 average.Table need to look like this:Vendor POs last week Average # POs per week over the earlier 12 weeksXYZ 8 3,2Thanks in advance for any help on this topic.Best Regards,Pim

Dear everyone, I hope you are all doing okay ! When executing a transformation task (Cancel Invoice for M2C) i get the following warning : Warning! SELECT INTO statements currently only insert 100 rows. Please use CREATE TABLE AS instead I do not understand why this happens since it appears also when i do not use a select into statement but only a distinct count statement See below my script if needed Very thankful for some advice ! Best regards, Antoine SPIRIDON SELECT DISTINCT COUNT (*) FROM EABL JOIN EABLG ON 1=1 AND EABL.MANDT = EABLG.MANDT AND EABL.ABLBELNR = EABLG.ABLBELNR JOIN EVER ON EABLG.MANDT = EVER.MANDT AND EABLG.ANLAGE = EVER.ANLAGE JOIN ERCH ON EVER.MANDT=ERCH.MANDT AND EVER.VERTRAG=ERCH.VERTRAG AND ERCH.BELEGART IN (VA, SA) JOIN ERCHC ON 1=1 AND ERCH.MANDT = ERCHC.MANDT AND ERCH.BELNR = ERCHC.BELNR JOIN ERDK ON ERCHC.MANDT = ERDK.MANDT AND ERCHC.OPBEL = ERDK.OPBEL AND ERDK.INTOPBEL IS NOT NULL JOIN DFKKOP ON 1=1 AND ERDK.MANDT= DFKKOP.MANDT AND ERDK.OPBEL= DFKKOP.XBL

Hello community,I hope you can help me.I have a simple problem I think, but too difficult for me Here my Formula that not works(TRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE[Skonto Flligkeitsdatum berechnen] TO LAST_OCCURRENCE[Vorgang beendet],REMAP_TIMESTAMPS(T_CEL_AT_ACCOUNTS_PAYABLE.CREATED_AT, DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)), 5, 5))+(TRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE[Skonto Flligkeitsdatum berechnen] TO LAST_OCCURRENCE[Ausgleichsbeleg_gend.],REMAP_TIMESTAMPS(T_CEL_AT_ACCOUNTS_PAYABLE.CREATED_AT, DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)), 5, 5))+(TRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE[Skonto Flligkeitsdatum berechnen] TO LAST_OCCURRENCE[Vorgang auf Status Zurckgeschickt gesetzt.],REMAP_TIMESTAMPS(T_CEL_AT_ACCOUNTS_PAYABLE.CREATED_AT, DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)), 5, 5))if I speak e.g. with numbers, it is like7,6+8,5+-= - (dont work)another examble7,6+8,5+5= 21,1 (work)My Problem is the - (it is like #NV or no result). Th

Hi Team, I have the following situation: 1 column reflects product IDs and the other column are attributes of the product like color, size, etc. Example: I have the following table: Ids Attributes 1 Red 1 5 1 3 2 Blue 2 3 2 1 I have created new columns for each attribute but the result looks like this: Ids Color Size Pieces 1 Red - - 1 - 5 - 1 - - 3 2 Blue - - 2 - 3 - 2 - - 1 I need to transform this table in the following format: Ids Color Size Pieces 1 Red 5 3 2 Blue 3 1 I am not sure if a self-join on the attributes column and based on the Product IDs is the right solution here. If yes does anyone know how to do it? If not then is there a better solution? Thanks for the feedback!

Hello everyone, Is there the possibility of calculating the throughput time between between one activity lets say Create Order and multiple occuring activities, lets say Change date. The problem is that Change date can happen multiple time and at each occurance the time between create order and change date should be caluclated. The process is for example: Create Order-> -> Change date -> -> Change date The result, which i want to see is a histogram chart with the information: number of occurances number of days between create order and change date In this example giving me 2 bars for each time difference. Hope i made my case clear. Thanks for any support!

Dear Experts Does anyone know if Celonis 4.6 (OP version) support HANA 1.0 SP12? And is there anywhere I can find more documents regarding the OP version? help.celonis.com consistently ask me for logon but I dont have an account Thanks!

Im following the Machine Learning training and am having problems with permissions. Ive created and entered the API token, but get this error: WARNING : the Application key of this App is missing the necessary Process Analytics permissions to use this App properly. I have added these permissions, but still get the error and when I try to Fetch Data Preview not data is returned. Is this a known problem or am I missing a step to add additional permissions? Dave