Product Q&A

A few months ago it was mentioned that user/analyses stats and usage would be coming to the IBC. From the SaaS hosted version, this information is available and it would be nice to see this implemented in the IBC. Any update on this?

Hello, Can someone please help with table loader pool types? What is difference? Impact on data load? When and which type should should be used? Thank you in advance! KR, Kalpesh

Hi all, We are using a dedicated Segregation of Duties dashboard to analyze cases where two activities are processed by the same person (e.g. Creation of PO and Releasing the PO). In this dashboard, the viewer selects two activities, which shall not be performed by the same user to see in how many cases there is a violation. See here the PQL statement: avg (case when PU_first(EKPO,"_CEL_P2P_ACTIVITIES".USER_NAME, _CEL_P2P_ACTIVITIES.ACTIVITY_EN = <%=From%> AND _CEL_P2P_ACTIVITIES.USER_TYPE <> B) = PU_first(EKPO,"_CEL_P2P_ACTIVITIES".USER_NAME, _CEL_P2P_ACTIVITIES.ACTIVITY_EN = <%=To%>) then 1.0 else 0.0 end) * 100 By checking the violations in detail, Ive recognized that there are cases where Person A creates a PO, Person B approves the PO and afterwards Person A changes some field in the PO (e.g. Net Order Price). Due to this change, the release indicator is AUTOMATICALLY changed from B (release) to R (not released). This case is shown as a viola

Hello Celonis Team, is it possible to use celonis on iphone or ipad? Could you give me some information about the mobile view from celonis. Many thanks

I am trying to convert the data present in an OLAP table to a dataframe.c = get_celonis(**settings)w = c.workspaces.find(KPI Analysis - CSAT,None)a = w.analyses.find(CSAT Model,None)q=a.published.components.ids[7ae951ac-b933-4e62-b8c0-ee21e6a15845].dataCan anyone please help me what can be the command to convert q into a dataframe.Thanks!!

Hi, I would not use VBAP.NETWR_CONVERTED and have the Net Value Order in the Document Currency. When I insert as KPI VBAP. NEWTR, I would like to insert in Units the Document Currency. I tried with: VBAP.WAERS<%=VBAP.WAERS%>a variable : VBAP.WAERSa variable : {VBAP.WAERS } But it is not working. Any idea ? Thank you

Dear Community, We are trying to understand the Data model status option Reload all partitions. We have tested this option with one data model and the data model load completed and the remaining data models load not started automatically. Could anyone explain this option Reload all partitions! data model - reload all partitions.png1588506 40.7 KB

Hello, I would like to create a table with a count of variants by Company Code but when I use the standard KPI Number of process variants, the number not corresponding to the total I have on the Variant Explorer. Is it exist a simple formule to count the variants? Thank you

We have seen that there are some of the KPIs which has to be recreated in different analysis , may be becuase of data security. Role based access etc. Wouldnt it be nice that we have an App as Global KPI where we can drag and drop the KPIs which are used in different analysis and control where we would like to manage it. With that, any changes done to KPI is reflected across different analysis. This removed redudance of work, eliminates human error. Also managment dashboard and operation dashboard has the same calculations of the KPI.

Hi All, Do we have any use cases for Application Monitoring tools such as Dynatrace. Can we get a process-level view with metrics of applications to see which application/interface is down because of which the process has stopped ( in real-time ). Regards, Rakesh Paul

Hello Celonis Development Team, Thank you for developing such a fantastic product. . I am a big fan already. Please share your opinion on having the following new features: Button - An option to show or hide one or multiple components. This will help us use the space for more innovative analyticsButton - An option to change the chart type of an existing component.Charts - The Series color mapping - options are limited and apply to all the series points. Instead, we should have a free code window wherein we can put codes to calculate color thresholds.The grid to put any component on the screen should have small steps giving freedom to arrange components more aligned. Thank you Regards, Sachin

Hello Community,We are developing a new algorithm to help users detecting duplicates.As an inspiration we toke the blog: Celonis 5 Steps to Reduce Costs Caused by Duplicate InvoicesCelonis customers have already saved millions by taking action on duplicate invoices. Find out how to how to use fuzzy matching to find duplicates and save money using the Celonis Intelligent Business Cloud and Python. We have noticed that the algorithm detects false positives. In the algorithm, this might happen because we do fuzzy matching and searching. Now the users like to flag these false positives in the sheet. Moreover, they want the flags they made to be visible for other users using the sheet. How would you implement such a flagging system?One idea we had was creating an additional column in the table that can be adjusted by users in the frontend. In this way, the adjustments could be visible for all the users. Does somebody have any idea whether this is possible?Happy to hear your thought

Hello everyone!Ive got some trouble with unique case aggregation. Ive got case table with column Amount, and events table with status of process. I want to build table wich consist of some columns from case table, avg timestamp between two activities, and sum (casetable.amount).So, I build filter on list:FILTER PROCESS EQUALS (X) TO (A) ;And filters on component(Table):FILTER SOURCE(Celonis_events.activity) LIKE (X) ;FILTER Target(Celonis_events.activity) LIKE (A) ;Next, i build table dimensions:CELONIS_CASES.BUNAMECELONIS_CASES.GJAHRSOURCE(CELONIS_EVENTS.ACTIVITY) - not visibleTarget(CELONIS_EVENTS.ACTIVITY) - not visibleAND KPIS of table:AVG(TARGET(REMAP_TIMESTAMPS(CELONIS_EVENTS.EVENTTIME, MINUTES)) - SOURCE(REMAP_TIMESTAMPS(CELONIS_EVENTS.EVENTTIME, MINUTES)))2)SUM(CELONIS_CASES.AMOUNT)All good, but if within one case we got more than one change status from (X) TO (A) activities - we got (CELONIS_CASES".AMOUNT)*(Count of (X) TO (A) ) and its wrong, because case got fixed amoun

Hello, I am trying to calculate the average number of posted invoices per user in a number component in the AP data model. The basic code of the KPI looks as follows: COUNT(BKPF.USNAM) / COUNT(DISTINCT(BKPF.USNAM)) The current KPI however does not yet show the real performace of the AP department because many invoices are posted via batch files or batch users and some invoices are posted by users that are doing an internship or an apprencticeship and these users do not post more than for example 100 invoices. In order to get rid of the cases which were posted by batch users, I used a component filter which works fine. But for the second issue (exclusion of cases which were posted by users that have not posted more than 100 invoices in the selected time range) I have not yet found a solution. I have tried several case when statements and also worked with ABC clusters to exclude the cases of these users, but nothing worked. Does anybody of you have an idea how this could be solved? I am

Hi all, We have implemented a new system, which has different activities names. I would like to have one graph, where the graph shows the data from one activity, and after a certain date (01-09-2019 (dd-mm-yyyy)) from an other activity. Using now the following formula in two different graphs, but I would like to combine them. AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[Ontvang Factuur] TO LAST_OCCURRENCE[Valideren Factuur], REMAP_TIMESTAMPS(XXCEL_AP_ACTIVITIES.EVENTTIME, HOURS))) AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[XXAIMG: Ontvangen in APRO Imaging] TO LAST_OCCURRENCE[Valideren Factuur], REMAP_TIMESTAMPS(XXCEL_AP_ACTIVITIES.EVENTTIME, HOURS))) Is this possible? Hope you can help me. Kind regards, Jelmer

Hello all, I wonder if there is a way of combining the CALENDAR_WEEK() format with the YEAR() format similar to the way the statement ROUND_MONTH does for exmaple. The problem I have with the calendar week as the dimension is that in case of a dataset that includes data from more than one year, the KPIs do always calculate the data of all years for each calendar week while I would like them do distinguish between the weeks of the particular years. Best regards, Maximilian

Hi everyone!I want to build a pivot table with year as pivot, month and day as dimentions and the KPI that counts distinct CASE_IDs within the day but just simply sums them up for month or year.So my daily KPI looks at the moment likeCOUNT(DISTINCT (CASE WHEN table1.Activity1"=A then table1.CASE_ID ELSE NULL END))The problem is that I want a simple sum of daily counts for the months and years result. Is there a way to aggregate the values by day in the formsum(for each day COUNT (DISTINCT (CASE WHEN table1.Activity1"=A then table1.CASE_ID ELSE NULL END)) )?Thanks!Best,Maria

Hello, I got a question again I try to do an OLAP table where I need to combine data from different tables. I try to explain the case as good as I can. In my table T052U_BSEG I got the column named TEXT1 (here is a description in each column) and the column ZTERM (here i an ID which is unique for each different description, but a description can come up multiple time). On the other hand I got the table PB_CLAR where I got two columns with the IDs from ZTERM in it. I want to create a column in an OLAP table that the ID in PB_CLAR look up the ID in the T052U_BSEG and pull the right description from TEXT1 Thank you guys in advance

Hi all, Id like to analyse the number of PO items which have been created for one and the same PR, e.g. PR 12341234 is related to 5 PO items. I tried using the pull function but always when combining PO item data with PR data from table EBAN I get following error message: Undefined exception occured. Table EBAN is not a parent of EKPO. Use non pull up function instead. I guess this should be an easy formula but unfortunately didnt figure out how to achieve the result Im looking for. Any ideas? Thanks, Oli

Hello, Good day. We had setup a continuous data flow connection from PROD SAP ECC to Extractor Server to Celonis IBC. When running the extraction, we are encountering this kind of error. Metadata changed for table BKPF. Datatype of the column REINDAT changed from DATE to STRING. See screenshot below: CELONIS_IBC_DeltaLoadError3.PNG1080233 51.9 KB Weird thing is when we use the exact same data pool pointing to the TEST SAP ECC system, the extractions works. Would anyone know what is causing the issue and how to solve it? Thanks, RJ

Hello, We are trying to connect IBC to SAP ECC hosted by the client. We successfully connected the extractor server. Upon keying in the SAP configurations then clicking on Save, we are prompted by the error message: Connection test failed, please check the Data Connections configuration and ensure that the system is running: Error invalidating caches: Initialization of repository destination [host]-[system number]-[client]-[user] failed: Password logon no longer possible - too many failed attempts on [host] sysnr 00. What is the root cause and how can this be solved?

Hello. I want certain activities always displayed in Process Explorer. Im tackling web access log with Celonis. CVR (user ratio who apply to our service) on our website is lower than 1%, so conversion activity is very rare. When I want to see conversion activity in PE, I must adjust the slider of activity up to almost top. As you know, when I do that, the process view get complicated with other unwanted activities. I want to keep the slider of activity low with arbitrary activity always displayed. Is there any way to do that? Thanks.

Dear all, How can we calculate a throuput time between 2 activities, but only when the activities are directly linked ? An example: I need to calculate the lead-time in orange. With this formula the result is not correct, because there is an other A2 activity later in the process (it could also happen that this additional A2 activity, not directly coming from A1 occurs before in the process) AVG(CASE WHEN (PROCESS EQUALS A1 TO A2) THEN CALC_THROUGHPUT(FIRST_OCCURRENCE[A1] TO LAST_OCCURRENCE[A2], REMAP_TIMESTAMPS("_CEL_ACTIVITIES_NC".EVENTTIME, HOURS)) ELSE NULL END) Thank you for your help, Best Regards Robin Celonis_Help.png87681 1.94 KB

Hi all, were currently only considering user types to define which activities have been done automatically (batch user) and which have been processed manual (all other user types): 100.0*AVG(CASE WHEN _CEL_P2P_ACTIVITIES.USER_TYPE IN (<%=auto_user_type%>) THEN 1.0 ELSE 0.0 END) However, for our MRP runs which shall be also considered automated there is always a manual user in SAP. We can identify MRP runs by the doc type (EP) in combination with the PR creation indicator (B). Any suggestions how we can adjust above formula to also consider EP in combination with B as automated? Thanks Oli

I like motorsports, I like car racing, I like to go to race tracks or watch races on TV. So I thought "How cool would it be to analyze Formula 1 seasons, races, and drivers like polish Grand Prix legend Robert Kubica? Although Im a Celonis employee, I of course couldnt use the software for private purposes like this. However, that changed with the release of Celonis Snap, which is free to use for everybody. Heres how I created this Analysis using my personal Snap Account. First of all, I needed to get data. I found a very nice dataset on https://ergast.com/mrd/db/ . The dataset consists of multiple tables containing up-to-date F1 race data from the very first Grand Prix in 1950 until today. I created the tables in my Postgres database based on the schema information provided on the website, and dumped the csv files into it. I dumped them into a relational database instead of uploading them directly to Snap because I needed to do some transformations before, for example, I wanted t