Skip to main content

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

3156 Topics
.
Level 2
.14600815Level 2
asked in Process Analysis
How to create OLAP table same as “cases to go” in a process explorer

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

00
V
Level 1
A
Level 2
alex.hellwLevel 2
asked in Process Analysis
Filtering FTR analysis to only cases with “Clear Invoice” activity

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

10
V
Level 1
.
Level 4
.14600775Level 4
asked in Data Ingestion & Infrastructure
Calculate Euro value but only for the past 6 months (moving date)

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

10
.
Level 4
N
Level 3
naveen.guptaLevel 3
asked in Process Analysis
Creeating ratio between total count and corped count

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

20
M
Level 1
.
Level 2
.14600831Level 2
asked in Data Ingestion & Infrastructure
Need help with the function to make a numberic quantity

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)))

00
.
Level 2
L
Level 3
laura.lauraLevel 3
asked in Process Analysis
Button go to a link

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

00
L
Level 3
L
Level 3
laura.lauraLevel 3
asked in Process Analysis
Percentage of variant with one case

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

00
L
Level 3
.
Level 2
.14600794Level 2
asked in Data Ingestion & Infrastructure
Conditional formula based on selections

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

20
.
Level 2
C
Level 3
cristian.cristLevel 3
asked in Data Ingestion & Infrastructure
PU Funtions Count Vendors with Criterias

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

50
V
Level 1
A
Level 2
adam.stefa11Level 2
asked in Process Analysis
Lead time average calculation

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 ?

10
A
Level 2
G
Level 3
gopinadh.kanch12Level 3
asked in Process Analysis
Data model master data reuse

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.

00
G
Level 3
S
Level 2
srinath.ramgo12Level 2
asked in Data Ingestion & Infrastructure
Missing data connection in BMC Remedy Process connector

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.

10
S
Level 2
N
Level 3
nogueira.nogueLevel 3
asked in Process Analysis
Ah! You almost nailed it with the new RANGE_APPEND function!

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

130
N
Level 3
D
Level 3
daniel.danie12Level 3
asked in AI
Prescriptive Analytics in IBC?

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

00
D
Level 3
K
Level 3
krzysztof.sitar11Level 3
asked in Data Ingestion & Infrastructure
Use Pull up and header filters

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

00
K
Level 3
joos.buijs
Level 6
joos.buijsLevel 6
asked in AI
Analysis <-> ML interaction

Hi all, Our use case: We would like to allow our end-users of the Celonis analyses to test hypotheses themselves (does attribute X correlate with KPI y?). Question: As we are currently still on-premise we are investigating connecting Celonis to an R-Server to enable the RCALL function. This would allows us to dynamically build the data set to pass to R and then present the result in a user-friendly way. However, as we might move to the IBC in the (near or far) future, we wondering if such analysis <-> ML interaction is also possible with the ML Workbench. Concretely, can we pass parameters from the analysis to a stored ML function/notebook which then returns the results to be presented in the analysis? An alternative would be to pre-calculate every possible combination of attribute (sets) and KPIs, which I guess is not handy. Looking forward to some inspiration! Cheers, Joos

10
N
Level 1
steven.bernd
Level 3
steven.berndLevel 3
asked in Process Analysis
Cluster right and wrong Process

Hey community Id like to create a cluster in form of a OLAP table in Celonis in which I can select the right process, but also those IDs that go wrong through the process. for example: I have problems with the coding Now something about the Process: My process looks like f.ex. Activity A Start>Activity B -->Activity C -->Activity D -->Activity E>Activity F END For our department activity C and activity E is important. The other activities can be neglected. The right process is when activity C comes first and activity E comes later, not the other way around. The wrong process is, when activity E comes first and activity C comes later, exactly the wrong way round,if activity E is completely missing, I think I need something like this, but it is not yet thought through to the end DISTINCT(CASE WHEN PROCESS EQUALS Activity C TO ANY TO Activity E --the order is still missing here THEN right process WHEN MATCH_ACTIVITIES(NODE[Activity C] EXCLUDING[Activity E]) OR PROCESS E

00
V
Level 1
F
Level 3
francisco.da.siLevel 3
asked in Data Ingestion & Infrastructure
[ISSUE FORMULA] Considering only weekdays in a Throughput Analysis

Hey there!Hope you are doing fine.I was wondering if it is possible to consider only weekdays in a normal throughput formula, or even right from the get go, in already built-in dashboards such as the follow one:image1269361 15.3 KBIs there already a pre-built formula for this problem?AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[Consumption] TO LAST_OCCURRENCE[Purchase Order Release], REMAP_TIMESTAMPS(Consigned_EventLog_xlsx_Consigned_EventLog.TIMESTAMP, DAYS)))For example in this formula.Looking forward to hearing from you Best,Francisco

20
F
Level 3
G
Level 3
gopinadh.kanch12Level 3
asked in Data Ingestion & Infrastructure
Celonis Authorization Objects: query-definitions.xml.sample

Hi All,I would like to create query-definitions.xml.sample file and upload to application server to get the values for authorization objects.Could someone provide an example file for query-definitions.xml.sample!Thank you.

10
V
Level 1
V
Level 2
vilas.kulkaLevel 2
asked in Data Ingestion & Infrastructure
IBC - Cloud table loader - Installation issue

We are using Celonis provided tool to transform the data files extracted from SAP ECC and upload into IBC cloud. Since this process is time consulting, we wanted this to be done by multiple people in our team. We are having issues in installing this tool in our client provided laptops. Everyone in our team is facing same issue. During installation we see error installing module names pyxlsb The error description shows "Maximum retries exceeded with url SSL Error - SSL Certificate Verify Failed During actual upload - we get error No module named Pyxlsb Did anyone else encountered this type of issue before? What do you think is probably solution? Thanks, Vilas Kulkarni NTT Data, McKesson - Celonis implementation project

10
V
Level 1
W
Level 2
westenhöfer.westeLevel 2
asked in Data Ingestion & Infrastructure
Percentage of cases covered by the 5 most common variants

Hello,I want to calculate a Number KPI that will return me an percentage value of the cases covered by the 5 most common variants. The code should be similar to the % of cases covered in the Variant Explorer, but will always select the 5 most common variants in respect to the selection.Neither the Number of variants function nor the PQL references help me with my problem.Can someone help me out?Thanks in advance!

20
D
Level 2
.
Level 4
.14600775Level 4
asked in Data Ingestion & Infrastructure
Case_key count including & excluding certain activities

Hi Community,Hope everyone is staying healthy.I would like to build up our KPI statement but am having trouble making the formulas work as they should.I would like to count certain activities from the activities tables, but also exclude certain cases if they also pass through for example Changes to Document activity.For example:COUNT(DISTINCT CASE WHEN (ACTIVITIES.ActivityEN = Start of FI Non-Compliant Approval AND ACTIVITIES.ActivityEN != Changes to Document)THEN CASES."_CASE_KEY" ELSE NULL END)When applying the above formula, i get the same result regardless if I included the the "!= Changes to Document or not.I have also tried using a PU_COUNT formula but receive an error message:PU_COUNT_DISTINCT (CASES.ACTIVITIES.ActivityEN) IN Start of FI Non-Compliant ApprovalAND PU_COUNT_DISTINCT (CASES.ACTIVITIES.ActivityEN) NOT IN Changes to DocumentTHEN CASES."_CASE_KEY" ELSE NULL ENDPlease help.Cheers,Anna

30
D
Level 2
V
Level 2
vilas.kulkaLevel 2
asked in Data Ingestion & Infrastructure
Procure to Pay Model question on multiple processes - Best practices / Recommended approach

The PTP model which we are working on has several major processes such as Standard ProcurementStock Transport OrdersDrop Ship purchase orders (originated from Sales orders)Returns Purchase ordersInter-company purchase orders etc.International purchase orders etc. In order to see these processes separately under Celonis IBC cloud., we can develop Custom transformations. However we want to understand what is the best practice or recommended approach. To elaborate the question - Let us consider example of one activity Create purchase order item Is it recommended to create multiple activities - one for each process such as Create standard purchase order itemCreate stock transport order itemCreate Drop Ship purchase orders itemCreate Returns Purchase order itemCreate Inter-company purchase order itemCreate International purchase order item etc. OR Is it recommended to just use the common activity name Create purchase order item for all the above processes and use attributes such as docume

00
B
Level 2
F
Level 3
francesca.licanLevel 3
asked in Process Analysis
How to add a Trendline

Hello Celonis community, I would like to create a bar chart with a trendline. Is there something similar to the excel trendline option? image.png335628 13.5 KB Thanks in advance for your support. Kind regards, Francesca

80
M
Level 3
G
Level 3
gopinadh.kanch12Level 3
asked in Process Analysis
Will new “Process Model” in “Conformance” change the initial view of “process explorer” in analyses

Hi All, Could you please clarify the below query! Will new Process Model in Conformance change the initial view of process explorer in analyses? We have a requirement to change the initial view of process explorer with a certain list of activities given by the user. And the further expansion of the activity list should show the remaining activities. Thank you.

10
V
Level 1

Badge winners

  • Qualified to Build Views
    luca.fancihas earned the badge Qualified to Build Views
  • Qualified to Write PQL Queries
    luca.fancihas earned the badge Qualified to Write PQL Queries
  • Qualified to Identify and Drive Opportunities
    MayankAgarwalhas earned the badge Qualified to Identify and Drive Opportunities
  • Qualified to Manage Implementation Projects
    schahram.hamrahas earned the badge Qualified to Manage Implementation Projects
  • Value Assessment Expert
    Tobias Fehrerhas earned the badge Value Assessment Expert
VIEW ALL
Community Code of Conduct