Product Q&A

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

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