Product Q&A

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

Ive got trouble finding a solution to calculate how many cases have a specific status atthe end of each day. There are only three possible values the status can have (A,B,C). To calculate how many cases have the status A, I am using the following formula:RUNNING_TOTAL(COUNT_TABLE(MAIN_TABLE)) -RUNNING_TOTAL(COUNT(DISTINCT CASE WHEN MAIN_TABLE.STATUS = B THEN MAIN_TABLE.CASE_ID ELSE NULL END))-RUNNING_TOTAL(COUNT(DISTINCT CASE WHEN MAIN_TABLE.STATUS = C THEN MAIN_TABLE.CASE_ID ELSE NULL END))The other two KPIs are calculated the same way, only the Status fields are changed accordingly.What I am now looking for is a time range as the dimension. This range should include every single day since one year. The Creation Date of the Case or the Eventtime of an Activity wont work, because the statuses can be changed on a daily basis but does not have to be. If none of the statuses are changed, then this day should still appear in my OLAP table.Do you maybe have a solution @d.becher?Best Regards

Snap, the community edition of Intelligent Business Cloud. In this section we share ideas, news, knowledge, and success stories with Snap users.

Hi everyone, I would like to add a line with a count all requests with a closed date not null by month on my chart. image.png1215225 17.9 KB I tried with this formulation but it is not working: CASE WHEN name_table.closed_at <> NULL THEN COUNT_TABLE(name_table) ELSE 0 END

Hi everyone, I would like to add a line with the number of the closed request opened in a month. image.png1215225 17.9 KB I tried with this CASE WHEN rm_enhancement.closed_at <> NULL THEN COUNT_TABLE(rm_enhancement) ELSE 0 END but it is not working. Someone had the same issue with a count with a case? Thanks

I created a donut chart modeling the percentage of EDI Orders in VBAK (Dimension is VBAK.ZZEDI_FLAG) Currently it looks as such: Instead of the X featured at the bottom and to the left of 26%, would it be possible to have the label appear as EDI Orders. I tried "VBAK"."ZZEDI_FLAG" AS 'EDI', but that did not work. Any other options available? Thanks

Backround: I have produced an OLAP table with the following columns for an Order-to-Cash Dashboard analysis with SAP. image.png70368 2.16 KB The dimension column variable is currently: "VBAP"."MATKL" || ' - ' || "VBAP"."MATKL_TEXT". The formula for Sales Order KPI is: COUNT_TABLE("VBAK") The formula for the EDI Order KPI is:SUM(CASE WHEN "VBAK"."ZZEDI_FLAG" = 'X' THEN 1 ELSE 0 END) The formula for EDI % KPI is: KPI("Ratio", "VBAK"."ZZEDI_FLAG" = 'X') Issue: I have two number KPIs that display metrics for The # of EDI orders within the OTC process SUM(CASE WHEN "VBAK"."ZZEDI_FLAG" = 'X' THEN 1 ELSE 0 END), andThe # of Sales Orders COUNT_TABLE("VBAK") The count for these are around 50k and 200k respectively, as they should be. Yet in the OLAP Table, the sum of the rows in the column for EDI Orders is over 300k, and the column

When working with data jobs transformations; specifically going through them to edit a field on multiple transformations, it would be nice that once you make an edit, save the transformation, then have the ability to click on a Previous or Next button to move to the transformation before or after the current one without having to go first click on the back button, then hunt down the next transformation that you want. Ive included a screenshot of what Im suggesting. Thanks! -Dallas PrevNextTransformation.png1672776 58 KB