Skip to main content

Product Q&A

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

3045 Topics
N
Level 3
neel.neelLevel 3
asked in Data Ingestion & Infrastructure
Component Filter using KPI as filter requirement

HelloI am trying to filter a OLAP table with the component filter. I have a KPI that is comparing three date values and is capturing the lastest date. I want to filter the OLAP table in the component filter where the Latest Date is blank to not appear in the table.I have tried the following and have been unsucessful:FILTER KPI(LatestDate) != NULLFILTER KPI(LatestDate) != Error message: Operator implementation could not be found or wrong types. Comparator is not implemented yet.Thank you

10
D
Level 1
5 years ago
N
Level 3
neel.neelLevel 3
asked in Data Ingestion & Infrastructure
Payment Term Null/Blank

Hello !I am trying to compare payment terms (ZTERM) from two tables: LFB1 & EKKOCurrently my formula below is not working because the cases where LFB1.ZTERM is showing as - in an OLAP table and EKKO.ZTERM has a value, is not marking it has Different Terms. I have tried ISNULL(column) and = and = NULL.CASEWHEN LFB1.ZTERM= AND EKKO.ZTERM != THEN Different TermsWHEN LFB1.ZTERM != AND EKKO.ZTERM = THEN Different TermsWHEN LFB1.ZTERM != EKKO.ZTERMTHEN Different TermsWHEN LFB1.ZTERM = EKKO.ZTERMTHEN Matching TermsELSE NULLEND

00
C
Level 1
5 years ago
K
Level 3
krzysztof.sitar11Level 3
asked in Data Ingestion & Infrastructure
Convert to Date

Dear All,in my source data I have a field that I need to convert to Date.My field mask is DDMMYYSerialnumbe and represents barcode.I have used TO_TIMESTAMP and SUBSTRINGTO_TIMESTAMP(SUBSTRING(BSEG.ZUONR,0,2)||.||SUBSTRING(BSEG.ZUONR,2,2)||.||20||SUBSTRING(BSEG.ZUONR, 4, 2), DD.MM.YYYY)Sometimes however bardode has incorrect format. Can I have a function that will convert to date if format is ok and leave NULL is format is not ok?

00
D
Level 1
5 years ago
N
Level 3
neel.neelLevel 3
asked in Data Ingestion & Infrastructure
Lastest/Greatest Date

Hello AllI am trying to capture the latest date of a field.Ex: For VENDOR 1234 which has three separate PO Dates:PO Entry Date 1/1/18PO Entry Date 3/1/19PO Entry Date 2/1/19I would like the result of this formula to display Most Recent PO Entry Date: 3/1/19Thanks !

00
C
Level 1
5 years ago
G
Level 1
georgia.loveLevel 1
asked in Data Ingestion & Infrastructure
Accessing all folders and analyses within a project

I have successfully connected via the python API to my Celonis instance.I can see that each folder or analysis has an attribute to access which project it belongs to. ie: folder.projectHowever, if i start from a specific project how do i obtain a list of folders and analyses within it?Im essentially aiming to get something like this to begin with:for p in Project.load_all():print(p.name)for f in p.Folder.load_all():print(\\t\\t+ f.name)for a in p.f.Analysis.load_all():print(\\t\\t\\t + a.name)

00
D
Level 1
5 years ago
S
Level 3
sarah.kraftLevel 3
asked in Process Analysis
Ignoring the troughput Time of a specific activity

Hello everybody, Im struggeling with the analysis for my thesis of an ITSM process and hope there is a simple solution, which I just overlook. Explanation: A service ticket is considered as solved in RESOLVED status, the status automatically changes to CLOSED status after 10 days, in any way. So, what can I do to deposit in ALL analyses that these 10 days do not flow into the troughput time never? DLZ.jpg848958 62.5 KB Thank you very much in advance

50
S
Level 3
5 years ago
.
Level 3
.14600836Level 3
asked in Process Analysis
Date picker - conditional formatting

Hi all, We use the date picker quite frequently in our dashboards; however since we are still loading data manually it is quite important for our users to see what the most current data available is. The date picker already formats the days until data is available dark grey whereas the color is light grey for dates where no data was loaded. Unfortunately, we have different countries with different data sets available (e.g. Data for Germany might be loaded until 15th of March 2019 whilst Bulgaria is available until 1st of April 2019). The date picker shows, in this case, per default always every day until 1st of April 2019 in dark grey, even when the user selects Germany (data only available until 15th of March). In order to not confuse users which date is the most current available data set Id like to add a color coding based on the selection of the country (so that when selecting Germany the last dark grey date is the 15th of March 2019). Any ideas how to do that? And, if not possible

10
.
Level 3
5 years ago
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
5 years ago
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,

00
D
Level 2
5 years ago
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)

50
K
Level 3
5 years ago
.
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

00
V
Level 1
5 years ago
.
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!

30
.
Level 4
5 years ago
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
5 years ago
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

00
D
Level 3
5 years ago
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 1
5 years ago
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

20
C
Level 2
5 years ago
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

10
S
Level 3
5 years ago

Badge winners

  • Value Assessment Expert
    vivuhas earned the badge Value Assessment Expert
  • Qualified to Prove Celonis Value
    vivuhas earned the badge Qualified to Prove Celonis Value
  • Celonis Technical Expert
    marcos.candi12has earned the badge Celonis Technical Expert
  • Qualified to Build Views
    marcos.candi12has earned the badge Qualified to Build Views
  • Qualified to Create and Deliver Demos
    Nikolai Hawlikhas earned the badge Qualified to Create and Deliver Demos
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 © 2024