Data Ingestion & Infrastructure

Dear Celonis Community I am trying to prepare for Accounts Parables an analysis which would show the cancelled invoices. in my process explorer i dont have a dedicated activity Cancel Invoice How would you ensure to show them, what specific filters would you apply? Thank you Tatiana

Hallo, I am looking for the operation guide for IBC Celonis. I have found the operations guide for 4.3 but nothing for the cloud. I am looking for the solutions for SSO, Monitoring Solutions, Version control etc. There are some help pages about SSO but really rudimentary. Is there any pdf/documentation where I can find the topics. Many thanks in advance. Greetings, Ula Jessen

Hi to everyone, Im looking for info (links, books, Excel Models and/or counsels) about ARIBA Data model, for training pourposes. Im interested in Tables and Fields of the transactional Core in order to training a Model. Thanks in advance to anyone that could help Alfonso Fabra Nodotic (Spain).

Dear Community, Im currently working on setting up data permissions on IBC. They work as excpected, but that is somehow a"problem" as well. Heres an example of my data model: grafik835223 5.33 KB The two tables are linked via two columns, a company code and an event id. Additionally, the two tables have a 0-to-many connection, meaning that there can be cases without a connection to the events table, and vice versa. I want to set up data permissions based on the company code. As far as I understand (and validated during testing), data permissions are always AND connected, and the tables are always inner-joined This means, when I set up data permission on column cases.company code, I will not be able to see the events x,y,z, because theres no respective case for them. Vice versa, setting up data permissions on events.company code, the will not be able to see case id 4, because theres no link either. Setting up data permissions on both tables will not lead to any other result du

Hello dear community,when creating my event log, question marks appear unexpectedly in the ID column. This makes it difficult to write the code. Can anyone help me what this might be due to?Thanks for any help!!

Hi Team,We are currently trying to use round_week() function as a dimension. However, I see the function would aggregate the week values starting from Monday to Sunday as a week.Is there a possibility where I can represent the week to start from Saturday and end on Friday and aggregate the weekly values as per the same?Thanks in AdvanceSoham Potdar

Hi ,I would like to know if there are any provision to consolidate the date for the specific date slice to use in the dimensions . For Eg 5 days or 3 days custom grouping etc .I require the functionality similar to ROUND_WEEK() to group date but i should be able to group based on the custom logic of 5 days or 3 days etc for the date range .Thanks ,Praveen

Hi Team,In the ML workbench, we are trying to pull data of a component from a particular analysisThe code that we are using is not able to pull data from some particular analysis. However, if we use the same code to pull the data from a different analysis belonging to the same workspace we are able to pull the data.Are there any Analysis settings that we need to look into for the data pull that might be causing this error.We are getting the following error while pulling the data from the analysis.image571669 70.7 KB

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?

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

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