Product Q&A

Need a Custom formula for center alignment of data in specific column of OLAP

I tried connecting it via standard key fields (MANDT, VBELN, POSNR) but they seem to be shipment/delivery numbers and not sales order ones, so I tried connecting it to delivery/shipment tables but that doesn't seem to be working properly either. The goal is to get the carrier number from VTPA table and corresponding sales orders numbers.

How can i do center alignment of values in olap table

During Step 4: Does this step generate a flat file or is all data held in memory?

Celonis Studio: I am unable to access the Studio for the Course Building ananlysis - Basics. Need you help please

Everytime i try to use the following query i get an eror message. It looks like this type of query with "LIKE", "CONCAT" and 2 wildcards is not allowed. Is there any possible solution?

Hello,I need to prepare a project plan for Task Mining + Process Mining. We've implemented Celonis many times for Process Mining and have standard ways of working. But for Task Mining, we will do it for the first time, and I am missing some details such as timeliness, milestones, and main deliverables. Could you please share your experience? One more thing, Task Mining is based on C4C+, not EMS.Thank you for the help! 

In my project we are looking to open SAP system directly from the Celonis Analysis. E.g. if I select an PO from Analysis, and click on Button to Open SAP system. Button should redirect to SAP system with the the table from where ussr can take action on that particular PO.

Hi guys! I’m trying to apply a particular filter to a dataset with many activities. The scenario is as follows. The raw event log contains activities done in a general hospital for over a year.If I want to get the process for a specific activity, I would normally just filter ‘Include only cases that contain ‘Knee Replacement Surgery’.  However, because there is so much going on in the hospital, such a filter is not enough. For example, if a person underwent a knee surgery is june 2021, the process map will also try to include other procedures that this person did in january 2021 or december 2021, even though these have nothing to do with the knee replacement surgery. For that reason, I’m trying to narrow the filter down as follows: “Provide an event log that only includes data of a maximum of 2 weeks in the past after the activity ‘Knee replacement surgery’ and a maximum of 2 weeks after this same activity.” Note that this is NOT the same as applying a general time filter on the event

I use free version and I crossed APC limit and then I deleted everything it's been already 4 days the APC consumption is not updated, the last APC consumption is updated days ago . How much I have to wait or is there any way that I can reset it manually ?

Is there a possibility to prevent sharing of analyses as bookmarks via permission? Using Celonis 4.7 everyone can share bookmarks. Is there any possibility to create groups and share bookmarks only in this group? Thanks for the feedback

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: https://dell.us-1.celonis.cloud/process-mining/analysis/v1.2/api/analysis/325c3e97-3a13-4c7a-b818-ac392eebd840/bookmarks/809dfc8f-86c4-4210-9818-a4b2734543c6 During handling of the above exception, another exception occurred: HTTPError Traceback (most recent call last)/tmp/ipykernel_16778/3654934662.py

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 everything for you to get started quickly.  For technical inquiries or academy-related questions, please reach out to academy@celonis.com. Happy Learning! https://academy.celonis.com/courses/set-up-your-order-management-execution-app-3kcr  

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!