Solved

Lets imagine I have a line graph. My KPI is order count. My dimension is the months of the year whose data comes from Table A's column B. So my dimension is ROUND_MONTH("A"."B") Which filter I need to add to see only the last month?

I'm trying to upload a file on Celonis, but i'm not being able to and when I try, the following message appears: I don't understand. What are the illegal characters in the target? Why can't I upload the file?

Have you ever used EKKO as a case table? What is the EKKO's activity table ?

Both the functions are used to retrieve rework, what is the difference ?

Hello,  I'm attempting to create a data connection via .xlsx file on my computer. I created a space and then made the data pool connection alias. However, once i select "Connect to Data Source" and successfully connect my data, it does not proceed to make the connection.  Can you please help and or instruct me on the correct method to complete the next steps? (See images below)  Once I selected Esc, the remains equivalent to image one, any help is greatly appreciated.  Thanks!!

How to change the activity order?

Hello, I am using the Query Data module in an Action Flow. The output of the various date fields appears as below - instead of a regular date format like YYYY-MM-DD. How can I change the output of the column in Query Data?

What does dotted line means in the Process explorer?

Dear Experts , We wanted to understand the possibility of integrating Celonis EMS platform with third party BPM application like ARIS Connect to transfer discovered BPMN model from Celonis EMS to ARIS BPM application. Thanks in Advance. Regards,Navalan Veerapandian

Hi team, Is there a way to make Pareto charts in Analysis or Views ?It does not appear to be off the shelf, just wondering if someone managed to build one. It is a quite comon tool used in the process improvement field. Thanks

What is the difference between an eventlog and digital footprint?

I'm trying to kick of a manual sensor skill by using the execute process automation skill. Running this skill than triggers the manual input that is required in the subskill. Has anyone gotten to make such a link working? I'm struggling with not knowing where the issue exactly lies, since the error message is extremely vague.

CASE WHEN "AE_SIGNALS"."AE_SKILL_NAME" LIKE ('%Veredelung%') THEN COUNT ( "AE_SIGNALS"."SIGNAL_ID" ) * 30 / 60 ELSE NULL ENDI get the following error:The aggregation function COUNT cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs.

Hello everyone, I am writing here because I couldn´t solve my issue with other questions asked. My Situation: I have an OLAP-Table with a lot of Data and dates regarding finances.Now I want to add an Input Variable where User can input a single date.Depending on that input, the OLAP-Table should change (2 columns)The field is OPTIONAL and I am struggling with handling the case of "null" as input. My current idea: FILTER "Table"."SomeDate" >=  CASE WHEN <%=DATE_OPEN_ITEMS%> is not NULL      THEN TO_DATE( <%=DATE_OPEN_ITEMS%>, FORMAT ( '%d-%m-%Y' ) )     ELSE ignore the filter all together     END;  Now if I type in '31-12-2022' it works great! But 1. If the input field is empty there is an errorand 2. the User has to use ' ' while typing it in. Any ideas? Thanks! 

Hello,I need to display in an Olap Table only the “Codes” appearing twice or more (same code for different Building) : the user doesn’t want single “Code” but I am facing difficulties as I can’t put a count in my Case When statement. Do you know any way to do this ? Thank you for your time !Best regards,François  

Hi, I am setting up the data permission for our organisation.We want to grant access to certain data models by Profit Center.However a certain Business Unit may have more than one Profit Center. When I limit the access to a data model to these Profit Center, only the data associated with on of the Profit Center is shown in the Analysis in Studio. ExampleBusiness Unit A uses Profit Center Offline, OnlineTherefore the data model access is granted for Table.Profitcenter --> Offline, OnlineBut in the analysis only Profitcenter Online is shown Do you have any idea why the data permission works like this?Or did I miss something? I am grateful for your advise.Dan

How can I enable the Transformations Center in my Sandbox team? Currently I don't the the option in the "More..." drop down menu.

Hi, I have the following use case and challenge: Use Case: Add a line as second KPI to an existing column diagram that shows the average of a KPI value for each labor week Dimension: ROUND_DAY("TABLE"."TIMESTAMP") KPI 1: COUNT("TABLE"."NUMBER" || "TABLE"."FIELD") - columns KPI 2: Show the average of KPI 1 from Monday - Friday for each week - line My attempt: WINDOW_AVG(COUNT("TABLE"."NUMBER" || "TABLE"."FIELD"), 0, 5, ORDER BY("TABLE"."TIMESTAMP"), PARTITION BY(ROUND_WEEK("TABLE"."TIMESTAMP"))) This does not work unfortunately as I can not use the COUNT within the WINDOW_AVG function. Does anyone know any alternatives?

Hi, we have a requirement to restrict extraction of purchase orders to last 2 years. We are planning to go ahead with ERDAT from EKKO table. But what about other tables like T*, CDHDR and the rest. How can we restrict data extraction in those tables? Also, How can we make EKKO as a parent table to consider the extraction of the rest of the tables based on the data from parent table like EKBE-EBELN = EKKO-EBELN?

I could able to successfully establish connection between SAP ECC and Celonis EMS standalone and the test extraction works fine. Now when I try to install standard SAP O2C connector with this connection, I get the below error. I dont get this error if I test the connection defined outside the connector. Request your inputs. 

In celonis documentation in one place it says to setup extractor server for SAP HANA , and in another place it says to access data using API . So , a bit confused on this . Any help is highly appreciated. RegardsAyan 

Sometimes this options shows up and sometimes it doesn't. Should it be manually input in the code?

Greetings,is it possible to display custom messages, defined in the python script of the celoxtractor, in the real time log of a extraction (when the extraction gets executed)? We are currently writing debug messages to local logs on the celoxtractor server. Having it directly in Celonis would be a blessing. Best Regards