Product Q&A

Hello team,It would be great if the steps were guided in the format which gives answer to the question helps us to navigate the process.More appreciated if query is addressed ASAP.Thank you

how to extract data from file which is uploaded from file upload folder and create a data connection in data pool in celonis studio.

When a sales person is alerted by an action flow, can I know what activities the salesperson is doing as a result of the alert? i.e., Can I have a record in Celonis of the activities following the alert?

I wanted to calculate all documents processed by any user per day. Can anyone help with formula or explanation how it can be done​

Hi @janpeter.van.d​ / @Celopeers .​  I need to query Table A and look for all distinct Machinename . After that I need to update Table B, If Machinename exists so ok. If not, need to create new lines in Table B with 'No ID' field at location 

Which training track needs to be completed for BVA certification?

Our use case requires analysis on inventory stock levels, and the unit of measurement for inventory is cases so we would like to reduce the amount of confusion that could arise from this.

SAP Tables for P2P-Process Hello, is there any list where the required SAP Tables for the whole P2P Process are listed? If only the tables of the sample files are included, a lot of information is missing. Best regards!

Hi, Currently I am using the following: filter "tableName.csv"."TASK_TITLE" LIKE 'Condition1' which is filtering on a specific name.  How do I change the syntax so that it takes into account an additional condition? i.e. I want it to filter words that have a full stop in them. (condition 2 = '.') thanks,Terence

I encountered MS 365 connection error (per screenshot) during an auto scheduled refresh today. This auto schedule has been working fine daily for a week​ without any connection error. What could be the possible causes? Thanks.

Hi Team, Please show me how to display the "Allow CSV export of analysis components" setting.  It is displayed in another environment, but not in the specific environment.  I look forward to hearing from you. Best Regards,Satoshi Omachi

The selected Process Connector is not available for your database type. Please contact Celonis support. 

Team - we are supporting a user community that has been using the platform for over two years. As such, they have many apps that have been loaded over the period of time and the majority are not being used. We are looking for a report that shows the list of all the applications and what space they reside. Also, who published it and when and who last used it and when. This could give us a clear picture of what we can archive. Any suggestions or do you have a report to re-use? Thanks.

Scenario - We have 2 sheets - Dashboard and DetailedIn detailed sheet we have an OLAP table (for example) wherein we have company codes as dimension and count of documents as KPI.Question - Now, we want to automate dashboard with a TEXT COMPONENT which only shows me top 3 company code names basis count of volume (in descending order) in the OLAP table in detailed sheet.For Example - If we have 10 rows in OLAP table having 2 columns showing me Co. Code 1, Co. Code 2....Co. Code 10 and there is a value against each co. code.In Dashboard under TEXT component (TOP 3 least performers) - it shows me only those 3 co. codes based on OLAP table...it can be Co. Code 5, Co. Code 7 and Co. Code 10. Any guidance here will be really helpful.  thanks in advance.

Hi All, Is there any way to put data pool parameters for just rolling 12 months so that it can extract data for last 12 months only every time ? Can we define such parameter for extraction and what will be the syntax?

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?