Product Q&A

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

Hello!For the sake of performance analysis, I want to create an OLAP table to cover the following aspects of a certain part of a process (Activity 1 -> Activity 2):PerformerTaskThroughput time, daysPercentage from a total workloadATask 1520%ATask 2180%BTask 1120%BTask 2270%BTask 3710%There are a number of encountered problems however.First, a standard THT KPI formula calculates only a difference between FIRST / LAST occurrences of an activity, thus it does not work for measuring time strictly between two activities taking into account all rework and process deviations (like Activity 1 -> Activity 3 -> Activity 4 -> Activity 2 ).To overcome this issue, I used SOURCE / TARGET function, and it works when I just calculate the THT KPI only, but I have not managed to add other dimensions in the table (no common parent between tables could be found).Second, to determine the ratio of a specific task among all of other tasks I again - need to clean the number of cases as it turned o

Celonis Snap provides you with great tools to analyze your processes data. Want to take it to the next level? Then you should check Celonis Enterprise, which provides many more features for more advanced use cases. Celonis Enterprise features that are not available in Celonis Snap include: Data Uploads over 500MB: Schedule unlimited data loads as frequently as by-the-minute, or as a one-time event.Process Automation - Automatically update the data in your underlying systems to enforce optimal processes across your technology estate.Transformation Center: Track the impact of process enhancements over time. Use collaborative tools to bring your whole organization together and focus on making continuous and lasting improvements.Machine Learning Workbench: A python development platform to help data science teams create business impact by leveraging process data and the python ecosystem.

Curious what you can do with Celonis Snap? Celonis Snap is the worlds first free and open process mining software. Once you have signed up and activated your Snap team you are able to: Use our Quickstart to upload up to 500MB of your own event log data from a CSV file and start visualizing the way your processes really work. Connect your ServiceNow Incident Management Process for free and with no installation required. Gain valuable insights instantly with our pre-built Celonis for ServiceNow apps.Connecting your ServiceNow with Celonis Snap gives you: 100% Transparency: Intelligent algorithms help you to reconstruct, analyze, and understand your ServiceNow processes accurately, so you can focus on the most important areas of improvement. Reduce Ticket Volume & Resolution Costs: Enables you to identify and eliminate the root causes of inefficiencies across your entire service desk operation to decrease costs & volumes. Increase Ticket Resolution Efficiency: Solve tickets f

Creating a Snap team is really easy, fast, and free. Follow the steps below: Go to celonis.com/get-started. Once there, click on Get Snap. fwKmIPO_4O_9ZAH0JvsNqSXTskL1EmhtxQ6SJmU7bjP6MvayTzvnUfMQffIxIQN636_uwERFACVU-dl2bnrlOQr0prBZNVUVYcuXrKPHbcZvw1yZorLNqxiYHC2R9hER0VsRCcLL.png1600904 300 KB Youll be redirected to the Snap Sign-up page. Fill it out the form with your First Name, Last Name, your Company email and your Organization and click on Next. Once you have filled out your information and clicked Sign-up we will start creating your team. Dont worry, it wont take longer than 2 minutes, and in the meantime, you can watch our CEO explain the vision and benefits of Snap. Once your team is created, youll receive an activation email to confirm your team membership. Activate your team and you are ready to start process mining! PN2yWA4dZIOnHDXoiDeMZLx5XdMyAODatAJffqbeXVK4SA2I0D2wXNrztXg34Rx2zKjgfxaEzwCz8laZuxHHEBnPdnEGfW-p___P07lhAm0Qhm6KtUSNAwXFaSW83ceibygxWNwV.png1206983 62.3 KB

Dear All, We ahve a througput time caclulated as below CALC_THROUGHPUT(<%=from_occ%>_OCCURRENCE[<%=From%>] TO <%=to_occ%>_OCCURRENCE[<%=To%>], REMAP_TIMESTAMPS("_CEL_O2C_ACTIVITIES".EVENTTIME, <%=unit%>)) THis gives us througput time at line item level (Case key). How can I calculate the same at header level. Say at VBAK level. Thanks Naveen Gupta

Hi,I am trying to allow a bit of Text Mining in my analysis and do smth likeCASE WHEN table1.column1 LIKE <%=Variable1%> THEN table1.column1 ELSE NULL ENDIt works fine with a Variable defined with the help of the Variable Input component with to show thats a text piece. What I would like to do is to manually define some categories as a Variable and use them.For exampleI would like to define Categories like Green, Red and Apples (for example in dropdown) so that i can just choose them without need to type them down everytime I need.Any ideas?Cheers,Maria

Hi all, When analyzing price changes in Celonis I would like to show in our details tab the Euro amount of the actual price change per PO line. We are already using quite a sophisticated formula to show in a graph the price changes for different thresholds in percentage. I assume I can use this formula partially in order to show the Euro amount of the price change. Following part, I used to do that (which does not work yet): CASE WHEN ISNULL(PU_FIRST(EKPO,"_CEL_P2P_ACTIVITIES".ACTIVITY_EN, _CEL_P2P_ACTIVITIES.ACTIVITY_EN = Change Price)) = 1 THEN No Price Change Activity WHEN PU_FIRST(EKPO, _CEL_P2P_ACTIVITIES.CHANGED_FROM_FLOAT,"_CEL_P2P_ACTIVITIES".ACTIVITY_EN = Change Price) - PU_LAST(EKPO, _CEL_P2P_ACTIVITIES.CHANGED_TO_FLOAT,"_CEL_P2P_ACTIVITIES".ACTIVITY_EN = Change Price) END Any idea how to resolve? Thanks, Oli