Skip to main content

General Product Q&A

Not sure where to post? Ask your product-related questions here and get support from the community.

  • 1,445 Topics
  • 3,419 Replies
1444 Topics
Marc Rillaerts
Level 4
Marc Rillaerts
asked in General Product Q&A
Olap Table with KPIs from case table and activity table.

Hi Community, I was wondering if someone would have the solution to my challenge: I have built an OLAP table with one dimension and multiple KPIs. The dimension is the Country, and the KPIs are the number of entries in the PO table (COUNT_TABLE(case_table)), the number of distinct values of a specific field (COUNT(DISTINCT case_table.field), the total cycle time between 2 activities and then different ratios like automation, change and rework rates which use the activity table as basis. I also show the total value of the POs per country and have used here for statement SUM(case_table.value). Yet, doing so it appears that the calculated value is not correct as it identifies the value of each PO line and sums it up for each activity encountered on the PO lines. The same formula used in a pie chart returns the correct value. When I hide the different ratios in the table, the correct total value is returned. The first two KPIs with the count of entries also show correct values at any time.

30
E
Level 4
thomas.trill
Level 3
thomas.trillLevel 3
asked in General Product Q&A
Accounting for deleted records in Delta Extractions

Hello, how do you deal best with deleted records in Delta extractions? For a set of tables, we see, that delta jobs do not account for records that are deleted in the data source. E.g. when we extract a table and at that specific point in time it has - let's say - 50 records, but in the meantime, 25 of them get deleted, we have different data in Celonis and in the data source. The next delta job will not remove those records in Celonis, but only add changes or new records. Only a full extraction will overwrite the table and in the process of doing so, remove the deleted records. The question therefore is, what is best practice here? What options other than the Real-Time-Extractor and running full jobs daily do we have? Thanks!

90
thomas.trill
Level 3
R
Level 3
ryotaro.manabLevel 3
asked in General Product Q&A
How do you make this OLAP table?

Dimensions: Number of rework KPI1: lead time KPI2:Number of cases ​ I can't get the number of cases corresponding to the number of rework. Please let me know if there is a syntax.

00
E
Level 1
.
Level 3
.146004175Level 3
asked in General Product Q&A
Business hours calculation

Is there a way to calculate all KPIs by considering working days only? e.g. 5 workdays per week? e.g. average case duration would be lesser considering 5 days instead of 7.

20
.
Level 3
.
Level 3
.14600906Level 3
asked in General Product Q&A
How to calculate Process conformance by each case key for on premise 4.6 setup

Hi, We want to calculate process conformance as a KPI in the OLAP table for each company codes, markets etc as dimensions. Two years back Celonis team showed us that this can be done by opening process conformance analysis -> press F12 and then scan the browser logs for certain keywords and use some part of the logs into the OLPA table KPI editor. However, I dont recall all the steps but would like to understand if someone can share these steps again that would be really helpful. We have 4.6 on premise setup. PS: Tried using CONFORMANE PQL syntax but this proved way more difficult given complex process model design. Regards, Amogh

10
V
Level 1
R
Level 2
rakesh.paul12Level 2
asked in General Product Q&A
Have a KPI viz. Average Throughput time and I want to give a selection option for Percentile (50%, 80%, 90% & 98%). How I can do that?

Have a KPI viz. Average Throughput time and I want to give a selection option for Percentile (50%, 80%, 90% & 98%). How I can do that?

110
P
Level 1
.
Level 2
.146004053Level 2
asked in General Product Q&A
O2C data pool data model data loads fail after successful Full Extraction, Full Transformation and Create data model views.

We are trying to load the out of the Box OTC model. We have successfully completed - the Full Extraction Job , the full Transformation Job, The Create data model view Job When we schedule the data load of the data model its failing with the following errors Data model load failed during table export: Data model tables could not be exported: O2C_VBRP, O2C_MARC, O2C_KNKK, O2C_VBUK, O2C_VBUP, O2C_VBFA, O2C_VBAP, O2C_KNA1, _CEL_O2C_ACTIVITIES, O2C_KNB1

20
.
Level 2
F
Level 2
fábio.venânLevel 2
asked in General Product Q&A
I would like to know where I can find it and if it is possible to install Task Mining on MAC machines? Where can i find the installer?

I would like to know where I can find it and if it is possible to install Task Mining on MAC machines? Where can i find the installer?

20
F
Level 2
J
Level 1
julien.bennoLevel 1
asked in General Product Q&A
Is it possible to schedule a data-model partial reload by excluding one table only during some given loadings?

My data-model is loaded twice a week: currently a complete reload from source is done for all tables on Monday and Thursday. I would like to exclude one given table from the Monday reload, because this table is empty at this time, due to the process. I did not find any option to do that. Do you confirm? The Celonis version is 4.6 (on premise) Thank-you for your support Julien

20
R
Level 1
dennis.pflug
Level 6
dennis.pflugLevel 6
asked in General Product Q&A
Pycelonis: Change value of Text/Replacement Variable before extracting data from OLAP table

Hi all, we are currently playing with Pycelonis in our CPM environment. The main use case will be the automatic export of OLAP tables already prefiltered with PQL Filters we are using in the Python Scripts. So far we managed to implement most of the PQL Filters we need. Now we want to extract data of a table that contains cycle times based on activities the users are able to select themselves within the analysis. So via dropdown that is wrinting the selected activity into a variable. With Python we now want to extract this table setting a specific activity into a variable before extracting the data, in order to get the correct cycle times. So far I haven't found a way to update/overwrite the variables current value with the activity name we want to use. The Pycelonis documentation is ok but in my opinion not giving so much information and examples than the basic stuff. Thank you very much in advance. BR Dennis

00
V
Level 1
.
Level 2
.14600104695Level 2
asked in General Product Q&A
Parameter definition

Using celonis for O2C mining of Oracle EBS system. In one of the view, I go to edit, select on component and then go to component options. For the units, I see it configured as <%=currency_symbol%>. Can you please let me know where I can find this parameter/variable defined. I find the value as Euro, where as it should be $

00
D
Level 1
R
Level 3
ryotaro.manabLevel 3
asked in General Product Q&A
Why does the calculation result change?

syntax[A]=1,syntax[B]=934 patern1: syntax[A]/934=0.0010706638115631692 patern2: 1/syntax[B]=0.0010706638115631692 patern3: syntax[A]/syntax[B]=0.023554603854389723 ​ Only patern3 will give different results... Please tell me the solution.

00
D
Level 1
.
Level 1
.1460064233Level 1
asked in General Product Q&A
Affected rows: kickstart.messages-panel.more-than-100 - this error is reflected..kindly help

Affected rows: kickstart.messages-panel.more-than-100

20
D
Level 1
D
Level 2
debby.schle12Level 2
asked in General Product Q&A
Were can I found the latsted Step-by-Step guide for setting up Celonis on-Prem Agent?

Were can I found the latsted Step-by-Step guide for setting up Celonis on-Prem Agent?

00
D
Level 1
R
Level 3
roshan.kumar13Level 3
asked in General Product Q&A
Data model relation for two tables which are related in 1-N relation(VBAP:1 and VBRP:N).

These two tables are related in 1-N relation(VBAP:1 and VBRP:N). Also in some cases there are no entries in VBRP(AUBEL and AUP) for some entries in VBAP(VBELN and POSNR). I am creating an Olap to find all entries in VBAP (VBELN and POSNR) which does not have related data in VBRP(AUBEL and AUP) but they dont show up in olap. If i remove the VBRP columns from olap then they show up.

10
B
Level 1
S
Level 1
sebastiao.fonteLevel 1
asked in General Product Q&A
I want to break an Action Flow from running if no records fulfill a certain condition. How can I do it?

This Action Flow's purpose is to produce a CSV file to be sent via e-mail to a few business users. I have already been able to filter out the records completely based on the condition I want, but instead of stopping the e-mail from being sent, it just delivers the business users a CSV file with 0 records. I have tried to do it with the filter I show in the images. The 'Variable Value' in Set Variable - 39 is exactly the same that is being used to filter out the records in the first stage (Query Data - 10 - which produces the records basically). I have tried multiple approaches with this solution so I guess there should be another way around the problem I'm facing, which I don't know. Thank you

60
L
Level 1
denise.kruge12
Level 4
denise.kruge12Level 4
asked in General Product Q&A
Good day, is anyone else struggling to access the Knowledge Model in Studio? I can not create a new Knowledge Model. My collegue has the same issue. If I try to create a new Knowledge Model and I click "Create", then the program is hanging.

Good day, is anyone else struggling to access the Knowledge Model in Studio? I can not create a new Knowledge Model. My collegue has the same issue. If I try to create a new Knowledge Model and I click "Create", then the program is hanging.

30
denise.kruge12
Level 4
S
Level 5
sasa.redze12Level 5
asked in General Product Q&A
[Analysis] How can I get the CASE FLOWS THROUGH behaviour Any/All from the Activity Selection when selecting data from an OLAP table?

Hi there, The Activity Selection filter has an option where we can filter cases that flow through all or any multiple activities. I want to select a bunch of activities and filter cases that flow through any of them. Since this filter is used frequently I created an OLAP table with one category per row. I assumed that, selecting a row and inverting the selection would give the same result as activities flow not through ANY cases in the Activity Selection. However the results are not the same. In fact, inverting the selection does not change the total amount of cases. So this raises some questions. What does the invert selection option do and where can I read about it? Can we get the same functionality as in the Activity Selection filter (multiple activities flowing through any ) in an OLAP table? I used a CASE WHEN statement to create the categories in the OLAP table. Is there another way of doing this? CASE WHEN "_CEL_O2C_ACTIVITIES"."ACTIVITY_DE" LIKE 'Ändere Bonitätssperre%' THEN 'Ä

20
B
Level 1
K
Level 1
kavitha.linga12Level 1
asked in General Product Q&A
Is it possible to get the load script filter which gives the same result as this selection? ie. process flows through 'Deputation letter generated'

Hi everyone, I need to use load script filter for some pages in which the process has to be flow to this step 'Deputation letter generated'. I had tried, FILTER PROCESS EQUALS '<%=activity_name%>' FILTER ISNULL(PU_LAST("Table_name",ROUND_DAY("Activity_Table"."EVENT_TIME"),"Activity_Table"."ACTIVITY"='Deputation Letter Generated')) = 0; But it is not working. Kindly help me to solve this please

10
P
Level 1
S
Level 3
sanchit.khann15Level 3
asked in General Product Q&A
While doing On-Prem to EMS migration, we are facing a blocker on DATS_IS_VALID() function in On-Prem. Can anyone suggest an alternate for it in Vertica?

We are doing a project for migrating data transformations from On-Prem to EMS. SAP HANA is used for On-Prem transformations. We have a blocker where a function -> DATS_IS_VALID() is used in the transformations in On-Prem. The purpose of this function is to check if a particular date value (in the format YYYYMMDD) is valid or invalid. For example: 20211130 is valid (Nov 30 2021) whereas 20211131 is invalid (coz November doesn’t have 31 days) Now there is no direct syntax in Vertica to perform this operation as per our research. Since we have many transformations using this check, we would need your help in finding out a better way to solve this problem. Our conditions are mostly like, if the date is valid then take that specific date field and if the date is invalid then treat it as NULL. Invalid dates are present in Production data as well as there are some manual invoicing being done hence we cannot remove or ignore this check.

00
S
Level 2
J
Level 2
johann.bangLevel 2
asked in General Product Q&A
Does Celonis have any documentation of the algorithms they use in the process discovery and conformance checking? I need to have references for the master thesis

Does Celonis have any documentation of the algorithms they use in the process discovery and conformance checking? I need to have references for the master thesis

20
D
Level 1
S
Level 2
sharana.basava.patilLevel 2
asked in General Product Q&A
what is the difference between the operators '*','ANY','.' in match_process_regex function

​

10
M
Level 1
.
Level 2
.1460062914Level 2
asked in General Product Q&A
How to measure time between events and get specific cases

Hi there, i'm farely new to Celonis and struggeling with some basics. I'm trying so get the time between events (not only directly followed). For example: i have events A, B, C, D, E time between B and C should be less 1h goal: get all cases to which this applies I really tried to figure it out, even with OLAP tables, but i think for something this basic there has to be another way. Thanks in advance, looking forward to your answers. Steph

00
.
Level 2
P
Level 1
pritam.roy16Level 1
asked in General Product Q&A
The Public Link has been getting open for all without any credential which is avoiding the security policies

The initial idea was to view some Celonis Pages (Process analysis or analysis form Studio) from another tool which is hosted in AWS. Embedding of the Celonis page on that tool. But when we are sharing the link (not the public link) getting the below error message. <<IBC Cloud >> refused to connect. The issue with the public link is when enabling the celonis public link anyone can open the analysis with high confidential data to everyone, although in non editable mode but cases with confidential data will be visible

20
R
Level 1
.
Level 1
.14600105130Level 1
asked in General Product Q&A
Is there only Cloud solution is available or is there any software as well ? And if it can be installed , can we install it on virtual desktop for process mining ?

Is there only Cloud solution is available or is there any software as well ? And if it can be installed , can we install it on virtual desktop for process mining ?

20
D
Level 1

Badge winners

  • Qualified to Build Views
    keisuke.ikehahas earned the badge Qualified to Build Views
  • Qualified to Prove Celonis Value
    eloy.munozhas earned the badge Qualified to Prove Celonis Value
  • Qualified to Deliver Business Value with Celonis
    guy.hunt11has earned the badge Qualified to Deliver Business Value with Celonis
  • Celonis Technical Expert
    dennis_aguilar7has earned the badge Celonis Technical Expert
  • Qualified to Get Data Into Celonis
    dennis_aguilar7has earned the badge Qualified to Get Data Into Celonis
Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Center arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2025