Data Ingestion & Infrastructure

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 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

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!

Hello celonis community, i discovered a strange behaviour in one of our data models. It seems to unload itself when im using some specific components. I found out it happens often when i use the alternative dimensions in the process explorer or variant explorer to filter the activities based on some attributes. Our Processes have a wide variety of activities per case. So often the view over everything is not the best way for a deeper sight into the process. So i just set a filter on the activities which are created from a specific ressource or something like this and want to display only these activities in the process explorer. But then suddenly the whole data model is unloaded and needs to be reloaded from source. Has someone the same issue or does someone know why this is happening? we are Using On-Premise 4.6

Hello Team,Could you please guide on how to create subfolder structure as same as UAT in DEV using pycelonis and how to push all the analyses in each folder

Hi ,I need some help.I want to add two results from PU_SUM ( child_table, parent_table.column [, filter_expression] ).I wroteADD (PU_SUM ( child_table, parent_table.column [, filter_expression] ),PU_SUM ( child_table, parent_table.column [, filter_expression] ))orPU_SUM ( child_table, parent_table.column [, filter_expression] ) + PU_SUM ( child_table, parent_table.column [, filter_expression] )But there is a rule: If no value in the parent table exists for the element in the child table (either because all values of the parent table column are filtered out, or because no corresponding value exists in the first place), NULL will be returned.If the result of first of them = NULL, then the result from ADD is also NULL, although the 2nd result is <> NULL.But I would like to have the sum of both. How should I do that?

Hi Team,We are working on the process conformance module in Celonis. We are currently getting the details of a violation through the use of the conformance query in an OLAP table.However, we need to get the count of the whitelisted violations also exported to an OLAP table.When a violation is whitelisted it gets added as conforming activity and we are not able to differentiate a whitelisted violation from conforming activity.Is there a way in which I can obtain the count of the Violations and also the Whitelisted Violations in a component using some formula.Thanks in Advance

Im currently working on the implementation of the Celonis IBC at a client. The process were analyzing contains parallel process steps. In the old version of Celonis there was an option to indicate Child/Parent columns in the acitivity table (https://celonis.cloud/help/display/CIBC/Parallel+Processes), however I cant find this option in the IBC. Is this option already available somewhere in the IBC? If not when can we expect a release?

I was editing the code in the Transformation task and at the same time, my colleague was also changing the same transformation task. Then, both the codes got reflected, which is not correct. Is there anyway through which we can restrict other person to access that code if someone else is working on it.

Hi, in data jobs I am doing a transformation and need to concat strings in a group by statement. How can I do this? I tried using google, stackoverflow and so on, tested different methods but was not successful (https://stackoverflow.com/questions/21053477/concat-group-by-in-vertica-sql/21054041) Kr, Mara

Hi all, I have the following problem I have two tables Table 1: EBAN -> Content 50 Purchase Order Requisitions (PRs) where 40 already have a created PO Table 2: EKPO -> Content 40 Purchase Order (POs) with key connection to the PRs above. Now I have created an OLAP with two KPIs #PRs#POs When I just show the KPI #PRs the number is 50 (which is correct). When I display both KPIs (#PRs and #POs) the number ist just 40 because the EKPO for that PR is NULL. Is there any chance to show both KPIs in one OLAP but with the correct number #PRs 50 #POs 40 I use the Celonis on Prem version. Many thanks and br Daniel

Hello, I have an issue with the Parallel processes feature. Here is my activity table and my process configuration in the data-model: CELONIS_ACTIVITY TABLE990362 9.84 KB This is what I expect to see in the process explorer: But this is what I get CELONIS_REAL91534 10.1 KB I do not know why the parallel process configuration is not taken into account Thank you in advance for your help, Best Regards Robin

Hi, I have to add new activities to the existing _CEL_P2P_ACTIVITIES table, which was also used for analysis. CELONIS11914934 15.7 KB After i insert the new activities, i make some selects to check the data and appers that is correct. CELONIS21914934 7.71 KB After that somes ok. But when i go to add the new activitie in my analysis from Workspaces, in the new sheet i try to create a new selection, but dons appear the new activities that i insert on the table. CELONIS31914934 30.2 KB If i execute an instruction on SQL i see the activity on table, but on the analysis dons have that. Did I miss any step to do, i need to make a some regeneration table or some like that? Thanks all

Hello Celonis community,I want to determine the number of data records in vertica for all tables of a schema (SAP System).The easiest way should be via the system table tablesso I get all tables of a SAP connection, which also worksselect * from tables where table_schema = XYZbut unfortunately the following does not work:select t.table_name,(select count(1) from t.table_name) as table_row_countfrom tables as t where t.table_schema = 'XYZ-> Execution error: Not allowed to access schema tthe other way via a system table does not work reliably:SELECT table_schema,table_name,SUM(row_count) AS row_countFROM (SELECT table_schema,table_name,NVL(CASEWHEN NOT is_segmented THEN (row_count / node_cnt)::INTELSE row_countEND, 0) row_countFROM (SELECT t.table_schema,t.table_name,ps.projection_name,(SELECT MIN(is_segmented)FROM projections pWHERE p.projection_name = ps.projection_nameAND p.projection_schema = ps.anchor_table_schema) is_segmented,node_cnt,SUM(ps.row_count - NVL(dv.deleted_row_c

Need to calculate time spent on Credit hold activity for order to cash process and populate a column of OLAP table but credit hold activity is denoted by 2 names in activity table 1)Set Credit Hold 2)Set Default Credit Hold.What should be the formula for thisI have used formula(CALC_THROUGHPUT(FIRST_OCCURRENCE[Set Default Credit Hold] TO LAST_OCCURRENCE[Release Credit Hold], REMAP_TIMESTAMPS("_CEL_O2C_ACTIVITIES".EVENTTIME, HOURS)))But I need to put below condition as well for same column(CALC_THROUGHPUT(FIRST_OCCURRENCE[Set Credit Hold] TO LAST_OCCURRENCE[Release Credit Hold], REMAP_TIMESTAMPS("_CEL_O2C_ACTIVITIES".EVENTTIME, HOURS)))

Hi, Are there any process connectors, data model and analysis in healthcare domain or pharmacy related ?

Hi Team, I am currently working on auto-assignment of the DBConnection to the table all at once in the front end via the python code. But i am not getting any functions which can help me with that. I am able to connect to the datamodel, fetch the table ,table data and change the table names too. The only thing i am lacking is to change the DBConnection of everytable from python. I could analyze from the data of the table fetched via python that each DBConnection has their own DBConnectionID , but i am unable to change that ID from python. Please let me know if that change is possible, if so, how to do it. Thanks in advance.

We have one SAP client connected already. Now we want to connect the second one, the same process (O2C). In this other client we have a separate business division, which we want to analyze separately. Current already existing analyses shouldnt be influenced by this new data load. We will probably also want to have some analyses to compare the business divisions, but we will definitely need to be able to easily create analyses separately. Will appreciate any guidance a lot. I will outline below my understanding and will appreciate comments to it. I understand that first of all we need to create the new connection. And from this instruction we only need to perform steps 1 and 6, because the server part is already there and it is not SAP client specific. Then, for the moment, since we have a data load running every night, I will add a filter on the case table (VBAP) to only take data from the first client (MANDT = CLIENTNUMBER). Because, if I understand correctly, otherwise with the next

Hi Team,We are working with the conformance module in Celonis. I see an error msg popping in all my components saying that Your model contains duplicate activities. Activity A occurs in the model 2 times, Activity B occurs in the model 3 times Please try to create a model without duplicate activities as it may cause severe performance issueIn my reference model, I have used duplicate activities however they are a part of different sequence flows (e.g. two different paths after split using exclusive gateways) and also for some instances the activities can happen again in the sequence flow.Can you help me understand this error msg in detail and how exactly does it affect the performance issues?Thank you in advance!Soham Potdar

Hi Team, I am trying to use standard Three way match formulas from App store. It is showing the below error message: Pull-Up-Function could not be executed. Table EKPO is not a child of table EKBE. Use a non Pull-Up-Function instead. In the data model, the tables EKPO (case table) and EKBE are joined on the columns MANDT, EBELN & EBELP. Could you please suggest what could be the cause of the issue?

Hi Team,We want to visualize three KPIs corresponding to a particular dimension. We are thinking of achieving this in terms of the horizontal and vertical axis of a scatter plot (2 KPIs) and the third being the bubble size.I wanted to know whether there is a way to increase the size of the bubbles based on additional KPI in Scatter plot (other than the ones specified in horizontal and vertical data series) ? If not, is there a way to look at additional KPIs in scatter plot when you hover over the bubbles ?Thanks in AdvanceSoham Potdar