Product Q&A

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

Hello Celonis Community, Celonis 4.5 I need to create a pareto chart showing the Delta hours (planned-actual) for each production phase (e.g. setup, production, breakdown,). Each phase can have different unique activities, for which Ive defined dedicated variables : The actual data are derived from the ACTIVITIES table. The Target data are located in another table: image.png827211 4.92 KB The two tables are not directly linked. The common parent table is the CASE table. image.png1609576 21.6 KB I use the component Column Chart and I add Dimension: KPI(Category), so defined CASE WHEN ACTIVITIES.ACTIVITY_EN IN (A,B,C) THEN Setup WHEN ACTIVITIES.ACTIVITY_EN IN (D,E,F) THEN Production WHEN ACTIVITIES.ACTIVITY_EN IN (G,H,I) THEN Dismantling WHEN ACTIVITIES.ACTIVITY_EN IN (L,M,N) THEN Breakdown ELSE NULL END KPI: CASE WHEN KPI(Category) = Setup THEN SUM(PU_SUM(CASES,PLANNED_TIME.Setup))- SUM(HOURS_BETWEEN(ACTIVITIES.START_TIME,ACTIVITIES.END_TIME)) WHEN KPI(Category) = Dismantling TH

How can I copy the full tab from one analysis and paste into another. Idea is to have power user create there analysis in seperate folders / analysis. Once it reaches a validated stage then to copy the whole tab and paste in Productive / published analysis. Doing component by component is erronus and time consuming. Thanks Naveen Gupta

Hi all, Were using datepickers that are linked to a variable <%=date%> , which at the same time is being defined by different formulas. When looking at the title for the date picker, we have chose the text related to the variable <%=date%> The problem is that when the variable is being defined by a formula, and not a field in a table. this is also the case when we have graphs associated to the dates, in this case, the whole formula is displayed when the users hover over the graph we have tried to save the formula as a KPI, at least just to have the KPI name displayed, but in this case the variable will not be set, and the date picker will not work. Is there any way to avoid showing the whole formula as the title for these cases? Thank you for your help! image.png401673 20 KB image.png617572 36 KB

Hello together, is it possible to built an KPI in an OLAP, like:= count cases (with sheet selection) / count cases in sum (without the sheet selections)Thank you in advanceSarah

Hello Community,anybody has an idea how to consider the calendar-times (which is related on the datamodel) in the following Source-Target function:Preformatted text AVG(DAYS_BETWEEN(SOURCE(Status_FY1718.csv.CHANGEDATE,REMAP_VALUES(Status_FY1718.csv.STATUS, [CLOSED, NULL]),FIRST_OCCURRENCE TO LAST_OCCURRENCE),TARGET(Status_FY1718.csv.CHANGEDATE,REMAP_VALUES(Status_FY1718.csv.STATUS, [CLOSED, NULL]),FIRST_OCCURRENCE TO LAST_OCCURRENCE)))indent preformatted text by 4 spacesFYI: the service times areMONDAY 08:00 - 18:00 TUESDAY 08:00 - 18:00 WEDNESDAY 08:00 - 18:00 THURSDAY 08:00 - 18:00 FRIDAY 08:00 - 18:00Best regardsSarah

Hi all, I would like to define a new KPI to measure the ratio of eProcurement (EP) orders vs. all other PO doc types. The doc type information comes from the PO header (EKKO), however Id like to show the ratio based on line item level (EKPO). The formula which Ive set-up and which works fine for the ratio on Header looks as follows: 100 * AVG(CASE WHEN EKKO.BSART = EP THEN 1.0 ELSE 0.0 END) Somehow, Ive to bring in one more variable to take line items into account: COUNT_TABLE(EKPO) Any idea how to combine to show the ratio of EP PO items? Thanks, Oli

Hello Team, I noticed the decision tree function seems not available. Is it true or just the blue color didnt show? Best Regards, Chen Lei

HelloI am trying to create a KPI called PO Touch Indicator that will allow me to have a Value of touchless, manual intervention, or unknown based on the activites and User Type per PO.When AT LEAST one UserType = - then unknownWhen ALL UserType = B then TouchlessWhen AT LEAST one UserType = A and rest are B or all are A then Manual interventionEx 1:PO: 12344232 // PO ITEM: 01 // Activity: 1 // UserType: A // KPI "PO Touch Indicator: unknownPO: 12344232 // PO ITEM: 01 // Activity: 2 // UserType: - // KPI "PO Touch Indicator: unknownPO: 12344232 // PO ITEM: 01 // Activity: 3 // UserType: B // KPI "PO Touch Indicator: unknownEx 2:PO: 12344232 // PO ITEM: 01 // Activity: 1 // UserType: B // KPI "PO Touch Indicator: touchlessPO: 12344232 // PO ITEM: 01 // Activity: 2 // UserType: B // KPI "PO Touch Indicator: touchlessPO: 12344232 // PO ITEM: 01 // Activity: 3 // UserType: B // KPI "PO Touch Indicator: touchlessEx 3:PO: 12344232 // PO ITEM: 01 // Activity: 1 //

Hi, After upgrade of Celonis to 4.5, I am experiencing the new issue in one of my models. Please see an error in the attached screenshot. cycle.PNG951196 16.2 KB Ive been able to find just a short explanation of the error HERE Is someone else facing this kind of issue? How did you solve it? Thanks, Tomas Kvapil

Hello Everyone,I hope you all doing good I would like to see how many orders that are going through Credit Check. Normally, thecredit check was executed on the Header level, which means we do not care about position lines. But in the Celonis the activity is defined from Order item not from the order header level.In order to see the total number of orders that are going through credit check , I have implemented PQL codeAsCOUNT((CASE WHEN _CEL_O2C_ACTIVITIES.ACTIVITY_EN IN (Deny Credit Check,Approve Credit Check)THEN " VBAK".VBELN ELSE NULL END))/COUNT_TABLE(VBAK)But still it counts the activity.Do you have any idea, how to count only sales orders for an activity by using any other function?Thanks in AdvanceWith regardsRahul

Hello, i want to visualize a big process in Celonis. This process runs through several systems. I now have the problem with my CASE_ID because they change through the process. This means, for example, that the process begins with a measure number, later the measure number becomes an order, and in the end this order becomes another order. So the 1: 1 relationship is given, but I have to consider the change of the CASE_ID. Can someone help me? Example: Step1: 700350000 Step2: 6125600 Step3: 6185600 thx.

Hi together,I have the following question. To check if a SAP batch run for the invoice creation is scheduled at the best time I would like to check when the manual invoice creations occuring normally at a day.For example:Batch runs at 15 PM, but most of the invoices are created manually at 10 AM (for whatever reason). So it would be maybe better to run the batch at 10AM.Im thinking about a graph or diagramm whichs shows me the time as a dimension (in hours, 8AM, 9AM and so on) and the number of invoice creations at the different points of time at a day.Is something like this possible? Are there any suggestions?Best regards,Friedemann

Issue: As we are building more and more dashboards we realize that some dashboard sheets are printed and spread, for instance in Obeya rooms. However, there is no way to include the applied filters, unless you make a screenshot, and therefore it is unclear what the printout represents. Feature request: Include the applied filters either in the print version, or make them available via a macro such that these can be added in a text field to be added to the dashboard sheet, and therefore will show up in a printout of the dashboard sheet.

We have connected Celonis to our central data core. This means we have data of over 700 processes in one generic table structure (case, step, process, client, etc.). However, this also means that if we want to have different case notions (for instance one analysis has a process as scope and hence case=case, while another is focusing on customer journey where case=client). Currently this means we have to load in the data twice (or more), with different activity/case notions set. This means duplication of the data. It would be nice if this setting could be data model independent (or: one data model has several case/act notions from which the dashboard can select one). Im aware of the process explorer option to change the activity attribute, but my request/suggestion is also concerning the case notion.

Hi Team, We want to make one Column Chart, where X-axis (Dimension) have a data point like (0-3 Days, 4-6 Days, 7-9 Days, 10-16 Days & 17+ Days) and KPI will have such as PO Lines Pending & PO Pending GR Amount. But the issue is sorting not working properly, its sorting randomly. Is there have a way to custom sort the Dimension. Regards, Rakesh Paul

Hello community,at the moment Im working on defining a drop down bottom to filter Production Order having Bad Conditions or without Bad Conditions.To do so, I use a code like the one below.Unfortunately, the amount of possible Bad Conditions is so high that after a certain number ofMATCH_PROCESS I get the error:image.png891111 7.46 KBBut if I separate the formula in 2 pieces, then I get the desired result.However, Im not able to combine the 2 pieces together and I should have multiple drop down lists as a filter not practical.Do you have better ideas?At least do we know if there is a real limited number of conditions that can be added in the CASE WHEN function?Many thanks,FrancescaCASE WHEN** MATCH_PROCESS** (LOOP[A] AS loop_A,LOOP[B] AS loop_B,LOOP[C] AS loop_CCONNECTED BY DIRECT [loop_A, loop_B], DIRECT [loop_B, loop_C])>0OR **** MATCH_PROCESS (LOOP[A] AS loop_A,LOOP[B] AS loop_B,LOOP[D] AS loop_DCONNECTED BY DIRECT [loop_A, loop_B], DIRECT [loop_B, loop_D])>0OR **** MATCH_PROC

We want to execute in PQL the following SQL code:SELECT SUM (BD2.betkortbedr), BD2.CrediteurFROM BSAK_DEF2 BD2INNER JOIN LFA1_BEW_CSV LFA ON BD2.Crediteur = LFA.CrediteurWHERE LFA.Flinqer IS NULL AND (BD2.Korting1 > 0)GROUP BY BD2.CrediteurBut the join is not fully discribed in the PQL documentation.Does anyone have a sugestion how to solve this with PQL?

Hello, I try to create a Button drop down component for just a specific table in my analysis. So when I filter with this button, just this specific table is effected. Can anyone help me how to implement this? Best Wishes Sasan