Product Q&A

I would like to see the workflow of 2 different task tables from SN in Celonis. The Case table and the case_task table. The issue i encounter is that the dimension Roundmonth (case record created) does a auto join for the case and task table (sounds logic). But all i want is a simple "excel"table to track the records. How can i show the trend of 2 different tables based on both their creation date?

As the title says, exporting a chart that scrolls to PNG only shows the area that is captured within the current window. Is there a way to have the exported PNG show the entire chart? CPM_OLAP_Table_20200902_152303|690x141

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

Trying to create a KPI for my column chart, where I would count only those cases for which a specific condition is met. In particular, I want to count the number of SO Items (COUNT_TABLE(VBAP)), which were created via EDI (VBAK.BSARK = DFUE). Tried this statement, but getting an error: CASE WHEN VBAK.BSARK = DFUE THEN COUNT_TABLE(VBAP) ELSE NULL END Error: image77760 4.71 KB Dimension is ROUND_MONTH(VBAK.ERDAT) if that makes the difference. UPDATE: in addition, important that in the end I want to show on the same column chart also the number of SO Items that were created not with EDI. I.e. I want to have a stacked column that consists of all SO Items and I see the part with EDI and the part without EDI. Help appreciated! Regards Masha

In the OLAP I can see the particular field has null value, but selecting the same value resulting the OLAP to show no rows.

Hi everyone, I am trying to write a load script that would incorporate the below logic, and I am confused with the syntax. Will appreciate any advise. Analyzing SAP O2C process. Logic: If SO Item is for defined materials then this SO Items should be included without any additional filter. If SO Item is for any other materials (not from that defined set), then for those SO Items additional filter should apply. Materials that should go without filter: EDIDUMMY, ILODUMMY For every other material I want to exclude those where there is a reason for rejection: ISNULL(VBAP.ABGRU) = 1; I tried to write something like this, but after I try to save the script analysis keeps loading forever, so I guess something is not working with the filter: CASE WHEN VBAP.MATNR IN (EDIDUMMY, ILODUMMY) THEN FILTER 1=1 ELSE FILTER ISNULL(VBAP.ABGRU) = 1; thanks Masha

Hi all, I have a process with parallele sub processes. As Celonis doesnt display theses sub processes my idea is to remove the activites related to these sub process in the analysis. So how is it possible to easily remove activity in the analysis (keep all the cases with or without this activity but just remove the activity)? I could do that by removing the activity in my csv and reload it but I wanted to know if there is an easy way to to that in Snap (by exemple in using the Activity filter, but this filter will filter the cases and not remove the activity). Thanks all for your help Nico

Hello everyone, Im currently working on an analysis for viewers which is going to be exported as image, a stacked area chart in the date range of a year. Now to my problem: Their requirement is that every workday has to be shown in the diagram, so the dimension axis gets unreadable because of the amount of dates displayed: (part of the diagram with the date range of half a year as example) Is there any way to only display every second or third label on the dimension axis so it looks less cluttered and more readable? Ive looked through the component options but couldnt find anything related exept the tick count, but that doesnt help me for this case. Best regards, Nils

Hey all, I want to count cases where an article number is just present in one table but not in the other example TableV1 ArtNr 1 3 4 5 7 9 TableV2 1 2 3 4 5 6 7 8 9 10 Count cases which are in TableV2 but not in TableV1 (Null). In that case 2, 6, 8, 10 -> Count = 4 Thx and br Daniel

Hey pros, I want to upload lots of table with the same columns, like article number and price. To select which version/table should be analysed I want to setup a variable with the name of the table. Example: Currently COUNT(DISTINCT SupplierA_v10.csv.Teilenummer des Lieferanten) Should be something like that COUNT(DISTINCT " || <%= Name_Update %> || .csv".Teilenummer des Lieferanten) Do you have any ideas how to set this up? Many thanks ahead and br Daniel

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

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