Product Q&A

Hey Celonis Community, If I want to show the average TPT between different steps in the Process Explorer the TPT shown should be around 1 to 30 days, instead it is now around Billions and Millions of days (see attachted file). (Same applies for the median TPT and the trimmed Median TPT as well as if I calculate the TPT by myself.) Is anybody else having this problem or can help me out? Thanks a lot! Jonas Process Explorer displays wrong TPT values945807 48.6 KB

Hi, The division of customers into different classes only works for one case. Only the customers from Europe. For the customers in America and Asia there is exactly only one class. Each customer is classified as a C customer. I have not changed the code. Only the sales organization has been changed. If I remove this filter and look at it on a global level, the division works into different classes but not within the intended limits (B starts at 90%). The abc function is configured as following: CASE WHEN ABC(SUM(VBAP.NETWR_CONVERTED), 0.6, 0.20) = 1 THEN A WHEN ABC(SUM(VBAP.NETWR_CONVERTED), 0.6, 0.20) = 2 THEN B ELSE C END

Hello, Is it possible to filter an OLAP table column for specific KPI values? Specifically, if we have an OLAP with some table attribute as the dimension and a KPI which calculates numerical values, is it possible to filter the KPI column for KPI(" ") > 0? Thanks!

Hi, I have a table with these two columns: Name and Total Net Value. The dimension is a simple column (NAME1) from the KNA1 table. The KPI Total Net Value is calculated as follows: PU_SUM(KNA1, PU_SUM(VBAK, VBAP.NETWR_CONVERTED) ) Now, i should get all customers with the total net value. This should be fine. Next step, I want to create a custom KPI which should give me a cumulative sum of total net values from all customers. So, every row should have the same cumulated number in the third column. I want to archieve this with the global function. But unfortunately, this function can not handle PU_X function as aggregation How can I solve my problem here? Thank you in advance!

Hello, I have loeaded my data model successfully but when i open my analysis there is no data (even the poucentage of cases). This error appears in all components : too many stages in execute_like Do you have any idea what causes this issue please an how can i fix it? PS: there is no filter applicable on the whole analysis and i kept the data model very simple. Thank you in advance

Running a standard transformation, Im encountering an occasional source data error (e.g. an alpha in an INTEGER column). Of course, the script halts immediately. The source environment is highly customized and there will be a few of these. DataException: [Vertica]VJDBC ERROR: Could not convert R03B802 from column table.numeric_field to a float8 This error message does not reveal a row number. Im loading over 20M records, so going back to source to locate and fix each data anomaly and then going through a long reload each time ugh. I cant get to the juicy part of this great tool because of the time spent returning to source data, one element at a time, cleansing and reloading. Im new to this, but it seems like Im missing something simple here. Is there a way to patch data post-extraction?

Hello all, I spent quite some time exploring all possible functions but Im unable to solve this.I need to do a running last based on the table as below. I will then use this to minus off the actual quantity. Ive explored the MOVING_X function, PU_X function and it doesnt seem to give me what I need. Any ideas? Appreciate the inputs!a869462 55.6 KB

Hello Community,I am trying to create a data range for my analysis.I have the below equation which works:FILTER CASES.NetDueDate BETWEEN ADD_DAYS(TODAY(),-6) AND TODAY() ;However, i would like to replace the 2nd TODAY with the last day of the prior month - 6.Can you please let me know if this can be achieved in Celonis?Many thanks,Anna

Hello Team, Can you please help how to move an analysis from one workspace to another with all the variables, filters and other stored details.

At this moment we have a filter on the extraction of the EKKO and EKPO which filter all orders and items based on the start date 31-07-2018.However, we want to add a second filter or expand the filter that fetches all orders starting with 37 which are in the EKKO and EKPO and started before before 31-07-2018.All other orders not starting with 37 must be retrieved via the previously set filter of start date 31-07-2018.The result must therefore be that we all pick up orders starting with 37 and the other orders only if they have been created as of 31-7-2018.How should we set up this filter?

Dear community, I would like to create an OLAP table same as cases to go in a process explorer. My data model is single eventlog which is consisted of process group, activity, and time stamp. If I could, Id like to show in the ratio as pie chart. Thank you for your support. Sugano

Hello team, We recently began implementing a First Time Right analysis for SAP ECC using the most recent template from the App Store. One item we noticed was that the KPIs included in the analysis all filtered to only cases that included the Clear Invoice activity: Affected Net Order Value: SUM(CASE WHEN PU_COUNT(VBAP, CEL_O2C_ACTIVITIES"."ACTIVITY<%= language %>,CEL_O2C_ACTIVITIES"."ACTIVITY<%= language %> = <%= clear_invoice_activity %> ) = 0 THEN NULL WHEN PU_COUNT(VBAP, CEL_O2C_ACTIVITIES"."ACTIVITY<%= language %> ) - PU_COUNT_DISTINCT(VBAP,CEL_O2C_ACTIVITIES"."ACTIVITY<%= language %> ) = 0 AND PU_COUNT(VBAP, CEL_O2C_ACTIVITIES"."ACTIVITY<%= language %>,CEL_O2C_ACTIVITIES"."ACTIVITY<%= language %> IN (<%=rework_activities%>) ) = 0 THEN 0.0 ELSE VBAP.NETWR_CONVERTED END) FTR Ratio: AVG(CASE WHEN PU_COUNT(VBAP, CEL_O2C_ACTIVITIES"."ACTIVITY<%= language %>,CEL_O2

Hi Community, I am building an OLAP table and I would like to calculate the average value over the past 6 months. With the 6 month time frame changing as time go on. CASE WHEN ROUND_MONTH(ADD_MONTHS(CASES.PostingDate, -6)) THEN TRIMMED_MEAN(CASES.Value(EUR), 5, 5) ELSE NULL END I have tried various options of the above and cant get it to work. Can you please help? Thanks, Anna

Dear All, We are having a count of Sales Orders as a KPI. Then we are creating an OLAP table with orders coming from Quote and non Quote. Now we want to add a percentage / Ratio in OLAP table. When I try to add the COUNT(DISTINCT(VBAK.VBELN)) to the ratio, it doest give me the correct result. How can I achieve the same? Thanks

Hi.We have function CASE WHEN KPI(FFF_TIME_PROCESS)><%=FFF_TIME_PROCESS_1%> THEN 1 ELSE NULL END.How I get a numberic quantity from function?With function COUNT it doesnt workDetails:in KPI(FFF_TIME_PROCESS) we have AVG(CALC_THROUGHPUT(CASE_START TO CASE_END, REMAP_TIMESTAMPS(EVENTS_EVENTS.EVENT_DATE, DAYS)))in variable <%=FFF_TIME_PROCESS_1%> we have AVG(CALC_THROUGHPUT(CASE_START TO CASE_END, REMAP_TIMESTAMPS("EVENTS_EVENTS.EVENT_DATE, DAYS)))

Hello, The client would like button report to a link outside Celonis and also one go directly in Action Engine without go back on the Home. Is it possible to do it on Celonis? On the button option there is not choise for link. Thank you Best Laura

Hi all, I would like to calculted the % of variant with 1 case, 2 cases, 3 cases, n cases I tried with KPI(Number of process variants) but I have not the result I would like. Thank you Laura

Hello, Is it possible to have component value conditioned by selections from a button dropdown? Ex: Button Dropdown (Country) options: Portugal / Spain / German If Portugal selected -> VBAP.BUS_UNIT_TEXT IN (FA, PA)If Spain selected -> VBAP.BUS_UNIT_TEXT IN (DI, MC)If German selected -> VBAP.BUS_UNIT_TEXT IN (SI, CP) Multiple selection possilbe. Thanks in advance. Best Regards, Joo Bu

Dear teamOur Objective is to obtain per Company Code , the number of vendors which net order value in a given year-month is greater than certain value for PO a particular type of POin the example below , Year=2019, PO Type ZLV, Amount 500KThe KPI below is our best last attempt, Still InaccurateKPI 2019:SUM ( CASE WHENPU_SUM(LFA1, EKPO.NETWR_CONVERTED,EKKO.BSART = ZLV AND EKKO.AEDAT_YEAR=2019) > 500000.00 AND EKKO.AEDAT_YEAR=2019 AND EKKO.BSART = ZLVthen 1.0/PU_COUNT(LFA1, EKPO.EBELN,EKKO.BSART = ZLV AND EKKO.AEDAT_YEAR=2019)ELSE0.0END)My Understanding is that the problem resides in the way we designed the KPI particularly in the Denominator used to obtain the Vendors instead of the cases. if you take a look in Line 3, we are considering all the cases that meet the criteria, except for the condition > 500.000,00 ( I did not include this conditions because I dont know how) this is why the KPI is approximately to the value, in the example below, outcome is 10.09 which Rounded is 10

Hi. We calculated 6 different lead times. Each lead time is specific for a certain role. Each of this calculation has several Case when formulas in it. These 6 lead times are saved in KPI. Now I would like to calculate AVG of all these lead times. The problem starts here. I actually can not get the correct values. Does someone have a working solution for this situation ?

Hi All, We have a data model-1 with activity table and connected with all master data tables. Can we reuse the master data of data model-1 in data model-2 directly in celonis? Is there any option like maintain/load all master data tables into celonis and use in various data models rather than loading the same master data for each data model ? Thank you.

While installing BMC Remedy process connector in app store I could see that it is without a data connection and has only the transformation. Could you please provide more information on whether its possible to configure a data connection to BMC Remedy using its API.

Dear Celonis team. First, let me congratulate you for continuously improving this wonderful tool. RANGE_APPEND was a very much anticipated and need function for me. However It misses one small detail that I was expecting: Gap Filling and Interpolation (GFI), like in the Vertica TIMESERIES Clause (https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AnalyzingData/TimeSeries/GapFillingAndInterpolationGFI.htm) The Problem When showing a series of date related records, lets say the daily account balance of my banking customers, I need to fill not just a date value for each day, but also to assume the same account balance of the previous day (non null record), if the balance hasnt changed on a specific date. RANGE_APPEND does part of it. It fills the gaps in the days that dont exist, but assumes 0 or null on the KPI values for the columns in my data table. This is OK, but not enough, regretfully. I even tried to use the LAG function, hoping it would match each generated date value of t

Dear Celonis community, I was wondering whether prescriptive analytics / recommendations (which are not out-of-the-box) are possible in Celonis? E.g. is it possible to define a goal (a particular performance indicator) and suggest possible actions to choose from (e.g. option A, B, C) in order to reach that goal? Example: As a production manager I would like to cut throughput times by 15% - What should I do next in order to best achieve my goal? Thanks in advance! Best, Daniel

Dear All,I have the following use case: for each document I need to compare if the value is 5 times more than average for given vendor and highlight such positions. This I have already done using domain table (formula also includes certain exceptions given by the business). The only problem is that is always counts values globally and does not limit to the document range from date range selected. Is there any way to make it work, so that the average is calculated only from the range of selected cases?image879296 8.07 KBimage2105372 46.4 KB