Product Q&A

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

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, but apparently has its limits.PS: I feel the PQL f

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

We are looking for an option to save a selection like a variant. For e.g. Saving Sales Org, Division and Mateial groups selections as a variant. With the possibility to come back to that selection. Any suggestion, how to achieve that?

Hello Community, following config-custom.properties setting is offered: # Query Settings # -------------- # Maximum number of threads used in a query. To use an unbounded pool, use the value -1. By default, 30 threads are used. # query.parallel.maxthreads=30 How is this setting influencing a) end user (frontend) performance? b) backend ressource consumption? Is there a best practice about how to configure this setting? Best regards Sebastian

Every time an analysis is transported from QA to PROD, old analysis is deleted and a new one is placed in the folder, as a result, the bookmarks are also deleted with transport. How we can get rid of this problem.

Im trying to create a pinned filter (/selection) in a dashboard on Celonis 4.5According to the documentation (https://help.celonis.de/display/CPM45/Filter+Editor) this should work:SELECT PINNED YEAR("EVENTLOG"."EVENTTIME") AS "YEAR" = 2010;However, Celonis then reports that SELECTED is not supported anymore.I therefore triedFILTER PINNED YEAR(EVENTLOG.EVENTTIME) AS YEAR = 2010;But this does not work.How do I create pinned filters in Celonis 4.5?

Hi all, were using threshold values based on PO header level in order to filter on low or high value items (e.g. below 100 or above 10k). The formula works on PO header level (EKKO table) but should be based on line item level (EKPO) - the formula looks as follows: CASE WHEN PU_SUM(EKKO,EKPO.NETWR_CONVERTED) >= 0 AND PU_SUM(EKKO,EKPO.NETWR_CONVERTED) <= 100 THEN a) 0 - 100 WHEN PU_SUM(EKKO,EKPO.NETWR_CONVERTED) > 100 AND PU_SUM(EKKO,EKPO.NETWR_CONVERTED) <= 500 THEN b) 100 - 500 WHEN PU_SUM(EKKO,EKPO.NETWR_CONVERTED) > 500 AND PU_SUM(EKKO,EKPO.NETWR_CONVERTED) <= 1000 THEN c) 500 - 1.000 WHEN PU_SUM(EKKO,EKPO.NETWR_CONVERTED) > 1000 AND PU_SUM(EKKO,EKPO.NETWR_CONVERTED) <= 10000 THEN d) 1.000 - 10.000 ELSE e) > 10.000 END I tried to exchange EKKO with EKPO to have PU_SUM(EKPO,EKPO.NETWR_CONVERTED) but that didnt work. Any suggestions how to change properly? Thanks, Oli

Hi all,We would like to show a histogram, where the dimension is not calculated per case but per customer.Concretely, we would like to know how many customers have 1 case running, how many 2-4, 4-6, etc.The regular histogram would be great because of its auto-binning feature. However, it automatically assumes that the dimension is calculated per case.Any ideas how we can use the histogram component, or mimic this behavior in a bar chart?

Hi everyone,does somebody know a possibility to exclude NULL values from the color mapping?I have an OLAP showing Projects in regards their delivery date differentiating between current internal responsiblity and external. For internal we measure against an internal deadline, while for externals this date is empty. So the color mapping should only apply on the lines with filled values, but all Null values are set red:Best regards,David

Hi all, is there an option to also create pop-ups when a viewer is moving with the mouseover a field or analysis? E. g. there is a button in the analysis that shows a KPI and when I am putting my mouse over the field there will show up the explanation how the KPI is calculated. I only no the functionality to create message buttons but this makes it confusing. Thanks.

Hello,I try to create an OLAP table where I can see the reasons why an invoice is being rejected. Since an invoice can be rejected by more than one reason, how can i display all the reasons?When I do a CASE WHEN it takes the first reason it matches. And is it possible to display more than one reason in one column? E.g. Reason a + Reason b in one column?Thank youSasan

I need to measure the number of orders within the booking process: anything between Create Quotation and Create Sales Order Item. For background, the # of Sales Orders using COUNT_TABLE("VBAK") is 200k. Using either of the below formulas continues to give me 200k Sales Orders. I have also attempted it with/without many different component filters: COUNT(DISTINCT CASE WHEN "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" IN ('Create Quotation','Create Sales Order Item') THEN "VBAK"."MANDT" || "VBAK"."VBELN" ELSE NULL END) or COUNT (DISTINCT CASE WHEN (PU_COUNT("VBAK","_CEL_O2C_ACTIVITIES"."USER_TYPE","_CEL_O2C_ACTIVITIES"."USER_TYPE" LIKE '%' AND "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" IN ('Create Quotation','Create Sales Order Item')) = PU_COUNT("VBAK","_CEL_O2C_ACTIVITIES"."USER_TYPE"

Hi, I am looking for a possibility to add extra activities in the data model. We connected our Oracle data in the data model and have based on that data our activities. We have a system that is related to the Oracle data, but we can only add the data manually. Now I am looking for a way to included those event logs in the proces explorer, by add and connecting manually added activities. Is this possible?

Hi all, Im creating an Credit note analysis - taking that into consideration all the values of my documents are negative: this causes that my graphs when Im looking at values and quantities look funny since the value 0 is not the aligned as the crossing for the X axis and the primary and secondary Y axis. Is it possible to align the crossing of the X and both of the Y axis to 0? In this case, it will mean that the line will be above of the X axis, and all columns will be below. Thank you!

Hi everyone, we currently face the following issue while analyzing a product lifecycle. After a development project we added a sales activity, holding the sales volume. Showing the timestamps of that activity on the x-axis and the volume on the y-axis, we receive the development of the product. This leads to the issue, if there are no sales in certain months, those months are not shown on the x-axis, meaning a year with sales each month is represented 12-times in the chart but a year with sales in only 2 months is represented only twice. This makes it impossible to read out trends on a case level. As the dimension formula is a regular (ROUND_MONTH(XXX_ACTIVITY.EVENTTIME)), there could be a checkbox to fill missing month between the highest and lowest available month. Best regards, David