Skip to main content

Product Q&A

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

4385 Topics
T
Level 2
tomas.kvapiLevel 2
asked in Data Ingestion & Infrastructure
Load Failed: Cycle in joins detected

Hi, After upgrade of Celonis to 4.5, I am experiencing the new issue in one of my models. Please see an error in the attached screenshot. cycle.PNG951196 16.2 KB Ive been able to find just a short explanation of the error HERE Is someone else facing this kind of issue? How did you solve it? Thanks, Tomas Kvapil

70
T
Level 2
R
Level 2
rahul.jonna11Level 2
asked in Data Ingestion & Infrastructure
How to count sales order (VBAK) that under goes activities?

Hello Everyone,I hope you all doing good I would like to see how many orders that are going through Credit Check. Normally, thecredit check was executed on the Header level, which means we do not care about position lines. But in the Celonis the activity is defined from Order item not from the order header level.In order to see the total number of orders that are going through credit check , I have implemented PQL codeAsCOUNT((CASE WHEN _CEL_O2C_ACTIVITIES.ACTIVITY_EN IN (Deny Credit Check,Approve Credit Check)THEN " VBAK".VBELN ELSE NULL END))/COUNT_TABLE(VBAK)But still it counts the activity.Do you have any idea, how to count only sales orders for an activity by using any other function?Thanks in AdvanceWith regardsRahul

10
R
Level 2
steven.bernd
Level 3
steven.berndLevel 3
asked in Data Ingestion & Infrastructure
changing Case_ID - How does it work?

Hello, i want to visualize a big process in Celonis. This process runs through several systems. I now have the problem with my CASE_ID because they change through the process. This means, for example, that the process begins with a measure number, later the measure number becomes an order, and in the end this order becomes another order. So the 1: 1 relationship is given, but I have to consider the change of the CASE_ID. Can someone help me? Example: Step1: 700350000 Step2: 6125600 Step3: 6185600 thx.

10
B
Level 1
.
Level 3
.14600898Level 3
asked in Data Ingestion & Infrastructure
Distribution of Eventtimes for Specific Activities

Hi together,I have the following question. To check if a SAP batch run for the invoice creation is scheduled at the best time I would like to check when the manual invoice creations occuring normally at a day.For example:Batch runs at 15 PM, but most of the invoices are created manually at 10 AM (for whatever reason). So it would be maybe better to run the batch at 10AM.Im thinking about a graph or diagramm whichs shows me the time as a dimension (in hours, 8AM, 9AM and so on) and the number of invoice creations at the different points of time at a day.Is something like this possible? Are there any suggestions?Best regards,Friedemann

00
B
Level 1
joos.buijs
Level 6
joos.buijsLevel 6
asked in General Product Q&A
Add applied filters to print version

Issue: As we are building more and more dashboards we realize that some dashboard sheets are printed and spread, for instance in Obeya rooms. However, there is no way to include the applied filters, unless you make a screenshot, and therefore it is unclear what the printout represents. Feature request: Include the applied filters either in the print version, or make them available via a macro such that these can be added in a text field to be added to the dashboard sheet, and therefore will show up in a printout of the dashboard sheet.

00
joos.buijs
Level 6
joos.buijs
Level 6
joos.buijsLevel 6
asked in General Product Q&A
Feature request: Allow multiple case/activity notions within the same data model

We have connected Celonis to our central data core. This means we have data of over 700 processes in one generic table structure (case, step, process, client, etc.). However, this also means that if we want to have different case notions (for instance one analysis has a process as scope and hence case=case, while another is focusing on customer journey where case=client). Currently this means we have to load in the data twice (or more), with different activity/case notions set. This means duplication of the data. It would be nice if this setting could be data model independent (or: one data model has several case/act notions from which the dashboard can select one). Im aware of the process explorer option to change the activity attribute, but my request/suggestion is also concerning the case notion.

23
M
Level 1
R
Level 2
rakesh.paul11Level 2
asked in Process Analysis
Custom Sorting of Dimension in Combo Column Chart

Hi Team, We want to make one Column Chart, where X-axis (Dimension) have a data point like (0-3 Days, 4-6 Days, 7-9 Days, 10-16 Days & 17+ Days) and KPI will have such as PO Lines Pending & PO Pending GR Amount. But the issue is sorting not working properly, its sorting randomly. Is there have a way to custom sort the Dimension. Regards, Rakesh Paul

100
V
Level 1
F
Level 3
francesca.licanLevel 3
asked in Data Ingestion & Infrastructure
Is there a limited number of conditions that can be added in the CASE WHEN function?

Hello community,at the moment Im working on defining a drop down bottom to filter Production Order having Bad Conditions or without Bad Conditions.To do so, I use a code like the one below.Unfortunately, the amount of possible Bad Conditions is so high that after a certain number ofMATCH_PROCESS I get the error:image.png891111 7.46 KBBut if I separate the formula in 2 pieces, then I get the desired result.However, Im not able to combine the 2 pieces together and I should have multiple drop down lists as a filter not practical.Do you have better ideas?At least do we know if there is a real limited number of conditions that can be added in the CASE WHEN function?Many thanks,FrancescaCASE WHEN** MATCH_PROCESS** (LOOP[A] AS loop_A,LOOP[B] AS loop_B,LOOP[C] AS loop_CCONNECTED BY DIRECT [loop_A, loop_B], DIRECT [loop_B, loop_C])>0OR **** MATCH_PROCESS (LOOP[A] AS loop_A,LOOP[B] AS loop_B,LOOP[D] AS loop_DCONNECTED BY DIRECT [loop_A, loop_B], DIRECT [loop_B, loop_D])>0OR **** MATCH_PROC

00
F
Level 3
J
Level 2
jacob.visse12Level 2
asked in Data Ingestion & Infrastructure
Issue with inner join in PQL

We want to execute in PQL the following SQL code:SELECT SUM (BD2.betkortbedr), BD2.CrediteurFROM BSAK_DEF2 BD2INNER JOIN LFA1_BEW_CSV LFA ON BD2.Crediteur = LFA.CrediteurWHERE LFA.Flinqer IS NULL AND (BD2.Korting1 > 0)GROUP BY BD2.CrediteurBut the join is not fully discribed in the PQL documentation.Does anyone have a sugestion how to solve this with PQL?

100
M
Level 1
S
Level 3
sasan.babaz12Level 3
asked in Process Analysis
Creating a drop down Button for a specific table

Hello, I try to create a Button drop down component for just a specific table in my analysis. So when I filter with this button, just this specific table is effected. Can anyone help me how to implement this? Best Wishes Sasan

140
S
Level 3
marco.muenc
Level 3
marco.muencLevel 3
asked in Process Analysis
Reference Date view in analysis

Hi, in an Accounting use case we are looking for sales order items, where a goods issue was already booked but no invoice was created yet. That works fine with the process functions and shows always the cases where this situation is currently valid. My question: Is there a possibility to show also the situation at a reference date? So for example that you can display the amount and value of sales order items that have been in this so called ship to bill stock at 04/30/19? Thank you and best regards, Marco

00
marco.muenc
Level 3
david.werner
Level 4
david.wernerLevel 4
asked in General Product Q&A
End-to-End Process thinking

Hi everyone, with an increasing number of datamodels there might be an increasing connection between the data models for certain aspects. With the functionality of a button, you are currently able to jump between certain analyses even between different projects/data models. Still many data models use same base tables, like customer/material/ or other information. In many cases a complete end-to-end process cannot be covered within a single data model in a reasonable size/complexity of the data model. Thats why most of the times Order/Development/Planning/Production/Accounting/ are covered within seperate data models, even though there are information that are used in all of those data models. Would it be possible to enhance the functionality of jumping between analyses with matching certain attributes between the data models (easiest way would be if the same tables/attributes are available) to keep the filters without manually re-selecting them in every analysis you jump into? That wou

11
M
Level 1
S
Level 3
sarah.kraftLevel 3
asked in Process Analysis
Rounding error when dividing

Hello, I was trying to get the Median of a column. But no matter which way he calculates, he just gives me a rounded number. Even if I enter the numbers manually, the correct solution would be 4.54. Anyone have any idea what it is? Rundungsfehler2.png938969 33.4 KB Rundungsfehler.png873927 50.9 KB Thank you in advance

30
S
Level 3
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

60
D
Level 2
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

130
C
Level 1
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?

70
D
Level 2
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 !

10
C
Level 1
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 2
joos.buijs
Level 6
joos.buijsLevel 6
asked in General Product Q&A
Export to clipboard option

I often export results: to Excel, PDF of PNG. However, even more often I make screenshots/screen clippings of charts/items to paste in e-mails, presentations, notes, etc. It would be really neat if the visual representation of a component (/sheet) could be copied to clipboard as an image to be pasted later on.

132
joos.buijs
Level 6
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

70
S
Level 3
.
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

20
.
Level 3
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

Badge Winners

  • Qualified to Create and Deliver Demos
    julia.portehas earned the badge Qualified to Create and Deliver Demos
  • Qualified to Create and Deliver Demos
    jauhar.khalihas earned the badge Qualified to Create and Deliver Demos
  • Celonis Certified Data Engineer
    Jonathan Incroccihas earned the badge Celonis Certified Data Engineer
  • First Post
    emilia.stepihas earned the badge First Post
  • Qualified to Build Analyses
    Pranavnhas earned the badge Qualified to Build Analyses
VIEW ALL
Community Code of Conduct