Product Q&A

unable to see the Name mapping file once successfully uploaded the file.

Hi Guys, I have a general question, I think I understand pull up functions wrong. So i need to use one to filter my olap tabel but the result is not as expected.In general i thought, if I use an olap tabel with one dimension X from Tabel A, Count(A.Y) is the same like PU_COUNT(Domain_Table(A.X), A.Y)? So I use the NAST tabel grouped by NAST.OBJKY and count the NAST.VSTAT. Now I want a second olap table which contains only entries with COUNT(VSTAT) > 2 and use the function PU_COUNT(Domain_Tabel(NAST.OBJKY), NAST.VSTAT) as componant filter, but it doesnt work right. Where is my mistake?  Thanks!

What exactly does the correlation number express in the root cause analysis in the conformance checking tool?

WINDOW_AVG (or alternatives) Hi all, I calculate the average cycle time from PO Item creation to Record Goods Receipt per material with the following query: PU_AVG ( DOMAIN_TABLE ( "EKPO"."MATNR" ) , DAYS_BETWEEN ( PU_FIRST ( "EKPO" , "_CEL_P2P_ACTIVITIES"."EVENTTIME" , "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" = 'Create Purchase Order Item' ) , PU_FIRST ( "EKPO" , "_CEL_P2P_ACTIVITIES"."EVENTTIME" , "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" = 'Record Goods Receipt' ) )) Now, I want to consider only the latest 10 PO items into the calculation based on the creation date. How can I do that? I tried the WINDOW_AVG function, but it does not work: WINDOW_AVG( <above query>, 0, 10, ORDER BY (PU_FIRST ( "EKPO" , "_CEL_P2P_ACTIVITIES"."EVENTTIME" , "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" = 'Create Purchase Order Ite

Hello PQL experts, Am looking for SAP Order Confirmation related KPIs ?  Eg : Number of Orders Vs Durations ( Days) .Any inputs is appreciated in Advance ! Br.Vivek

PQL question; I am trying to create a query that counts activities after a specific activity is captured.

Hello everybody,  I´m trying to create a quickFilter for one of my views.Problem as follows. I created a Filter in the KM and tried to generate multiple Filters. I tried multiple FILTER-Statements; seperated with a comma (,).I tried to combine the filter with AND expressions. I always see now results and, yes there should be results.  Currently, it looks like this:  FILTER        KPI(FORMULA_PO_ITEMS_OVERDUE_ORDERS_WO_GR) = 1 AND         "EKKO"."BUKRS" = '1000' AND        "EKPO"."KNTTP" = 'Q' AND        "EKPO"."KNTTP" = 'K' AND        "EKPO"."KNTTP" = 'P' AND        "EKPO"."KNTTP" = 'F' AND        "EKPO"."KNTTP" = 'E' AND        "EKPO"."LOEKZ" != 'L' AND        "EKPO"."MGWS_NONMGWS" = 'Ja - Direkt' Would be great if someome, can help.  Thank you.  Regards Daniel

Eg: casewhen table1. Column1 = table2. Column2 then 1 else 0 end. Will this give accurate result or any way we can compare 2 tables to calculate the result? ​

Hello Peers, I am now testing Data Push API by following the instruction of this course in Academy. Data Push API Basics - Data Push API Basics | Partner (celonis.com) Though I have updated my connection ID in body of "Create Push Job", the response after submitting the data job was like below and connection ID was null. Hence the data was pushed to Global Schema in my environment instead of the specified schema.I am attaching relevant information as follows. I would appreciate for your advice to push the data to the specified schema. I have been using Postman to test the functionality. POST URL and Body of Create Push Job:POST URL of Push Chunk:POST URL of Submit Data Job:I have double checked my connection ID was updated as variables correctly. Regards,Hayamu Takahashi 

I am not getting my badge after completing traininy

I didn't received the mail for my badge after my completion of the chapter! Can you look into it..

Are there any Best practices for Naming conventions for: For Data Integration: Tables / Views / Extractions / Transformations, etc.

Hi there,I have an analysis, that can be dynamically adapted with the help of variables, and I would like to create an Action flow (or skill) that sends a pdf Report of the analysis in different configurations. While the "Create PDF Report" module has an option to set filters, I was unable to find a way to set variables for the analysis.As a workaround i currently create copies of the analysis/sheets, save them in the desired state and use them to create the pdf. However, I would appreciate if someone knows a cleaner solution. Best regards,Joshua

Is there a demo execution app for procurement? The demo instances on TryCelonis on Procurement seem to be largely the traditional analyses.

Hello Peers, with the Celonis academic license I can't create on-premise extractors, while I can do it with the training licnese. Is this normal? What license would I need instead of the academic?

I created a custom "Process Explorer" KPI to show % ie Activity Count over Total Activity Count. This works fine when there are no selections made on initial launch of but when there is a selection made on a OLAP table the KPI goes blank. Please advice.

Hi all,  my Question is: is it possible to use a CASE WHEN Statement where the condition is a comparison between a variable and a string?Like:CASE WHEN <%=variable%> = 'value' THEN ... I work in Celonis Studio with PQL and created a variable in the Variables Section. What I want to do is filter a chart component depending on what timespan (hour, day...) I selected in a button drop down. Here is a code snippet:CASE WHEN <%=timespan_picker%> = 'HOUR' THENROUND_<%=timespan_picker%>(PU_FIRST (DOMAIN_TABLE... When I try it like this I get an Error which says: Table not found Thanks for your helpN.

SLA Breach notification - Can Celonis send the trigger notification to pre-defined emails based on the risk or likelihood of missing an SLA target? Ex. SLA for tickets in XYZ queue is 2 hours. 50 of those tickets have not been assigned and are 1.5 hours old. Avg time to resolve a ticket is 45 min. Can an action flow solve for a proactive notification to operations asking them to act on these tickets before the SLA breach?  

Hello, I have build an Action Flow where the result of a query is going in an Gsheet File. I am using the Gsheet action 'Add a row' but after each row i must delay 1 second for each now row. Do you an alternative solution ?

Based on understanding of Vertica SQL/Postgre SQL, following piece of script I am implementing to enable primary key. But even after successful, error free execution of these statements, I can see Celonis allows INSERT with same values. Can you help me in understanding if I am falling short on something to enable primary key? CREATE TABLE _CEL_ACTIVITY_PRIMARY_TEST(    _case   varchar(25),    activity_name varchar(100) not null,    eventime DATETIME not null,    PRIMARY KEY(_case)); SELECT * FROM _CEL_ACTIVITY_PRIMARY_TEST; INSERT INTO _CEL_ACTIVITY_PRIMARY_TEST VALUES ('1234','act1','2022-08-22T09:46:46');

Hello everyone, the uploaded picture shows my current problem. I need to transform an inputtable to get to the correct avg values as my output. 

I get the following error message when I attempt to upload a flat file (csv/excel): "There was an error during file upload. Please check your file type and content". Any suggestion how to fix this?

I am new to Celonis. I am trying to update the SAP extractor in a unix and to begin with i don't have clarity on what commands to use to stop and start the extractor in unix/linux. i see some batch file but they are more for windows and online not much detail are provided. Please help