Product Q&A

In OLAP table series color mapping, we need to set the threshold value as a value from a KPI or variable. Like for the one we can use the fixed value as the threshold value in the Color Mapping

I cant save overview in .pgn format. option does not appear: Export: BPMN export (XML) and export component (PGN)

Hi team, Our group has been recently migrated to IBC. Now i am trying to access the analysis and datamodels of IBC via python from my local system. But i am unable to login . I was using python in the old environment , and i was using API_ID and API_token, now which API_ID isnt availble for me. Is API_ID required to login? or is just API_token along with the URL is enough? Please suggest Code that i have tried: from pycelonis import get_celonis login = {celonis_url: my_url, api_token: my_api_token} c_source = get_celonis(**login) Thank you.

Hi All, I have the following requirement: Suppose a process is as Start->A->B->C->D->E->End. Now, I would like to view the Avg Throughtput Time for Activity E. There are cases where the process flows from A->E, B-> E, C->E and D->E. (different variations) So the logic should then calculate the Average of the Time Differences between Activity E and the activities which occur just before Activity E. (could be any one of A / B / C / D). We dont have the Endtime field. (it wouldve then been just a diff b/w Starttime - Endtime) I hope the requirement seems clear. Your help would be highly appreciated. Thank You.

Ive a table component with 2 dimension:Dimension 1: Combination of Company code + Vendor ("'BKPF".BUKRS||BKPF.LIFNR)Dimension 2: Count of documents (COUNT(DISTINCT BKPF.BELNR))However Im unable to filter the Document count with count > 1. The system returns the error An aggregate is not a function. Please check that there are no dimension and aggregations used together as function inputs.Can anyone suggest how to achieve the filter?

Dear all, I have a few different questions about the Process Data Model. I think there have been a few CELONIS adjustments in the past. Even though the relationship between activity and case table is correct (Process will be shown in the process explorer in the correct way) the display 1:N is mirrored (pic #1). In the past it was possible to declare/identify the case table with a . I cant find this option any more in the drop down option (pic #2). In general we need to insert two sources (different systems) in the same process analysis. They are running in parallel and are differentiated by additional information in the case (pic #3). The data is written into the case table. Difference than usual (normal create case table syntax), we use the SQL Vertica insert into syntax like we used in the activity table. We have to match two different systems with different data sources. In my opinion it will work fine, but I am not really sure that we can use it that way. Although I only create

Hi all, We have 2 (on premise, so not IBC) Celonis environments running: one where we develop our dashboards, and one production environment where finished and tested dashboards run. Transporting dashboards from DEV to PRD is only done by us, on request. However, were looking into automating the manual steps to reduce errors. Creating the transports from one or more dashboards and/or datamodels seems to be feasible through the Python API. However, Im wondering if the overwrite option is available in the Python API when uploading transports. The documentation does not mention this. Does anyone have any insights/ideas/suggestions?

Dear Celonis Community, I am having trouble creating a bar chart which tracks the amount of unsend orders. I need to filter all cases which do not have the Delivered activity and at the same time, have a preferred delivery date < current date. I managed to write two seperate statements but get errors trying to combine both. Maybe somone can help. SUM(MATCH_ACTIVITIES(EXCLUDING_ALL[Delivered])) and SUM(CASE WHEN TO_TIMESTAMP(CASES.Preferred_Delivery_Date, ) < HOUR_NOW(PST) THEN 1.0 ELSE 0.0 END) Kind regards. Konstantin

Im trying to convert a string field to date using TO_TIMESTAMP function in Celonis but receiving the error Undefined exception occured: ToTimestamp: Input does not fit to date format.The function works well for a constant value.e.g. TO_TIMESTAMP(20210101,YYYYMMDD)but does not work for a table field. e.g. TO_TIMESTAMP(CEL_AR_ACTIVITIES.CHANGED_TO,YYYYMMDD) returns error.Can someone help with the error?Thanks.

Hello! How can I put similar filter on a table? In KPI, I would write it in this way: CASE WHEN PROCESS EQUALS END THEN document deleted ELSE valid document END (means = Deleted) but how do you write it as a filter?

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