Product Q&A

Hi, I am trying to build a simple pie chart and am a bit puzzled by the results. As dimension I added the following statement: CASE WHEN VBAK.BSARK = DFUE THEN EDI ELSE NON-EDI END And as KPI: COUNT_TABLE(VBAK) So, I want to see a pie chart that will be divided into two parts based on the value in the field BSARK: part 1 - DFUE part 2 - anything else But for some reason the pie chart also has a 3rd part which has - value. How shall I understand it? thanks a lot for any advise

Dear Celonis, not sure if such a feature request already exists. If yes, then please ignore. Otherwise - it would be great to have a built in possibility for versioning, especially for data jobs, but actually for the whole instance. Or in general test/production environment concept. thanks Masha

In the sandbox, environment following the notebooks, when I run: "from pycelonis import get_celonis celonis = get_celonis()" it tells me i dont have permissions: "WARNING:pycelonis:The IBC did not accept the credentials: " I have given the application key all permissions in the team settings and in the event collection. What am i doing wrong?

Dear Celonis development team, I tried to connect and extract data from IBC to my Colaboratory python environment using Pyceonis. Normally it worked correctly with below scripts. from pycelonis import get_celonis login = {celonis_url: my_url, api_token: my_token} celonis = get_celonis(**login) analysis = celonis.analyses.find('id of my analysis) sheet = analysis.published.sheets.find(id of my sheet) component = sheet.components.find(id of my component) df = component.get_data_frame() But sometimes get_data_frame method returned exception. Exception Traceback (most recent call last) in () ----> 1 df = component.get_data_frame() 2 df 2 frames /usr/local/lib/python3.6/dist-packages/pycelonis/objects_base.py in get_data_file(self, pql_query, file_path, export_type, variables) 647 648 if r[exportStatus] != DONE: > 649 raise Exception(f"Export failed. Status: {r} \\n\\n Query: {pql_query}") 650 else: 651

How can I connect 1 table( that connects all recored time) to two different tables? We have a ServiceNow Timecard table which stores all worked time on a task. But time can be spend on a request record as well as the underlying request task record. Im intressted to know how much time is spend for an request (taking time worked into account for the request record as well as the task record for the request) image1199680 43.2 KB The error i receive is: Data model load failed during load to engine: Could not load data model. Load failed. Error Message: Cycle in table joins detected. Cycle is within these tables: [sc_req_item, sc_task, time_card]. Celonis Support ID: ecb1aec8-c71d-42e8-bd91-41927de8ac51 It looks like Celonis is supporting a multiple table connection (I can make 2 different key relationships). Is this correct?

The ACTIVATION_COUNT operator returns for every activity in every case, how many times, at a given point in a process this activity has already occurred. Is there a similar function that counts how many times the activity occurred for every case? 2020-09-01 14_46_43-11 AP First Time Right _ Process Analytics780228 5.03 KB 2020-09-01 14_46_35-11 AP First Time Right _ Process Analytics803138 2.45 KB E.g. in this case, I used ACTIVATION_COUNT for the repetitions. Now the #2 is actually the total number of cases, as it means 2x at this point but it might be more. Is there a way to show when the activity happened exactly 2x (so exclude 3x, 4x, etc.) Thanks!

Hi all, in our P2P analysis we used to filter based on PO Header creation date (EKKO.AEDAT). However, it would be more precise to filter based on PO Line Item creation date. Looking in our SAP table for PO Line Items (EKPO), the date which is available in EKPO is always the last update date (which is not necessarily the line item creation date, in case there are changes in the PO line item after the creation). Thus, we have to also look at the CDPOS and CDHDR tables in SAP to see what kind of change have been done for the PO line item (> Insert = PO line item creation date; Update = change date after PO line item creation date). As we are not having CDPOS and CDHDR tables in our P2P data model, we are now using a date picker with the formula _CEL_P2P_ACTIVITIES.EVENTTIME. However, by doing so we would need to add component filters or an Analysis script in order to consider only the activity Create Purchase Order Item for the event time (FILTER _CEL_P2P_ACTIVITIES.ACTIVITY_EN = Creat

I want that, when filtering a process using the Crop Selection, that the Throughput Time displayed for a Case is calculated considering the first to the last filtered Activity. I tried to do this using the Standard Components, and realized that it calculates the Throughput Time of the whole Process and not just the filtered segment. How do I set this up?

Hello, I am trying to refer to a minimum value of a calculated KPI and calculate another KPI. In this case I am looking at minimum cost and calculating Potential savings. Is there a way to do this? the min function only works on columns as far as i know

Hi team,i am trying to write a CASE WHEN statement for a process explorer to show only the activities that satisfy a dropdown filter based on multiple selections.Sample dataset:(Case ID, Activity, Source,)Case1, Activity 1, Screen1,Case1, Activity 2, Screen1,Case1, Activity 3, Screen2,Case2, Activity 2, Screen1,Case2, Activity 4, Screen1,Case1, Activity 5, Screen3I would like to be able to filter in a custom process explorer the activities only from a particular screen (e.g. filter dropdown: Screen1 and Screen 3> only Activities 1, 2, 4 and 5 are shown on the process explorer).My current query doesnt allow me to select multiple conditions, and doesnt work with the IN function as well:CASE WHEN BOOKS_USER_05JUN.SOURCE LIKE <%=Source_Process%> THEN BOOKS_USER_05JUN.ACTIVITY ELSE NULL ENDBest,Dominic

Hi Team,I am trying to calculate the touchless order where have defined in dimension1)COUNT_TABLE(VBAP)in KPI section have defined SUM(CASEWHEN (PU_COUNT(VBAP,"_CEL_O2C_ACTIVITIES".USER_TYPE,"_CEL_O2C_ACTIVITIES".USER_TYPE IN (<%= AutoTypes %>)AND _CEL_O2C_ACTIVITIES.ACTIVITY_EN IN (<%=AutomationActivities%>))= PU_COUNT(VBAP,"_CEL_O2C_ACTIVITIES".USER_TYPE, _CEL_O2C_ACTIVITIES.ACTIVITY_EN IN (<%=AutomationActivities%>)))THEN 1.0ELSE 0.0where AutomationActivities and AutoTypes defined in varibaleAutoTypes has only A which is manual so ideally i want count of records which are manually done and will be calculating touchless based upon the below logictotal number of SO item-(KPI logic- count of manual orders)But am not able to get the count , could you please check and help me on the same.

Hi there, while pushing a dataframe into a datamodel i got the above mentioned error. By checking the parquet_utils.py and a quick research I found out that this (skipna) argument is obsolete and no longer supported. Iam using python 3.7.6, panas 1.0.1 and pycelonis 1.2.8 Is there a workaround for this issue? Best regards, Eike

Hi All,I would like to use a static variable for a % calculation, so that when filters are applied, the denominator will stay static. The issue that i am facing is that i would like the static variable to be static based on the local market and not the sum for all local markets.Such as below:Please let me know if this is possible using the static variable, and if not, please advise if there is another way i can achieve this.All the best,Anna

I have a question regarding the usage of PyCelonis for a single user account with Celonis 4.4. In the documentation it says that PyCelonis allows for a connection with the IBC and CPM4.5.Are there other options for the single user license to extract the analysis details in python?

Hi everyone! I would like to build an analysis focused on the vendor master data I would like to show the vendors who are NOT flagged for deletion but at the same time had NO activity in the last 24 months (no invoices) Any ideas how to pt together this data? Thank you very much Tatiana

Hi Team, We are trying to identify and associate flag to a particular activity based on whether there were some other set of activities post it or not till the next instance of the activity. So for example we want to associate a flag to Activity A if in a case journey activity B, C, D or E are occuring any time between the next occurence of Activity A within the case. We intend to track this for each instance of activity A taking place within a case and associate a flag whether the activities B,C, D or E took place or not in an OLAP table. We are looking for any way in which we can set the scope from the instance of activity A taking place till its next instance and check within this scope whether the other activities took place. Thanks in Advance. Soham Potdar

Hi Celonis experts, I am trying to understand what columns are picked up from a table when i do a Count_table(EBAN). When i tried doing, COUNT_TABLE(EBAN) results are 22531. However, when i try to achieve the same with any column in EBAN table, the values are not matching. Thanks in Advance!

Hello,ive the following issue:The PQL Formula Ratio of Cases flowing through a dedicated activity is used to determine the % of cases that do contain activity Remove Delivery Block. Putting this formula into a number element - works fine. Shows 20%.The same 20% appears when the activity Remove Delivery Block is marked in the process explorer.In my example i have 340 cases, where 68 do have Remove Delivery Block.The 340 cases to have 4389 activities in total, the 68 cases having the acitvity Remove Delivery Block do have 1229 activities.If the KPI Ratio is put into an OLAP Table and shown with dimensions like Company or Sales Org the Ratio moves from 20% to 28%. I figured out that the formula is changing from a case % (68 out of 340) to an activity related calculation (1229 out of 4389) - this does always happen if any characteristic that is joined to the activity table is shown in the OLAP Table.In addition - the same applies - the other way around if sum(vbap.net_order_value) is takin

Hello Team, I have query and have attached a picture of it in this Topic. While running simulation, I have observed that the beads move from one activity to another but have different sizes. Can you please tell me what does the different sizes of the beads technically/functionally mean(image attached). I was assuming that the size of the beads should be uniform as it indicates individual cases. Please correct me if Im wrong.Thank You. Warm Regards, Jayanta

Hi Team, I am new to this Celonis, i have a doubt like can we export the workspace analysis which we created in Process analytics to PDF or PPT format. can anyone please clarify my question. Thanks in advance. Regards, Raghu

Hi,everyone, I created an analysis using boxplot, but the filter didnt work well. PQL statement Column chart DimensionHOURS(PU_FIRST(casetable,activityTable.EVENTTIME)) KPICase Count TPTAvg. AVG(CALC_THROUGHPUT(CASE_START TO CASE_END, REMAP_TIMESTAMPS(activityTable.EVENTTIME, MINUTES))) Boxplot Distribution AxisCALC_THROUGHPUT(FIRST_OCCURRENCE[<%= From %>] TO FIRST_OCCURRENCE[<%= To %>], REMAP_TIMESTAMPS(activityTable.EVENTTIME, MINUTES)) From,To Activity name Dimension AxisHOURS(PU_FIRST(casetable,activityTable.EVENTTIME)) image20641236 131 KB If I selected 11 on the column chart, I assumed that the boxplot also shows 11. However, it is displayed 0.Same for other values image20631246 136 KB Is it IBCs specification? Or something wrong with my PQL statement? Best regards, Marie

Hello Everyone,I need some assistance on the below.Im using a table(Tab1) with 2 million records. Im looking for Purchasing Document Number (EBELN) which has more than 1 entry and i need the count of Unique Document Numbers and the count of Documents having more than 1 entry.Im using the below Case statementCASE WHEN COUNT (DISTINCT Tab1. EBELN) > 1 THEN 1.0 ELSE 0.0 ENDthis gives me 1 if the record is unique and 0 if not unique.I need the total count of uniques & non uniques. When i try the below im getting an error saying Aggregate expressions cannot be nested.SUM ( CASE WHEN COUNT (DISTINCT Tab1. EBELN) > 1 THEN 1.0 ELSE 0.0 END )Appreciate the assistance.Thanks!!Regards,Chanti

Hello everyone,i was wondering whether CALC_CROP functions with PU_FIRST or PU_LAST.what I want is to count a number of specific activities between the process start to one of the other activities (whichever of them comes first);so i would like to use smth likePU_COUNT(CASES, ACTIVITIES.ACTIVITY,ACTIVITIES.ACTIVITY IN (A,B,C,D) ANDCALC_CROP(CASE_START TO PU_FIRST(CASES,ACTIVITIES.ACTIVITY, ACTIVITIES.ACTIVITY IN (E;F;G)), ACTIVITIES.ACTIVITY)=1))however it doesnt work. Any ideas?Best,Maria

Hello All, Please is it possible to use the LIMIT or TOP X keyword in a PQL statement.

Hi team, Does Celonis has the ability to consume on live data and give the insights?