Product Q&A

The PU AVG functiis on is used when you want to display the overal average order size for the entire firm through the different months of the year.

Hi, I am trying to calculate the throughput time of each rework loop using Source- Target and failed due to no-common table errrors. My code is like below:Minute_Betwen( Source("_CEL_O2C_ACTIVITIES"."EVENTTIME", remap_values("_CEL_O2C_ACTIVITIES"."CHANGED_TO", ['ZA','ZA'], Null)), Target("_CEL_O2C_ACTIVITIES"."EVENTTIME",remap_values ( "_CEL_O2C_ACTIVITIES"."CHANGED_FROM" , ['ZA','ZA'], Null))) I got the errors that no common table found since both Activity table and temporary table for Souce/Target are N side.Do you have any ideas how to work around this?

I want to have the data in text box with some background colour, So it may look appeling. I tried using the HTML componets like style and background, I'm not getting result.Please suggest me some ways to handle it.

Hello everyone, I would like to ask what figures and roles should be involved in an EMS project implementation? Is there a training track where I can find more details? For example, beyond the PM, the Value Architect, the Data Connection Expert and the Technical Expert, is suggested to involve and train someone else? Thanks

Can someone please help me with the On Time Delivery rate, Perfect PO rate, and No touch rate PQL formula?

Has anyone any experience or resources in using Process Mining to evaluate users interacting with a SaaS product and generating an event log. My data shows the events of user sessions and I'm interested in both session and multi-session journeys.

How we can implement 'Expression Language" in Celonis?

In the Partner Training Overview it is said that to become a partner you need to have at least 6 expert badges distingusihed into, at least, 1 Value Assesment Expert, 1 EMS Technical expert and 1 Value Realization Expert. Hence, these 6 badges must be held by a minimum of 2 people. Then it is said that the minimum time investment is 100 hours (all trainings and exasms). I don’t understand if these 100 hours are to be splitted between two people or 100 hours of training refers to the minimun hours required by each of the two people. Furthermore, I tried to deepen into the partner enablement program and I analysed the training required for each of the three types of expert solutions Celonis provides. Even in this case I cannot find a connection with the 100 hours. Can someone help me identifying the correct time estimation to become a Partner Organization? 

Hello, I am trying to frame the difference between Celonis for Consulting collaboration models and the EMS implementation. It is correct to say that with the C4C I will be able only to perform the discover collaboration way, while I would need the Partner Enablement Program Certification to deliver also in the execute and in the operate collaboration model?  Furthermore, wich is the concrete difference between execute and operate? Can you provide some practical examples? 

Variant and Process Explorer not filtered when using CALC_CROP in load script  How to ensure that Variant and Process Explorer are filtered when using CALC_CROP or CALC_CROP_TO_NULL in Load Script (Analysis/Tab/Component). When the crop is done through Selection Views, it works correctly, but when the crop is done using PQL in Load Script, filter does not work for Variant and Process Explorer. Examples below: FILTER ISNULL(CALC_CROP_TO_NULL(FIRST_OCCURRENCE['XXXXX'] TO CASE_END, ACTIVITY_COLUMN())) = 0 Or FILTER CALC_CROP ( FIRST_OCCURRENCE['XXXXX'] TO CASE_END, ACTIVITY_COLUMN()) = 1  Thanks 

For joining tables by timestamp I need to round by the minute. I found date_trunc listed as supported function but can't get it to work. update TABLEset MATCH_TIME_START_MINUTES = date_trunc('minute', TIME_START); gets me this: Execution error: ERROR: Function date_trunc(unknown, varchar) does not exist, or permission is denied for date_trunc(unknown, varchar) TABLE.TIME_START is converted with to_timestamp() before and then looks somewhat like '2022-02-20 01:04:32'. How can I "round_minute" in data jobs?

Can someone please help me with the Automation rate PQL formula, when we have the User type as A and B?

Is it possible, that I create an OLAP table or a histogramm, that categorizes by, lets say 5 different amounts of attributes, and sums the number of cases that belong to one of those categories?Here is an example: Case 1 has Attribute ACase 2 has Attribute ACase 3 has Attribute BCase 4 has Attribute CCase 5 has Attribute DCase 6 has Attribute ECase 7 has Attribute ECase 8 has Attribute ECase 9 has Attribute ECase 10 has Attribute E  -> My table should show: No. of same Attribute Case Count5 /// 5 --------------(cases 6,7,8,9,10)2 /// 2 --------------(cases 1,2)1 /// 3 --------------(cases 3,4,5)   I only want to display the Case Count per No. of same Attributes. Furthermore I want to filter on for example all the cases that have the same amount of attributes.  Would that somehow be possible to Create such a table or histogram within Celonis? Best regards

Hello Do you have any case studies using Celonis for eWM data model within S/4Hana Cloud? Thank you

Data Upload execution 581859e5-c443-4108-b042-0b9838112fd9 has failed. Failure type OTHER_CONVERSION. Failed to parse text in CSV. Length of parsed input (15001) exceeds the maximum number of characters defined in your parser settings (15000). line=297954, column=39, record=42988, charIndex=90270185 caused by Failed to parse text in CSV. Length of parsed input (15001) exceeds the maximum number of characters defined in your parser settings (15000). line=297954, column=39, record=42988, charIndex=90270185. Celonis Support ID: ef2703fe-10f5-4845-9b87-f67953166d29

The same function was working a week back, but we are recently noticing that api_request() is not an attribute of Celonis anymore.  Same goes for Celonis.pools() function as well. where it displays the list of data pools available. Any inputs on how to tackle this issue is much appreciated. TIA! 

Hello team,​I'm unable to find pie chart and radial component in view.can anyone please help me with this.thank you in advance...

Hi, is there a unique repository for all Industry wheels?I was able to find only the value trees in the Celonis Library.Thanks for your HelpW.

Hi all, I have exported my data pool as a .json file but I have not found a way to import it via a button in Celonis or via CLI. Is there a solution to import the file into Celonis? Thank you.

I have created KPI List and Add on Title name but It was showing Title Name And KPI name How to hide KPI name.??

In the doco, there is a description of how to connect different teams to one extractor but not how to configure this for Linux. Any ideas? https://docs.celonis.com/en/how-do-i-connect-to-multiple-teams-with-the-same-extractor-.html

I have 3 tables:Fact Table A with n entries per case and a time dimension (round_hour)Case Table which containts the case keysAnother Fact Table B with m entries per case and a time dimension (round_hour)The data model is n : 1 : m. Unfortunately a generel snowflake model is not possible. Now I need to sum up the duration from Fact Table B aggregated by the time dimension from eventtime2 (round_hour) and display the sum in a chart. The time dimension for the chart is represented by the time dimension eventtime 1 from Fact Table A (round_hour). I tried bind, domain_table in combination with PU-Functions but nothing worked.  Is there a any way map those time dimensions from different fact tables with a n : 1 : m relation? 

Hi, I am receiving "Column name is reserved" for a particular column in table that is causing the complete extraction of that table to fail Is there any way to change the name of column while extracting ?

Do you have any experience with exporting Celonis app into another tools? I was hoping we could not only expose raw data but allow data discovery (inc. process explorer).

I’m trying to create an Action flow and Action skill to generate a PDF report of the Studio Views, but I’m only able to generate for Analysis sheetsdo we have an option to generate a pdf report of Views?