Skip to main content

Product Q&A

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

4438 Topics
mona.nagha
Level 2
mona.naghaLevel 2
asked in General Product Q&A
I am trying to create a custom KPI using Visual editor but somehow the visual editor is empty (can't access/see the visual editor option)?Any idea why this is happening?

I am trying to create a custom KPI using Visual editor but somehow the visual editor is empty (can't access/see the visual editor option)?Any idea why this is happening?

32
mona.nagha
Level 2
niclas.schmi11
Level 3
niclas.schmi11Level 3
asked in Data Ingestion & Infrastructure
Filter for two entries from the same column / 'AND' instead of 'OR'

I wanted to use the following filter statement which unfortunately doesn't work:FILTER "Table"."type" = (<%=type1%>) AND "Table"."type" = (<%=type2%>); Strangely enough, the filter does work if I replace the 'AND' with 'OR' like the following: FILTER "Table"."type" = (<%=type1%>) OR "Table"."type" = (<%=type2%>);. However, this would have the same result as an 'IN' statement like the following:FILTER "Table"."type" IN (<%=type1%>, <%=type2%>); But I need an 'AND' or an 'IN' where all selected 'types' are true and not only one from the 'IN' list. Can someone please help me with that issue?

139
L
Level 3
A
Level 1
abinaya.k30Level 1
asked in General Product Q&A
what is celonis?

what is celonis?

51
kailash.potha12
Level 5
dennis.pflug
Level 6
dennis.pflugLevel 6
asked in General Product Q&A
Best way to get .xlsx file generated via Pycelonis in ML-Workbench

Hi all, I try to find an easy solution for the following situation:I am triggering an Python script in ML Workbench via Action Flow.This Script is using pycelonis and extracts an OLAP table out of an Analysis. The OLAP table is containing exactly the information, columns etc. how we need the data. My first idea was to create an .xlsx file directly within ML-Workbench from dataframe and get the .xlsx file that is then stored within Jupyter File Browser via another Action Flow module. So far I haven't found a solution to access the files stored on ML-Workbench. Using Celonis Query Data -> CSV Advanced etc. is a total pain because in both modules I have to add all the columns again and do the mapping and all this stuff although the structure itself is already available on Analysis OLAP table level. Another issue is that I wanted to do this within one Action Flow and the Action Flow is not waiting till Python script execution is completed. Current workaround is the use of Sleep modu

313
G
Level 8
S
Level 1
suchitra.bathu13Level 1
asked in General Product Q&A
uploaded parquet file the timestamp is different how to convert into readable way in transformation using sql

uploaded parquet file the timestamp is different how to convert into readable way in transformation using sql

31
kailash.potha12
Level 5
C
Level 3
claudio.tatiy12Level 3
asked in General Product Q&A
Problem using Conformance Overview and Allowlist

102
C
Level 3
R
Level 2
ram.praka17Level 2
posted in Process Improvement
Hello All,

Hello All, Looking for some Benchmarks in KPI's associated with Accounts Payable, E.g. What is the Exception % Allowed generally?, What would be Automation Rate at? First Time Resolve / First Time Yield %? Any leads will be helpful.

60
R
Level 2
javier.desar
Level 3
javier.desarLevel 3
asked in General Product Q&A
Augmented Attributes used in Filters and KPI definitions inside a Knowledge Model.

Hi,  I am using Augmented Attributes in a Knowledge Model to build a View App. The A. Attribute is defined to have 4 possible values (dtype string) and it is meant to be updated manually by the end-user in the app to any of those 4 values. It has a Default Value as well for all those cases where the end user did not manually updated the attribute (which happens frequently). The problem comes when I want to use the "VALUE" field stored in the augmented table from the attribute in the Knowledge Model. I want to filter a chart based on the Attribute´s values (again stored in the VALUE field) and also define a KPI with a CASE WHEN logic based again in the value of the attribute. When I do so, it just returns the rows or datapoints where the Attribute was manually updated, filtering out all the rows for which the default value should appear.  I have not found a way to include the default value in the PQL queries outputs that I desire, so that I do not get most rows filtered out wh

232
javier.desar
Level 3
M
Level 3
michaō.rogosLevel 3
asked in General Product Q&A
Readsoft data connector and apps

HiWe are currently exploring process mining capabilities on SAP Kofax/ Readsoft data regarding potential opportunity with one of our Clients. We already identified process connector, however the specification in Marketplace is not available. Therefore looking for detailed list of activities which come with pre-defined model, specifically the action in performed Readsoft.We would like also to check there are any analytic apps matching data model from this connector. Thank you in advance for your helpregardsMichał

121
B
Level 1
M
Level 3
mpho.matheLevel 3
asked in Celonis Free Plan
What are the limitations of Celonis Free Plan in capabilities and GB size compared to the commercial plan? How can one estimate the GB required for certain number of processes?

What are the limitations of Celonis Free Plan in capabilities and GB size compared to the commercial plan? How can one estimate the GB required for certain number of processes?

271
B
Level 1
G
Level 3
giulia.cogliLevel 3
asked in Process Analysis
Hello, how can I add a specific workdays calendar to be applied to my full Analysis components?

In order to have an accurate calculation of the throughput time between my process activities, I would like to specify the following workdays calendar: from Monday to Friday, 9:00 - 18:00. Something similar is already available for some components, like the Throughput time search:I would like to do the same also for other components where I'm going to use the throughput time as KPI.  Thank you in advance, Giulia

81
B
Level 1
D
Level 3
dinesh.kumar35Level 3
asked in Data Ingestion & Infrastructure
How can we define the important FIELDS from tables that are needed for for P2P, AP, O2C and AR (all possible major use cases

Hi Experts,Our IT is asking for predefining all the data fields for each table for them to create views to be used for process mining by Celonis. We need the same for P2P, AP, O2C and AR (all possible major use cases for now) but not able to get anywhere. IT has not approved to make tables available fully due to security reasons and space constraints. please guide

23
D
Level 3
G
Level 8
guillermo.gost12Level 8
asked in General Product Q&A
How to calculate the weekly average of the daily unique values?

I want to calculate the week average daily number of employees doing one action. For that I need to calculate the number of different usersID's (thus a count_distinct) each day And then calculate the average of of those values in the same week. That will tell me, during that week, what's the average daily employee attendance to that action. How to do it? It should be fairly standard by I can't get it! I have a case table with timestamp of the action, and the user that did the action. And I want a OLAP with Week number - average of daily users I have used this struct: AVG(PU_COUNT_DISTINCT(DOMAIN_TABLE(ROUND_DAY(CASE.TIMESTAMP)),CASE.USER)) but the results are incorrect Can anybody tell me what I am doing wrong? TIA

55
G
Level 8
V
Level 1
vaibhav.chinc11Level 1
asked in General Product Q&A
The date format that appears in the CSV output file from Celonis action flow CSV module is not showing correct date (showing wrong time stamp) for example in my data initial date is 8/12/2021 1:52:00 AM but in csv 8/12/2021 2:52:00 AM. Can any

The date format that appears in the CSV output file from Celonis action flow CSV module is not showing correct date (showing wrong time stamp) for example in my data initial date is 8/12/2021 1:52:00 AM but in csv 8/12/2021 2:52:00 AM. Can anyone help?

21
K
Level 1
K
Level 2
karol.trzci11Level 2
asked in General Product Q&A
Changing SAP USNAM column from pseudonymized to non pseudonymized. Have anyone tried the approach mentioned below?

Hi, During initial implementation there was a decision to pseudonymize column USNAM in multiple tables. Currently it was agreed that we need to have actual (not pseudonymized) users data in Celonis just like it is in SAP.Usually unticking the Pseudonymize box in extraction setup would do the trick and I will do it for some smaller tables for which we have full loads. However we have couple tables for which we are doing only delta loads, as they are way to big for full loads (over 40 GB). Doing full load for them would take ages and I'm not entirely sure how Celonis would manage with such a huge load done at once. The idea is to create one time mapping by downloading second iteration of that big table (BKPF is original one, the second one lets call it BKPF_RAW), that would only contain the 4 key columns and USNAM that is not pseudonymized. Next step would be to add new column (lets call it USNAM_RAW) to original BKPF, then update it with data from BKPF_RAW.USNAM by matching the two

184
G
Level 8
S
Level 3
sachin.topul13Level 3
posted in General Product Q&A
What can be reasons for Open Invoices.

What can be reasons for Open Invoices. Any Available views for Open Invoices in Accountz Payable.

10
S
Level 3
D
Level 3
dinesh.kumar35Level 3
asked in Data Ingestion & Infrastructure
Best way for Delta Load from HANA Database to avoid any historical data added at a later date on HANA Database

Hello,Could you please advise how to avoid missing on data which was loaded to HANA Database after the extraction was done? In my case, Data is being loaded and consolidated onto HANA (no direct connection to SAP but through HANA database) and a delta load is run for Celonis as per timestamps. Now if some new business segment is added, any data prior to last "delta load" is not getting ingested to Celonis as it belongs to older dates. I know a full data load for a period can do the trick but that's not the efficient way. Any suggestions please?

44
C
Level 2
K
Level 3
kinsley.leLevel 3
asked in General Product Q&A
CALC_THROUGHPUT for two activity columns in the same table

Hi,I would like to to apply this function to mesure the cycle time of Change Activities. The activities table looks like this: Case ID2 columns "Change From" and "Change To" along with timestamp columnTime starts counting for each case when Change To = A for the first time and ends when Change from = A for the last time.   The logic Im trying to work around is (just disregard the function syntax- Im just trying to explain the logic.CALC_THROUGHPUT( First_Occurance ('Change to' = 'A') to Last_Occurance ('Change from' =' A '), Remap_Timestamps("Table"."event time", days) What is the right way to implement this logic?Should I filter the table to be "Change to" = 'A' or "Change from" = A and then merge this two columns to form a single column to use calc_throughput? But then how to merge different columns in the same table? Thank you for any suggestion!  

285
K
Level 3
jonas.schei12
Level 3
jonas.schei12Level 3
asked in General Product Q&A
Conformance Checker - Save allowlist (Viewer User)

Dear all,I'm looking for a way for the Viewer User to save his allowlist in the conformance checker. Is this really only possible for the Analyst? Thanks in advance! Best,Jonas

172
jonas.schei12
Level 3
A
Level 3
aldona.potocLevel 3
asked in General Product Q&A
Select cases with activity event time within a time range chosen from date picker

I have am OLAP table containing cases with event time of activity X and Y and a date picker based on the activity X. When I select a time range from my date picker (i.e. 01-01-2023 to 10-01-2023 or 01-02-2023 to 28-02-2023) I would like to see only these cases for which event time of Y is within the chosen selection with result 'in scope' and 'out of scope'. I don't want to have a second date picker and have to choose the same date range manually.

174
R
Celonaut
academic.allia11
Level 1
academic.allia11Level 1
posted in General Product Q&A
Business Analyst - Customer Value Analytics (m/w/d)

Business Analyst - Customer Value Analytics (m/w/d)E.ON Energie Deutschland GmbH Loction: Essen (NRW), München (BY)Description: Du unterstützt uns bei der Bewertung des Bestandskundenportfolios anhand verschiedener analytischer Use Cases mit den Schwerpunkten Lifecycle Analysen, Preisanpassung, Portfolio - Analytics und KohortenanalyseDazu screenst du Daten und baust Datenmodelle zur Abbildung der Business Logik aufDu erstellst Analysen und Reportings in PowerBI und Process Mining (Celonis) und entwickelst diese weiterOptional erstellst du auch Analysen und analytische Modelle u.a. mit PythonDu visualisierst Daten aussagekräftig und kannst Wirkzusammenhänge erkennen und erklärenDu erstellst managementtaugliche Präsentationsunterlagen im notwendigen Abstraktionsgrad, um die komplexen Zusammenhänge im Bestandskundenportfolio zu transportierenDu unterstützt im Rahmen der Projekt-/Squad-ArbeitZur Bewerbung: https://jobs.eon.com/de/job/Business-Analyst-Schwerpunkt-Customer-Value-Analytics-m

30
academic.allia11
Level 1
joos.buijs
Level 6
joos.buijsLevel 6
asked in Data Ingestion & Infrastructure
How to create a date range

We are plotting numbers of cases finished per date. However, when there are no casesfinished on a particular date, the date is not present in the chart, and hence were losing information.A solution could be to create a data range, say from all days between 1-1-2019 and TODAY(), making sure that every day is represented in the chart.We have similar issues when plotting on hour of the day (0-24), day of the week (0-6), etc.

812
W
Level 2
Carolin Ullrich
Celonaut
Carolin UllrichCelonaut
asked in Process Analysis
(How) can I set a displayContentRule for dates?

Hello community,I try to use a display content rule in a view component (table) based on a date. 💅  In the documentation /help/display/CIBC/Views+Components#ViewsComponents-DisplayRulesdisplay-rule it states e.g. the comparators:"DATE_IS" # for 'date' "DATE_IS_BEFORE" # for 'date' "DATE_IS_AFTER" # for 'date' The question I'm asking myself is about the formatting of the Value --> in which time format do I need to enter the value?My guess was "same as in Knowledge Model attribute's definition", but that didn't work for me. I would be very happy if someone could share an example configuration of a Display Content Rule with a date value. Thank you, community! 😊 ​

162
daniel.schus12
Level 3
connor.manth
Level 3
connor.manthLevel 3
asked in General Product Q&A
Why use a variable over a KPI (saved Formula) in Celonis Analyses?

Is there a best practice to chose a KPI (saved Formula) over a variable in Celonis (or vice versa)? For example, I seem to recall that all KPIs are calculated upon loading the analysis? Would that make certain uses more suitable to a variable?

25
michael.tong
Level 2
A
Level 2
aaron.peschLevel 2
asked in Data Ingestion & Infrastructure
Counting rows that share the same case id

Hi there, this probably has some super simple solution but im kind of stuck at the moment.I basically want to count, how often a certain activity happens per case. My idea was to apply a filter so that i only have rows containing that activity. For example i now have 4 collums with case id 1. Now i just want to create a new collum that shows how often the activity was done in each case by just counting how many rows share the same case id. For example of case id 1, there should be a collum at the end, that shows "4" in every row with the case id 1. Thanks for your help once again and kind regardsAaron

13
G
Level 8

Badge Winners

  • First Post
    axel.bühle12has earned the badge First Post
  • Value Realization Expert
    nataly.hansehas earned the badge Value Realization Expert
  • Qualified to Manage Implementation Projects
    nataly.hansehas earned the badge Qualified to Manage Implementation Projects
  • Qualified to Manage Change and Scale Adoption
    Ha Xuyen Duonghas earned the badge Qualified to Manage Change and Scale Adoption
  • Qualified to Deliver Business Value with Celonis
    Ha Xuyen Duonghas earned the badge Qualified to Deliver Business Value with Celonis
VIEW ALL
Community Code of Conduct