Product Q&A

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?

Hi!Im trying to calculate how many cases have a certain activity less or more than X times, etc.I have this table A which shows number of cases that have a certain activity, and total sum of this activity. As you can see, the activity is repeated many times in a few cases.I want to separate in ranges, Im using this formula but I get the total number of activities and not the number of cases. (Table B)SUM(CASE WHENPU_COUNT("_CEL_PS_PO_LINE", CEL_P2P_ACTIVITIES"."ACTIVITY<%=language%>)<=10 THEN 1.0ELSE 0.0 END)Could you please help me know what Im doing wrong?Thank you!Table ATable Bimage1044173 6.21 KB

Hello, We are running a number of Data Jobs, including Extraction and Data Jobs, can we get the alert of the log either successful or error message in our mobile. We are getting the data in our mail.

Hi all, How to change the team name on Snap? I saw under Team settings > Settings that it is possible to change the team name but it always roll back the change. In fact I have a team with my personnal name and I want to change it with my enterprise name. Could anyone help? Thanks Nico

Hello, I dont know why everytime I try to use the Process Explorer in my analysis I cant show the automation rate of the activities. Every time I insert a Process Explorer component it appears without the Automation KPI. I tried to set it up by myself in the Analysis Settings, Process Explorer KPIs but probably I dont use the right code Should I also include some formulas in Saved formulas & Variables ? If yes, which ones? Many thanks for your precious help

Hello,were using a formula to determine if only one specific field has been changed or if other fields have been changed as well.CASE WHENPU_COUNT ( VBAP, _CEL_O2C_ACTIVITIES."_CASE_KEY", _CEL_O2C_ACTIVITIES.CHANGED_FIELD = <%= Block_types %>) -PU_COUNT ( VBAP, _CEL_O2C_ACTIVITIES."_CASE_KEY", _CEL_O2C_ACTIVITIES.ALTERNATIVE_TREE = Change Management) = 0ANDPU_COUNT ( VBAP, _CEL_O2C_ACTIVITIES."_CASE_KEY", _CEL_O2C_ACTIVITIES.ALTERNATIVE_TREE = Change Management) > 0THEN Block OnlyelseCASE WHENPU_COUNT ( VBAP, _CEL_O2C_ACTIVITIES."_CASE_KEY", _CEL_O2C_ACTIVITIES.CHANGED_FIELD = <%= Block_types %> ) > 0THENBlock and other changesELSE Only other changes or no change ENDENDThe formula works fine, but if the variable <%= Block_types %> is changed to a different fields , the formula is not getting updated when used as a filter criteria. It seems that the temporary tables generated by the PU_COUNT are not dropped. Only if the fil

Hello everyone,I have 2 activities, A and B and I would like to calculate the throughput between them. It can happen, that A and B appear multiple times but B always appear after A;so I am interesten in the pairwise calculation of the throughput time (and average of that).Example:F-A(1)-C-B(1)-A(2)-B(2)-N-A(3);In this case I need the average time between A(1)-B(1) and A(2)-B(2).any ideas?Best,Maria

Hello. I am wondering if Celonis has exam simulators to practice before one seats for a certification exam. I think it would be very useful. Thanks.

Hello, I am getting the error message could not locate column in table while reloading the data model. However, the column is in the view, I have checked if I am using the correct source table and if the columns are synchronized (all ok). What else could be the root cause of this error? Thank you. Kind regards, Lenka

Dear Celonis Team, were currently working on connecting a Sybase ASE database via the IBC Uplink Connector. Weve noticed, that the configuration of the tables in the extraction in some times takes ages. In the extraction configuration, clicking on a large table with lots of rows the settings pane for that table (like filter settings and column selection) takes minutes to load or doesnt load at all. Turning on the Debug Mode for the extraction reveals why that is. Looking at the log files on the uplink server, the following lines apper once I select a table in the IBC frontend: 2020-07-22 15:33:21.777 INFO 4508 --- [ol-2-thread-105] c.c.c.j.s.DatabaseConnectorService : Metadata source being used is DRIVER_METADATA --EOM-- 2020-07-22 15:33:21.777 INFO 4508 --- [ol-2-thread-105] c.c.c.j.s.DatabaseConnectorService : Calling DatabaseMetaDataService#getMetadata for table dbo$_CELONIS_wo_transfer --EOM-- 2020-07-22 15:33:21.777 INFO 4508 --- [ol-2-thread-105] .c.c.j.s.m.Dat

Hello Team, Im creating a new Table in one of the Transformation Tasks of my data job. While creating the table, I want to define the primary keys. Can you please guide me, how to do that. Thank You in advance. Warm Regards, Jayanta Borkakoti