Skip to main content

Product Q&A

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

3023 Topics
D
Level 1
david.möstlLevel 1
asked in Data Ingestion & Infrastructure
Count vendors with one order

Hello everyone,I want to analyze how many vendors were just created for one order.What did work?I created an OLAP table with vendors and a simple case count.What is not working?I am not able to count the number of vendors with one case. So, I would like to have a KPI Number of One-Time-Vendors and it should show for example 150.Can anyone help me with this issue? It should be basically equivalent to an Excel countif.Thanks in advance.Best regards,David

01
D
Level 3
4 years ago
K
Level 3
krzysztof.sitar11Level 3
asked in Data Ingestion & Infrastructure
Pull and Aggregate distinct string values

Dear Colleagues,can you please let me know if it is possible to have the distinct string PU function applied in Celonis?In my specific case I need to know what currencies the vendors have used in the past. I can easily do the Count Distinct, which gives me the number of currencies, but I also wish to know what were these currencies. With PU_STRING_AGG I get the full list from all the documents, but I only need a string of distinct values - in my case USD and PEN. Can it be achieved?Of course I could create a separate Olap with currency as dimension, but the point is that this table needs to be used in Action Engine, so that is why I need it in single OLAP.Thank you in advance for any suggestions.image1560826 19.9 KB

02
K
Level 3
4 years ago
M
Level 3
mara.aderm11Level 3
asked in Process Analysis
Get the number of waiting processes inside a specific activity

Hi all, I want to get the sum of all processes waiting inside a specific activity over the time. I tried to solve this with Process Analytics as well as with Transformation Center but was not able to measure this. How can I do that? Kr, Mara

03
V
Level 1
4 years ago
C
Level 1
christian.turnbLevel 1
asked in Data Ingestion & Infrastructure
Component filter for Process Explorer

HI there,Can anybody help with the component filter to apply in order to focus the Process Explorer to include all pathways including the Change Price node.Many thanksChristian

01
C
Level 1
4 years ago
K
Level 3
krzysztof.sitar11Level 3
asked in Data Ingestion & Infrastructure
Calculate add months for leap year

Dear Colleagues,a simple question regarding function ADD_MONTHS. Is there a way to include in it leap year? I am calculating an expiry date for certain financial documents using formula:ADD_MONTHS ( ROUND_DAY(TO_TIMESTAMP(RBKP.BLDAT,YYYY.MM.DD)),3)So expiry is after 3 months of document date and if it is 29.11.2019, then the result should be 29.02.2020 instead of 28.02.2020. In excel we have function EDATE. Can we achieve something similar in Celonis?

01
D
Level 1
4 years ago
Z
Level 1
zachary.taylo11Level 1
asked in Data Ingestion & Infrastructure
Standard Deviation in Metrics

Hello,Im trying to set up Action Engine skills using standard deviations from KPIs to trigger the firing. However, its not the Action Engine part Im having trouble with, its the standard deviation calculation.Essentially Im trying to calculate the standard deviation of client abcs cancellation % from all clients cancellation %.Ive experimented with the STDEV function but because the cancellation % function already has AVG (an aggregate) it doesnt work.Cancellation formula:AVG(CASE WHEN AuthMgmt_Tasks.auth_outcome IN (Cancelled after work,Cancelled prior to work)THEN 1.0 ELSE 0.0 END)Hoping someone has experimented with this before, appreciate any help!

01
V
Level 1
4 years ago
E
Level 1
erin.ndrio11Level 1
asked in Entry Products (Celonis Free Plan & TryCelonis)
Celonis Snap - Frequently Asked Questions

Most frequently asked questions from Snap users: Q: Is Celonis interested in the data I upload? A: NO! Celonis has no interest in the data you upload. Learn more in our Trust Center. Q: What is the main difference between Celonis Snap and Celonis IBC Enterprise? A: These are the main differences: In Ceonis Snap you can upload ONLY up to 500MB.In Celonis Snap there is NO continuous integration with Event Collection as in IBC Enterprise.Features like Transformation Center, Workflows and Machine Learning Workbench are NOT enabled. Q: Can I use Celonis Snap for my own projects? A: Yes, as long as you dont exceed the limit of 500MB. Q: Can I invite other people to my team? A: Yes, you can invite your colleagues and work together in the same analysis. Q: Where can I learn more about pricing and editions? A: Click here to find out more.

04
E
Level 1
4 years ago
J
Level 3
jonas.westeLevel 3
asked in Data Ingestion & Infrastructure
Troughput-Time displays massively wrong results

Hey Celonis Community, If I want to show the average TPT between different steps in the Process Explorer the TPT shown should be around 1 to 30 days, instead it is now around Billions and Millions of days (see attachted file). (Same applies for the median TPT and the trimmed Median TPT as well as if I calculate the TPT by myself.) Is anybody else having this problem or can help me out? Thanks a lot! Jonas Process Explorer displays wrong TPT values945807 48.6 KB

07
D
Level 1
4 years ago
.
Level 3
.14600770Level 3
asked in Process Analysis
ABC function - wrong values

Hi, The division of customers into different classes only works for one case. Only the customers from Europe. For the customers in America and Asia there is exactly only one class. Each customer is classified as a C customer. I have not changed the code. Only the sales organization has been changed. If I remove this filter and look at it on a global level, the division works into different classes but not within the intended limits (B starts at 90%). The abc function is configured as following: CASE WHEN ABC(SUM(VBAP.NETWR_CONVERTED), 0.6, 0.20) = 1 THEN A WHEN ABC(SUM(VBAP.NETWR_CONVERTED), 0.6, 0.20) = 2 THEN B ELSE C END

01
.
Level 3
4 years ago
H
Level 2
hormoz.izadiLevel 2
asked in Process Analysis
Filtering for KPI

Hello, Is it possible to filter an OLAP table column for specific KPI values? Specifically, if we have an OLAP with some table attribute as the dimension and a KPI which calculates numerical values, is it possible to filter the KPI column for KPI(" ") > 0? Thanks!

02
H
Level 2
4 years ago
.
Level 3
.14600770Level 3
asked in Process Analysis
Aggregrate across columns

Hi, I have a table with these two columns: Name and Total Net Value. The dimension is a simple column (NAME1) from the KNA1 table. The KPI Total Net Value is calculated as follows: PU_SUM(KNA1, PU_SUM(VBAK, VBAP.NETWR_CONVERTED) ) Now, i should get all customers with the total net value. This should be fine. Next step, I want to create a custom KPI which should give me a cumulative sum of total net values from all customers. So, every row should have the same cumulated number in the third column. I want to archieve this with the global function. But unfortunately, this function can not handle PU_X function as aggregation How can I solve my problem here? Thank you in advance!

01
D
Level 1
4 years ago
.
Level 3
.14600774Level 3
asked in Data Ingestion & Infrastructure
Error too many stages in execute_like while opening analysis

Hello, I have loeaded my data model successfully but when i open my analysis there is no data (even the poucentage of cases). This error appears in all components : too many stages in execute_like Do you have any idea what causes this issue please an how can i fix it? PS: there is no filter applicable on the whole analysis and i kept the data model very simple. Thank you in advance

03
D
Level 1
4 years ago
K
Level 1
kenneth.ectonLevel 1
asked in Data Ingestion & Infrastructure
Stumped by one data element

Running a standard transformation, Im encountering an occasional source data error (e.g. an alpha in an INTEGER column). Of course, the script halts immediately. The source environment is highly customized and there will be a few of these. DataException: [Vertica]VJDBC ERROR: Could not convert R03B802 from column table.numeric_field to a float8 This error message does not reveal a row number. Im loading over 20M records, so going back to source to locate and fix each data anomaly and then going through a long reload each time ugh. I cant get to the juicy part of this great tool because of the time spent returning to source data, one element at a time, cleansing and reloading. Im new to this, but it seems like Im missing something simple here. Is there a way to patch data post-extraction?

01
V
Level 1
4 years ago
.
Level 1
.14600934Level 1
asked in Data Ingestion & Infrastructure
How to do a Running Last based on table

Hello all, I spent quite some time exploring all possible functions but Im unable to solve this.I need to do a running last based on the table as below. I will then use this to minus off the actual quantity. Ive explored the MOVING_X function, PU_X function and it doesnt seem to give me what I need. Any ideas? Appreciate the inputs!a869462 55.6 KB

01
V
Level 1
4 years ago
.
Level 4
.14600775Level 4
asked in Data Ingestion & Infrastructure
Filter Date Range

Hello Community,I am trying to create a data range for my analysis.I have the below equation which works:FILTER CASES.NetDueDate BETWEEN ADD_DAYS(TODAY(),-6) AND TODAY() ;However, i would like to replace the 2nd TODAY with the last day of the prior month - 6.Can you please let me know if this can be achieved in Celonis?Many thanks,Anna

31
V
Level 1
4 years ago
P
Level 3
pritam.roy20Level 3
asked in Process Analysis
Movement of Analysis from one Workspace to another

Hello Team, Can you please help how to move an analysis from one workspace to another with all the variables, filters and other stored details.

02
P
Level 3
4 years ago
J
Level 2
jacob.visse12Level 2
asked in Data Ingestion & Infrastructure
How to set up 2 filter criteria’s on 1 table

At this moment we have a filter on the extraction of the EKKO and EKPO which filter all orders and items based on the start date 31-07-2018.However, we want to add a second filter or expand the filter that fetches all orders starting with 37 which are in the EKKO and EKPO and started before before 31-07-2018.All other orders not starting with 37 must be retrieved via the previously set filter of start date 31-07-2018.The result must therefore be that we all pick up orders starting with 37 and the other orders only if they have been created as of 31-7-2018.How should we set up this filter?

07
J
Level 2
4 years ago
.
Level 2
.14600815Level 2
asked in Process Analysis
How to create OLAP table same as “cases to go” in a process explorer

Dear community, I would like to create an OLAP table same as cases to go in a process explorer. My data model is single eventlog which is consisted of process group, activity, and time stamp. If I could, Id like to show in the ratio as pie chart. Thank you for your support. Sugano

01
V
Level 1
4 years ago
A
Level 2
alex.hellwLevel 2
asked in Process Analysis
Filtering FTR analysis to only cases with “Clear Invoice” activity

Hello team, We recently began implementing a First Time Right analysis for SAP ECC using the most recent template from the App Store. One item we noticed was that the KPIs included in the analysis all filtered to only cases that included the Clear Invoice activity: Affected Net Order Value: SUM(CASE WHEN PU_COUNT(VBAP, CEL_O2C_ACTIVITIES"."ACTIVITY<%= language %>,CEL_O2C_ACTIVITIES"."ACTIVITY<%= language %> = <%= clear_invoice_activity %> ) = 0 THEN NULL WHEN PU_COUNT(VBAP, CEL_O2C_ACTIVITIES"."ACTIVITY<%= language %> ) - PU_COUNT_DISTINCT(VBAP,CEL_O2C_ACTIVITIES"."ACTIVITY<%= language %> ) = 0 AND PU_COUNT(VBAP, CEL_O2C_ACTIVITIES"."ACTIVITY<%= language %>,CEL_O2C_ACTIVITIES"."ACTIVITY<%= language %> IN (<%=rework_activities%>) ) = 0 THEN 0.0 ELSE VBAP.NETWR_CONVERTED END) FTR Ratio: AVG(CASE WHEN PU_COUNT(VBAP, CEL_O2C_ACTIVITIES"."ACTIVITY<%= language %>,CEL_O2

11
V
Level 1
4 years ago
.
Level 4
.14600775Level 4
asked in Data Ingestion & Infrastructure
Calculate Euro value but only for the past 6 months (moving date)

Hi Community, I am building an OLAP table and I would like to calculate the average value over the past 6 months. With the 6 month time frame changing as time go on. CASE WHEN ROUND_MONTH(ADD_MONTHS(CASES.PostingDate, -6)) THEN TRIMMED_MEAN(CASES.Value(EUR), 5, 5) ELSE NULL END I have tried various options of the above and cant get it to work. Can you please help? Thanks, Anna

03
.
Level 4
4 years ago
N
Level 3
naveen.guptaLevel 3
asked in Process Analysis
Creeating ratio between total count and corped count

Dear All, We are having a count of Sales Orders as a KPI. Then we are creating an OLAP table with orders coming from Quote and non Quote. Now we want to add a percentage / Ratio in OLAP table. When I try to add the COUNT(DISTINCT(VBAK.VBELN)) to the ratio, it doest give me the correct result. How can I achieve the same? Thanks

08
M
Level 1
4 years ago
.
Level 2
.14600831Level 2
asked in Data Ingestion & Infrastructure
Need help with the function to make a numberic quantity

Hi.We have function CASE WHEN KPI(FFF_TIME_PROCESS)><%=FFF_TIME_PROCESS_1%> THEN 1 ELSE NULL END.How I get a numberic quantity from function?With function COUNT it doesnt workDetails:in KPI(FFF_TIME_PROCESS) we have AVG(CALC_THROUGHPUT(CASE_START TO CASE_END, REMAP_TIMESTAMPS(EVENTS_EVENTS.EVENT_DATE, DAYS)))in variable <%=FFF_TIME_PROCESS_1%> we have AVG(CALC_THROUGHPUT(CASE_START TO CASE_END, REMAP_TIMESTAMPS("EVENTS_EVENTS.EVENT_DATE, DAYS)))

06
.
Level 2
4 years ago
L
Level 3
laura.lauraLevel 3
asked in Process Analysis
Button go to a link

Hello, The client would like button report to a link outside Celonis and also one go directly in Action Engine without go back on the Home. Is it possible to do it on Celonis? On the button option there is not choise for link. Thank you Best Laura

02
L
Level 3
4 years ago
L
Level 3
laura.lauraLevel 3
asked in Process Analysis
Percentage of variant with one case

Hi all, I would like to calculted the % of variant with 1 case, 2 cases, 3 cases, n cases I tried with KPI(Number of process variants) but I have not the result I would like. Thank you Laura

08
L
Level 3
4 years ago
.
Level 2
.14600794Level 2
asked in Data Ingestion & Infrastructure
Conditional formula based on selections

Hello, Is it possible to have component value conditioned by selections from a button dropdown? Ex: Button Dropdown (Country) options: Portugal / Spain / German If Portugal selected -> VBAP.BUS_UNIT_TEXT IN (FA, PA)If Spain selected -> VBAP.BUS_UNIT_TEXT IN (DI, MC)If German selected -> VBAP.BUS_UNIT_TEXT IN (SI, CP) Multiple selection possilbe. Thanks in advance. Best Regards, Joo Bu

02
.
Level 2
4 years ago

Badge winners

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