Product Q&A

getting this error

Hi, I'm working on a first time fix calculation. The function flags a case, if there is a new case for the same serial number within 7 days. What I found out, is that the PQL window functions (such as Index_Order / Lead / Lag) are not taken into account any filters (even not on analyis level in the 'Load Script' area) or Selections. This is quite disturbing, since we use some filters to simplify the data set.  A workaround that I applied, is to include the filters also in the First Time Fix formula, but this is not preferably, since we have to state them twice, which could lead to mismatching when applying changes in the future (Load script section doesn't accept variables).  Is there a way to let window functions incorporate already present filters in the analysis?  Next to that, the behavior is quite unclear since the index is based on data that is not shown in the analysis when a 'Load Script' analyis filter is applied. Even if that is the intended behavior,

Hi @janpeter.van.d​ / @Celopeers .​  I'm trying to compare two dates from different columns in order to find out about a delay.  For this I need to (1) compare the highlighted dates in the red box (2) if the ETA is earlier than the Timestamp of the Activity "Ready for Pickup" I need to mark it with the value "1" in the respective column and line (as highlighted) [Note that the columns "ETA" and "Delay" are two manually created attributes within Celonis and were not part of the extracted data.] I guess I need to use a PU function here, but as I'm not very familiar with it I'd very much appreciate any help.  Thanks in advance anf brgds, Finn

Hello Team,I have created an report for SAP O2C in C4C's Analysis.The report I created appears to display correctly.However, I get an error message in the upper right corner of the screen.(I tried applying other data models to this analytical report and the situation was the same.) I am not sure what is causing this error message since I am able to display the report.How can I get rid of this message? Best Regards,

I have the following PQL Code and it is working. TABLE (COUNT( "AP_BSEG"."ZTERM" ),"AP_BSEG"."ZTERM"); How am i able to get the Max value from it? So overall the expression should give me the name of the most frequent value in this table column

I read the following message before: We have the AVG time cycle for a set of case and we want to obtain the % of cases with TC below de average and above average.I tried to do it in this way: CASE WHENCALC_THROUGHPUT(ALL_OCCURRENCE['Process Start'] TO ALL_OCCURRENCE['Cla. Closed'],REMAP_TIMESTAMPS( "AT_CLAIM_L1"."_TIMESTAMP" , days))>AVG(CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start'] TO ALL_OCCURRENCE['Cla. Closed'],REMAP_TIMESTAMPS( "AT_CLAIM_L1"."_TIMESTAMP" , days)))then 'TC > AVG'else 'TC <= AVG'END but I get the following message:The aggregation function AVG cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs. Which would be the correct way to have the information we need?  AND this was the answer:  Save AVG(CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start'] TO ALL_OCCURRENCE['Cla

 I would like to sum this resulting column up and get an INT for example.  CASE WHEN(  CALC_THROUGHPUT(FIRST_OCCURRENCE['Sendung elektronisch angekündigt']   TO LAST_OCCURRENCE['In der Region des Empfängers angekommen'],   REMAP_TIMESTAMPS("Amzn_activity_table_xlsx_Tabelle1"."TIMESTAMP", MINUTES))  >   GLOBAL(    AVG(    CALC_THROUGHPUT(FIRST_OCCURRENCE['Sendung elektronisch angekündigt']     TO LAST_OCCURRENCE['In der Region des Empfängers angekommen'],    REMAP_TIMESTAMPS("Amzn_activity_table_xlsx_Tabelle1"."TIMESTAMP", MINUTES))    )    *1.2)) THEN 1 ELSE 0 END 

It appears I cannot create a data job that extracts from a DB View. Is that correct? Is there a way to make that happen? It is easier to create the data within the SQL Tables vs bringing it into Celonis and then doing all the conversion. Mostly because I need to convert Key fields to get them to allow relationships. Is there a way around this or do we really have to ETL the data in Celonis? Worse case we create the views and dump the tables into XLS and import. I was hoping for something easier. Thank you.

Hello together, is it possible to set a datepicker for one specific component? I would like to compare two OLAP tables (first 6 months vs. last 6 months) in one sheet with individual datepicker each.

HelloI was doing this exercise of adding custom KPIs in conformance, and I am not able to get that at one place it is showing 78% and on the conformance it is showing 65.79%. What is actually going on here?

I'm looking for a drag & drop or move function. I could download and upload the .bpmn files, but they I'd lose the versions.

 After creating an Attribute, to have a specific column in my table in celonis, I cant access this column in the KPIs.How can I access this new column when working with KPIs? Thanks in advance!

I was thinking on using something like Name Mappings, but you can't. ​The idea was to have something in your _CEL_ACTIVITIES likeACTIVITY = '1.1'ACTIVITY_EN = "Receive Order"ACTIVITY_ES = "Recepción de Pedido" and then use only ACTIVITY for all the PQL codes I could need But the user will see the activities names in their selected language

Hi,How can I pull data from an Olap table in Package A in my Space, and push it to Package B in the same Space, using Machine Learning? I have a script that pulls data from Package A, but I am missing the second part, to push this data into the Package B

Where is the Problem in my expression and where can i find documentation that isn't blocked by Celonis firewall? When i try to open the celonis. help website i get blocked by the firewall no matter from what and where i try to access the website. Every help is much appreciated, thank you!

Data not visible even though I get a status 200

Is it possibly to use the ADD_WORKDAYS with a workday calendar in a Tranformation for the activity table in order to create the EVENTTIME field?

Hello, I have a line graph linked with time filter (year, month, week and days) but the dimension axis (x) is alway "month - year" despite the filter i select. When i select the filter week i would like to have the week in dimension, .... Any ideas ?

What does dotted lines depict in a Variant Explorer?

I am not able to interpret the difference between a column and a dimension

How to filter on count formula results? I'm trying to create a 'COUNTIF' PQL, something like this FILTER(COUNT("LFA1"."NAME1") >2 ). Is this possible in Celonis? Thanks!

hi there, I get the data into Celonis via DB Connection and in the table configuration I would to extract of last 3 years, is it possible to set a filter e.g. CreateTime >= systemdate -3 Years?

We are migrating all our workspaces from Process Analytics to Studio, and i was wondering how personal bookmarks can also be migrated to Studio.

My issue is that I want to track changes for Activities like: Activity 1 - manual - 0 (changes)Activity 2 - automatic - 0 (changes) Activity 3 - manual - 0 (changes)Activity 1 - automatic - 1 (change)Activity 2 - automatic - 0 (changes)Activity 1 - manual - 2 (changes) Each time the activity execution handling changes it should count +1.Goal: To get an overview over the sum of execution changes per Activity over all cases.  

May i know how to divide the one big analysis file into two and establish the link between these two files to make it as interactive for better performance?