Product Q&A

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 st

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

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 Ti

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___P0

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

Hello Everyone,We have some KPIs which are the result of a Criteria over the population. I.e cases that follows directly from process A -> B DIVIDED all the cases that went through AThere are cases where the numerator and denominator are Zero , Celonis manage 0/0 as NULL which is correct, but for my KPI I should present either 0% or No Activities instead of -Can you please advice the effective way to manipulate the output of the KPI to manage the Nulls?Regards,Example:SUM(CASE WHEN BKPF.AWTYP IN (BKPF, BKPFF, BKPFI, IBKPF, TRAVL)AND BSEG.BSCHL = 31AND PROCESS EQUALS Invoice posted TO Pay InvoiceTHEN BSEG.WRBTR_CONVERTEDELSE0.0END)/SUM ( CASE WHEN MATCH_ACTIVITIES(ENDING[Pay Invoice] ) = 1AND BSEG.BSCHL = 31AND BKPF.AWTYP IN (BKPF, BKPFF, BKPFI, IBKPF, TRAVL)THEN BSEG.WRBTR_CONVERTEDELSE0.0END)

Hello,we want to add two dropdown filters to select purchase order items by creation year.One by calender year and one by fiscal year.The one for calender year would just be YEAR(EKKO.AEDAT).For the fiscal year the dropdown option 2019 should contain all purchase order items with EKKO.AEDAT between 1st of May 2018 and 30th of April 2019 and so on. Can this be implemented?I tried the following, but the error not implemented yet appears.CASEWHEN EKKO.AEDAT BETWEEN 2018-05-01 AND 2019-04-30 THEN 2019ELSE END

Hi there,Im getting the wrong values in two different cases when Im dividing in celonis:Case 1:(Sum(CASEWHEN ((EBAN.MENGE)/(EKPO.MENGE)) < 1 THEN 1ELSE 0END)+Sum(CASEWHEN ((EBAN.MENGE)/(EKPO.MENGE)) > 1 THEN 1ELSE 0END))/(1.0*COUNT_TABLE(EKPO))Individually the first sum evaluates to 455. The second sum evaluates to 249. the numerator is then 704. The denominator comes to 3555.The output should then be 704/3555 = 0.19803But the output on Celonis is 0.2068762Case 2:SUM(CASE WHEN ISNULL(EBAN.FLIEF) = 0 AND EBAN.FLIEF != EKKO.LIFNRTHEN EKPO.MENGEELSE 0.0 END)/SUM(EKPO.MENGE)The numerator comes out to 4069455The denominator comes out to 1521749967The result should be 0.0026741The result is 0.0077356Any ideas whats causing the wrong values?

Situation: We have a data model with an activity table, cases table, and some other tables.Problem: We would like to only consider those records in the cases table for which an activity exists.Details: This works if both tables are used in the same component, because in the backend the tables are automatically joined from activity to case (left join). However, when for instance counting the number of cases (count_table(cases_table)) all cases are considered. We therefore would like to set a load filter or pinned filter that filters out those cases for which no activities are recorded. Any ideas on how to do this???Ideally we would also like to automatically filter our other tables to only keep records linked to an activity.We are coming from a single table setup where all tables where joined into one large table. This problem did not exist then, but performance (especially when reloading) was sub-optimal. The new setup performs better,

Hi Celonis Community, were currently using Celonis 4.5 and have a large number of projects. At this point it would be very helpful to be able to search for a certain project. Unfortunately the search only supports folders, analysis and data models within the projects. Have I overlooked a way to do search projects? Otherwise Id appreciate some feedback if others would find this helpful as well. Best, David