Product Q&A

Hi Team, In our Data model we are uploading the data through csv using import from file feature, however we need to overwrite the data every week with new upload but need to keep the table name and structure same. I tried uploading new csv file with exact same name but it creates as another new table in the data model. Is there any way we can overwrite the data through csv upload? Thanks, Amogh

Hi, New to Celonis here. Is there way to write certain KPIs that do not get affected by selections & filters? Basically, I guess static variables that get sliced by dimensions? For example, on a OLAP table, if I was looking at Return Goods along customer dimensions and have Total Orders % (# of orders returned/ Total Order Count not respecting the return goods filter.). And if I change to a different dimension, I would want the KPI to recalculate too. Basically, if I filter to just returned goods, is there way to keep the total order count in the above formula refer to overall total count while being sliced by dimensions. Also, is there a recommended way to analyze such comparisons in general?

Continuing the discussion from Greetings!: Hi Im new to Celonis and i have a requirement in building an analysis. Below specified is the requirement. I have configured a Button drop down and it display all the Activites list. I created a variable (<%= ACTIVITY_GROUP_1 %>) to save the selection from the dropdown. I want to calculate the selected Activity count. Below is the formula im using to get the count and it giving me correct values only if i select a single Activity. When i select multiple Activities i can see the variable having all the selected Activities seperated by comma(,) but the result is 0. Can someone help me in getting the count of multiple Activities, and below is the formula im using. SUM( PU_COUNT(CASE_TABLE, _CEL_AP_ACTIVITIES.ACTIVITY_EN,"_CEL_AP_ACTIVITIES".ACTIVITY_EN IN ( <%= ACTIVITY_GROUP_1 %>))) Thanks & Regards, Chanti

Hi, I am possibly missing something obvious here - What is the difference between ACTIVATION_COUNT and INDEX_ACTIVITY_TYPE functions in PQL?

Hello Celonis and Celonis Users, There is a dropdown we like to create without showing the null values, The dropdown is based on the activity column, so some activities have null values in them. If I filter with: FILTER ACTIVITY_TABLE.COLUMN IS NOT NULL; I see the null value drop to the bottom: I have tried additional filters like: FILTER ACTIVITY_TABLE.COLUMN !=; FILTER ACTIVITY_TABLE.COLUMN != ; FILTER ACTIVITY_TABLE.COLUMN !=-; Best regards, Paul Velthuis

I was wondering if you have some insight on the following issue: (1) We added a new string field to our activity table (2) When it is populated with large values (actual content varies in length from 50 100) we see two things happen: Case explorer no longer loads (we just see a blue spinner)An olap table that tries to display this field reports a broken swap file: read invalid size error (3) When we force the value to have a fixed content of length (10) everything works as expected Are there some fundamental limits set on the activity table to limit its size and make loading (application end) more efficient? Is there best practice on the structure and size of the core activity table? image1116413 7.68 KB

I would like to add a column to case explorer from another table that is not the case nor the activity table. I am not using the cloud version of Celonis and I could not find a way to pull columns from other tables. There is a table that is linked to my case table, from where I want to pull a specific column which has comments. Is there a way to do this?

Hello friends!Will you be so kind to help with one issue:I have standard activity table: CASE_ID, ACTIVITY_NAME, EVENT_TIMEPlease find in attachment a sample of table.I want to make diagram chart (or OLAP Table) to show how many cases are being delivered at a certain month.For example -The activity Start of delivery for case #15 takes place on 05.01.2020 and the **next **activity End of delivery takes place on 10.06.2020. That mean that case #15 is being delivered on January, February, March, April, May, June.The activity Start of delivery for case #16 takes place on 07.01.2020 and the **next ** activity End of delivery takes place on 12.04.2020. That mean that case #16 is being delivered on January, February, March, April.So the diagram chart (or OLAP TABLE) should show followingMonth Case CountJan 2Feb 2Mar 2Apr 2May 1Jun 1Will you please clarify which formulas or functions I have to use.Thank you

HI, I found out there is a huge difference between using ISNULL(table.column) = 1 and different type of writing this formula (table.column) IS NULL. Do you have know from where this difference comes from ? Here is example from analysis: ISNULL(BKPF.KBR_KONT_FLAG) = 1 BKPF.KBR_KONT_FLAG IS NULL

Hello community, In my datamodel, the case key is BSEG.SID||BSEG.MANDT||BSEG.BUKRS||BSEG.BELNR||BSEG.GJAHR ||BSEG.BUZEI The LFB1 and the BSEG tables are linked (1:N) with the fields SID, MANDT, BUKRS and LIFNR. I have filtered my analysis as below: FILTER LFB1.SID =FC3; FILTER LFB1.MANDT =130; FILTER LFB1.BUKRS = CN01; FILTER LFB1.LIFNR = 0000115406; There are a total of 20 cases: COUNT_TABLE(BSEG) = 20. I am doing a PU_count of the BSEG cases to the LFB1. My understanding is that I should also get 20, but I get 29 ?!? PU_COUNT(LFB1, BSEG.SID||BSEG.MANDT||BSEG.BUKRS||BSEG.BELNR ||BSEG.GJAHR||BSEG.BUZEI) = 29 Do you know what could explain such discrepancy ? Thanks in advance for your help ! Clment

Hello,I am trying to export to excel data which contains a saved formula in some columns. I have downloaded Celonis APP for AP: Payment behaviour. I have noticed that when I change from saved formula KPI to formula directly, then there is no issue to export to excel. If I refer to saved formula in column value, then I get error Failed: Code 500.Is there a possiblity to export data to excel which includes saved formulas in column values?Thank you in advance for clarification

Hi all, I want to calculate the time difference between two activities in an OLAP table. Based on the amount of the time difference I want to use another unit. Is it possible to create a variable which gives you a result based on the row in the OLAP? For example: Event From | Event To | Time between Post Invoice | Pay Invoice | 30 Days Post Invoice| Cancel Inovice | 2 Hours This code in the variable will be only calculated once. Therefore the variable unit give me in the second row 2 Days instead of 2 Hours. CASE WHEN MEDIAN(DATEDIFF(ss, source(WFMT_EVENTS.TIMESTAMP), target (WFMT_EVENTS.TIMESTAMP))) < 120.0 THEN sec WHEN MEDIAN(DATEDIFF(ss, source(WFMT_EVENTS.TIMESTAMP), target (WFMT_EVENTS.TIMESTAMP))) < 7200 THEN min WHEN MEDIAN(DATEDIFF(ss, source(WFMT_EVENTS.TIMESTAMP), target (WFMT_EVENTS.TIMESTAMP))) < 86400 THEN h ELSE Days END

Hi Community. I am trying to put average of CS(Customer Satisfaction) on PE. The CS is based on Cases. I set Custom KPI like below. avg(case_tbl.cs) avg(source(act_tbl.cs)) They returned average based on activities. I thought PU functions would work and tried them, but they return the same value. avg(PU_MIN(case_tbl, act_tbl.cs)) avg(PU_MIN(case_tbl, source(act_tbl.cs))) avg1353839 98.7 KB Is there any way to calculate average based on cases in PE ? Thank you.

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

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

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

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

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?

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!

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.

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

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

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!

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!

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