Product Q&A

How to get a 3month or quarterly filter in the dashboard.

I am curious how much data can we extract and store in celonis ems for both free training use and production use?

---------------------------------------------------------------------------HTTPError Traceback (most recent call last)~/.local/lib/python3.8/site-packages/pycelonis/celonis_api/base_objects/ibc.py in api_request(self, url, message, method, timeout, get_json, threaded, **extra) 273 try:--> 274 r.raise_for_status() 275 except exceptions.HTTPError as e: /opt/conda/lib/python3.8/site-packages/requests/models.py in raise_for_status(self) 952 if http_error_msg:--> 953 raise HTTPError(http_error_msg, response=self) 954  HTTPError: 404 Client Error: Not Found for url:

For example, for the activity create the invoice i don´t know if i have to calculate the indirect emisión for this activity and how to do it, perhaps in activities like send a order, it is posible to measure the emisión for the parcel, but i don´t know which is the right way to calculate the emissions for an activity in a process. Thanks in advance.

How can i pull data from studio analysis using ML

For HR process - Time to Issue Resolution what will be the ROI

Hi when ever i load a data in Data Model its creating two tables one the table which i uploaded and the other by name CASES, i would like to know on what basis this CASES table is been created in Process Data Model

Hello, everyone, I would like to add my KPI "SUM(CASE WHEN (LEFT("COEP"."KSTAR", 1) IN ('6','9')) THEN "COEP"."WTGBTR" ELSE NULL END)" to the component filter to hide the 0 values. What do I have to pay attention to here, because FILTER SUM(CASE WHEN (LEFT("COEP"."KSTAR", 1) IN ('6','9')) THEN "COEP".."WTGBTR" ELSE NULL END) != 0 does not work. Greetings

Hi everyone,  I have an Analysis where i can filter on specific time periods. I added several Variable Inputs where the user can type in dates and times (Start date and end date + start time and end time, e.g. '2022-07-10', '2022-08-10', '15' ..). (See Screenshot for details) Whatever the user types into the Variable input field is then assigned to a Variable. Now I also added a Button who should set the variables to a predefined value (like a reset button for the filter). As the end date I would like to use the todays date but unfortunately the TODAY() Function cannot be added as a value for a variable.  Do you have any ideas to solve this problem? Best, Niklas

##### Order Management App News ##### Dear UsersI am happy to share some news!We recently have launched our technical enablement Set Up Your Order Management Execution App (access it here).If you are technically skilled, and currently (or soon) implementing the Order Management app this course is perfectly suited for you. The aim of this enablement is toExplain and distinguish the three Order Management App modules.Set up the Open Order Processing module.Apply customizations on filters, views, KPIs, and tasks.Create and adjust Execution Gaps.Get support for order management solutions. The training takes between 30-60 minutes to complete and includes ever

Hello, I am trying to create with python an Studio-Analysis Script. I am having some troubles adding a new sheet (when is the first one in the analysis) and a new component. Any tip how to figure it out? Many thanks!

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

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

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 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.