Product Q&A

where do I go to enroll in a certification exam?

On click on a drop down button it should show more drop downs like cascading. Is it possible to add like that?

How can I set conditional filter in load script page? I have tried Case When, but it gives me error. Is there anyone who has suggestions? Filter "xx"."yy" = <%= option1%> (it works)  i want to do multiple conditions like that in component filter case when <%=option1> = 'a' than Filter "xx"."yy" = 'value' ;case when <%=option1> = 'b' 'than Filter "xx"."yy" = 'value2' end  Is there any way to add conditional filter in the component filter section?   

I noticed that PyCelonis has some functionality in adding records, variables and the like into Knowledge Models but I was wondering if there was a script or way we could mass import/add variables or KPIs from Process Analytics into a Knowledge Model. I've got a script that extracts and formats all KPIS and Variables into a pandas dataframe so it's just a matter of calling the right function. I don't really see any examples on the PyCelonis Github in terms of adding variables/KPIs

Hi, I have built three KPIs that calculate throughput times. Lets say: KPI 1: 20 hoursKPI 2: 30 hoursKPI 3: 40 hours.  Total: 90 hours. I would like to make a simple pie chart with all three of them in it. KPI 1 showing 20/90, KPI 2 30/90 and KPI showing 40/90.  The KPIs are calculated through different formulas.  Anyone knows how to make this simple chart?

I currently use this load script: FILTER MATCH_ACTIVITIES( "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN", EXCLUDING_ALL ['Record Goods Receipt'] ) = 1 But as far as I can tell this is only item level, so POs that have any item in which "Record Goods Receipt" doesn't occur still show up. I want to exclude any purchase order that has "Record Goods Receipt" anywhere in the process of any item in the PO.

We are trying to create a report which shows contract information with different validities. I can see the information in rows but ideally need them shown in columns.Layout in rows means I have 8 rows for 8 different validities but in columns this would reduce the number of rows massively

Hello everyone,I would like to get the variation and percentage variation of a KPI generated in a Knowledge Model.I would like to know if there was an increase between the last value of the KPI and the value of the previous month.I can't think of a PQL to do this, anyone has an approach? Thank you.

Any idea on how to counter this?

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

I am confused why we use Reload from cache, does it provide some kind of undo functionality? Also I am confusing it with Partial reload, are they same?

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

Microsoft 365 Excel in Action flow - After creating a table in an action flow, how do I name the columns? When I create a table, the columns are named Column1, Column2, Column3 etc. I am able to fill the rows with data from the Celonis Query but it would be great to name the columns. "Update Worksheet row" does not work for the first row, where the headers are and even if I select Table has no header. Add worksheet row requires a table on the sheet, so it does not allow me to change the top row. What can I do?

Hi, I got this chart in studio in a regular analysis and want to create the same chart in a view/km.The chart has as dimension ROUND_WEEK("ACTIVE_USERS"."DATE"). so it shows the value on a weekly basis,  How can I create the same chart in a view? the only way I found to have round_week dimension is to create a KPI in the knowledge model and use that but it does not nicely display the chart:How can I change the chart that it shows date for all values and makes the columns bigger with less space in between?Also I using a KPI the best way for the dimension? thanks  Roan

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