Skip to main content

Product Q&A

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

4364 Topics
N
Level 3
neel.neelLevel 3
asked in Data Ingestion & Infrastructure
Check Formatting of Data in Field

I am trying to check the Number of records that do not comply with std format (XX-XXXXXXX) within a specified field.Any help is greatly appriciated !

10
F
Level 1
V
Level 3
vahide.öztürLevel 3
asked in General Product Q&A
Data Mining for Activity Detection

Hello, Sometimes we struggle that how we can define activity correctly. Thats why we search for more data driven approach to define activities. For example, for change activities , we get count of changed fields and , then evaluate if it gives any inside or not. As a summary we search for more data driven, automated way for activity detection. Could you please share with your ideas ? Best Regards, Vahide.

00
V
Level 3
D
Level 2
david.karweLevel 2
asked in Process Analysis
Chaining PQL Queries

Hi Celonis Community, Ive recently started working in PM and am faced with my first real challenges. To answer complex questions of the process owner I would need to execute more complex calculations in Celonis. Im unsure to which extent this is supported. Ive read through the functions documented in the help section and functions highlighted here but could not find any that provide what Im looking for. Is it possible to base a calculation in Celonis on a previously calculated column? An equivalent of what Im trying to achieve might be subqueries in SQL. Im unable to go give insight into the process and will provide a much simplified example. My activity table looks like this: grafik.png886138 2.98 KB Based on this I can calculate a new table with the automation rate per CASE In the following I want to use the calculated column, to base further calculations on it. Like: OR I hope this is understandable enough. Im also positive, that there might be an easier way to achieve this,

10
D
Level 2
K
Level 3
krzysztof.sitar11Level 3
asked in Data Ingestion & Infrastructure
Connection KPI for custom Activity KPI

Dear Colleagues,I have built a custom Process Explorer Activity KPI, that takes the number of activity occurences from Case Level (BSEG table) and aggregates on header level (BKPF). This is because some activities are happing on header level, regardless of how many invoice lines we have. For example I post invoice only once and want to show value 1, even though it can be posted on 5 vendor item lines (BSEG=5).I want to apply the same for Process explorer connection KPI, but I dont know how to handle it.Can you please help me understand how to apply the logic to connection KPI? Details in attachement.Thank you very much (173.9 KB)

70
K
Level 3
.
Level 4
.14600775Level 4
asked in Process Analysis
OLAP table presentation

Hello, I am building a OLAP table. I was wondering if there was a way to re-structure the table so instead of the single KPI information flowing vertical, it can flow horizontal? I have thought about using a pivot table, however because the data set is so large, it does not seem to be a suitable option. Please let me know. Cheers, Anna

20
V
Level 1
.
Level 4
.14600833Level 4
asked in Data Ingestion & Infrastructure
From a specific activity to the “NEXT” one

Hello everyone, is there a way to calculate a duration between a specific activity (lets say A) to the next activity (whichever it was). Thank you!

80
.
Level 4
oliver.joere
Level 3
oliver.joereLevel 3
asked in Data Ingestion & Infrastructure
Same data model used by different business areas

Weve got the challenge that one data model (for O2C) is used by several different business areas like Sales, Logistics or Finance. Every business area likes to get their specific process activities defined in the data model and number of activities increases significantly. In order to avoid that every business area needs to deal with very detailed activities they are not interested in Id like to provide a customized data model for each business area just showing their relevant process activities. Due to license restrictions we could not simply multiply the data model. Now Im looking for ideas how to solve this issue.

20
oliver.joere
Level 3
joos.buijs
Level 6
joos.buijsLevel 6
asked in General Product Q&A
XES import: case table creation (and gzip support)

Today I loaded the BPIC 2017 event log and noticed that although the event log contains both event and trace level attributes, Celonis flattens all to event level attributes. Feature request: XES import results in both an activities as well as a case table. Minor feature request: support for gzip-ed XES files (BPIC17 is 560Mb as XES XML file, but less than 30 Mb as xes.gz, something you notice when youre working from home).

00
joos.buijs
Level 6
S
Level 3
sachin.rajpu12Level 3
asked in Data Ingestion & Infrastructure
Global Variable

Hello Celonis Team,Today I am using a variable that is defined within an analysis.How can I define the variable at the Data Model level so that we can use the variable throughout all the analysis that is created using that Data Model?Regards,Sachin

30
D
Level 3
V
Level 3
vaclav.juren12Level 3
asked in Process Analysis
RCALL or RAGG in Celonis

Hello, can someone please tell me how to put R code in Celonis? It is working in RStudio, but when I put it in RCALL or RAGG it gives me errors I do not understand. Can someone please explain to me how exactly RCALL or RAGG works? Thanks Vaclav Juren

00
D
Level 2
C
Level 2
carlo.ruggiLevel 2
asked in Process Analysis
Activity Selection in PQL Syntax

Hello, I don`t know what is the correct PQL Syntax for this Activity Selection for my KPI Component option (see screenshot). Thanks in advance for your responses :o)) image.png1061476 22.5 KB

50
C
Level 2
joos.buijs
Level 6
joos.buijsLevel 6
asked in General Product Q&A
Add axis range option: max

Currently axis ranges can be set to automatic or manual. Issue: What I observe is that the axis range is determined on the >visual< bars/dots/etc. However, this is confusing as scrolling causes the axis to dynamically change. Proposal: Add a third option which either sets the scale to all data points visible and not. Alternatively, but less user friendly in some use cases, allow PQL in the manual ranges (MIN/MAX() would need to be added by the user manually and in sync with the displayed KPIs so not that user friendly.

10
joos.buijs
Level 6
joos.buijs
Level 6
joos.buijsLevel 6
asked in General Product Q&A
Feature request: direct link from Celonis PQL library to more extensive PQL help documentation

Currently when adding dimensions/KPIs in the code editor there is a list with PQL functions and a summarized explanation of the feature. It would be really helpful if there would be a direct link from this summary to the Celonis help documenation with usually more extensive explanations and examples.

01
D
Level 2
S
Level 3
stefan.grossLevel 3
asked in Data Ingestion & Infrastructure
Getting Difference in consecutive data values in time series data (column chart)

Dear all,I have a time series plot of the automation rate like the following:x- Axis: ROUND_MONTH(EKKO.AEDAT)y-Axis: KPI(Automation Rate) (standard automation rate formula; should work then with any KPI)My Goal is to calculate the difference in the automation rate between the current month and the previous one i.e. get as result 4.8%.How to do this in celonis? In the end I want to have a list of KPIs which from design point of view look like the followingIs there a simple way to calculate the 4.8% in a dynamic way (the 7.33% is coming from 2 years of data)?Thxs & Br,Stefan

20
S
Level 3

Badge Winners

  • Celonis Certified Data Analyst
    caroline.wende13has earned the badge Celonis Certified Data Analyst
  • Qualified to Prove Celonis Value
    rmandradhas earned the badge Qualified to Prove Celonis Value
  • Qualified to Build Views
    shahbaz.maniyhas earned the badge Qualified to Build Views
  • Celonis Certified Data Analyst
    justin.krajchas earned the badge Celonis Certified Data Analyst
  • Celonis Certified Data Analyst
    mahima.panthas earned the badge Celonis Certified Data Analyst
VIEW ALL
Community Code of Conduct