General Product Q&A

Am trying in my Studio but nothing is getting updated or showing.

Hi - I tried executing the action flows named "Creating CSV file from Celonis output". I am not getting the results as mentioned, instead of this I am getting output as a direct values separated by coma (,). The result I am getting is given belowbut the result should be in the form of file as shown below.Kindly help me to fix this.

How to check whether after a certain activity , a transaction has occurred or not ? ACTIVITY_EN is the activity field and EVENT_TYPE is the transaction field

Dear Experts, I would like to calculate the percentage of stock out days that were longer than 5 working days.  I have a table with the information of SafetyStock and a table with the daily stock-level. Any ideas? Thank you! 

Hi, As an analyst, I want to exclude from the analysis pairs of invoices that have resulted in a credit note / (canceled invoices) Can you help with PQL query? Thanks,Guilherme

Hi - Actually I was trying to upload a flat file in file upload to analyse the data. After uploading I am facing some errors. I am attaching the screenshot of the error for the reference please let me know with the solution

Hi everyone, to show a graph with how many goods were not sent to customers (yet) on a specific date I followed the instructions of this example for filling ranges (Link). Dimension:RANGE_APPEND(ROUND_DAY("_CEL_O2C_ACTIVITIES"."EVENTTIME"), '7D', {d '2021-01-01' } , TODAY ()) KPI:RUNNING_TOTAL(SUM(CASE WHEN "_CEL_O2C_ACTIVITIES"."ACTIVITY_DE" = 'X'THEN 1 WHEN "_CEL_O2C_ACTIVITIES"."ACTIVITY_DE" = 'Y'THEN -1ELSE NULL END)) However, goods may be sent or received in multiple deliveries, thus leading to repeated activities.  1st Question: How do I only consider the last activity (and respective timestamp) per case?  2nd Question: How do I properly include this additional check, ensuring that all goods are actually sent out? (CASE WHEN PU_FIRST("VBAP","MSKA"."VBELN" || "MSKA"."POSNR","MSKA"."KALAB" > 0 OR "MSKA"."

Is it possible to change the timezone setting on Celonis or should it be done at a transformation level?

Hello experts, What kind of connections specific set up/configuration is needed on Celonis to Azure Data Lake file structure (currently data resides at the file structure level and probably at the Hive tables too and not in Azure SQL.)

how can i connect to db2 premise and db2 cloud. when I am trying to do giving me error

I created a PULL UP function as mentioned below PU_SUM(DOMAIN_TABLE ( "PR_CASES"."CUSTOMER_NO" || "PR_CASES"."CUSTOMER_NAME")  ,  CASE WHEN "PR_CASES"."CREATED_BY" = 'WF_PDP011' THEN 1 ELSE 0 END)This is to get the Total Automatic Ticket Creation per Customer. However, on trying to filter the column based on date picker field ("PR_CASES"."CREATED_AT"). It was observed that the PULL up function is not getting impacted and the value remains the same.Kindly suggest how to resolve this. Thank you in advance :) 

To protect client data, can I pseudonymize some credential data outside of Celonis before loading client-approved data into Celonis Cloud?

Hello everyone, for my current Usecase i need to upload a parquet-file (that is stored locally), to the data pool via File Uploads. When the file is uploaded i need to execute the referred datajob. The last step would be to press "Force Complete Reload" inside the Process Data Models Menu. These are all manuell steps. Is there a way to automate the whole process? best regardsAndreas

what is the PQL formula to find the rework time? for eg : we have the activity name as the dimension and i want the first occurrance of that activity to last occurrance of that activity (rework time) as the kpi in the OLAP table please help

Hi, I have a client calendar with their working days uploaded to my data model in a SAP TFACS format.  This TFACS table is also added to the model but not connected to any other table. I have done a complete reload properly already. When I go to my analysis and see the throughput time, it didn't change, even if I put all the working days to "0" in the TFACS table. It seems that isn't tacking into account my calendar. How can make it works in my analysis? Do I have to use functions to make the analysis use the new schedule?  Many Thanks, Paula.

I would like to know if there is any material related with customer retention. Any demo, success story or other material. Thanks.

We are trying to create an usecase as following:Calculate payment term mismatches between PO, MD, and Invoice with respect to time log of MD.How many times MD is changed per vendorFor this we have extracted the CDHDR and CDPOS data for zterm changes in LFM1, but unable to link the changes with invoices in BSEG and PO's in EKPO/EKKO table. Can anyone help me in this.

Good day, I recently signed up to the Celonis Partner portal from SoluGrowth. I am looking to complete the Sales Professional Course but cannot seem to find it in the Academy library?

When I create a new analysis with pyCelonis ("create_analysis(name, dm_name)" function) , adding the model I need, it seems good but the model does not be properly updated until I click the option "update" into the analysis settings sheet.  Can I do it with code too?. Please, anything I miss?. Thanks,

Hello everyone, we have an analysis sheet that we export as a pdf via action flow. In this sheet we normally filter on a specific plant number before exporting. We want to add the plant description in the analysis as a text field, but only if just cases of one plant are selected. When there are multiple plants selected, the text field should show "Multiple plants selected". I have tried to create a formula and add the result in the text field: CASE WHEN COUNT(DISTINCT "AUFK"."WERKS") > 1 THEN 'Multiple plants selected'' ELSE "AUFK"."WERKS_TEXT"END  This throws an error as I am mixing aggregate and case based info. I have also tried to add a PU_FIRST to the ELSE statement, but this does not help. Is there a way, how this can be done? Thank you for your help.

Hey there, does anyone know if it is possible to set a filter on single columns of an OLAP table? Thanks in advance! Best regards 

I'd like to set a button dropdown to a certain value when loading a page in a Studio Analysis.  I see the documentation talks about setting a selector's value, but I see no examples. What is the method of doing this?  celonis.cloud/help/display/CIBC/Load+Scripts 

Where can I get Sample data from try celonis ?

Hi, I have an Action Flow with 2 modules: 1. A "Execute Process Automation Skill" module --> which launches a Python Notebook2. A "QueryData" moduleWhen I launch the AF, module 2 starts without having finished module 1 with the launch of the Skill: Note: Output says is "Queued "but de AF is (bad) finished Is there a way in the Action Flow that module 2 does not start until the previous one has finished? Thanks in advance.