Product Q&A

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

Hi I am Having Enterprise Trail Cloud, when iam giving my Credentials it is showing me Invalid Credentials . Please help on connecting it .Thanks

Hi, I am trying to solve a case. How to count numbers (MAX and MIN) of events in single KPI. Need to know how many events take on one user. I have two users. They have different numbers of events min 1 and the other one max 20. I need to make a count of events per user to get max 20 in single KPI. I tried to use a standard KPI maximum events per case but it is not what i need. 2020-07-30_12-57-17769203 9.74 KB

Hi, we are developing a usecase in which we want to automaticaly import a csv / excel on daily base from a fileshare. Until now we have only worked with scheduled databse connections or manual file upload. Is there any possibility to automate a daily csv import into a datamodel? kind regards Benedikt

Hey Guys, I had a quick question about filters on Pull up functions. I am trying to create a dashboard that displays Sum of spend by vendors. But i do this by Pull up function (because I use it as a dimension to categorize). I know we can put filters on the pull up function PU(child table, parent table.column [,filter expression]). My question is can we put more than one filter in the expression? I want to be able to filter for the month and year. I was able to filter for month but couldnt filter for year. Is there any way to put filter for year and month in date format ? Because I want the user to be able to input year and month to display information

Hello Everyone,I would like to create a table that list all the variants and then for each variant calculate how many unique activity there is.example,Variant acitivity countstep1,step2,step3 3step1, step3 2thank you for your help.regards

Hi Team,This is my first post. Please let me know if this is not the place to post a question like this. I need help with a statement.I want to know how I can convert this statement: max("_CEL_AR_ACTIVITIES"."_CELONIS_CHANGE_DATE") to a timestamp in CST. I have put this in a text component.The statement above works, but I have to keep telling my users that take that time and minus 5 hours. It always causes my team to break for a second and do that math, :).I would like it if I can just have it converted to CST if possible. Thanks in advance.Paresh