Product Q&A

Good afternoon, Essentially we want to remove all 2021 Data, but we would like to keep our "Resolved History" for Use Cases in Action Views, that rely on Augmented Attributes. Would removing 2021 invoices, for example, cause us to lose all "Resolved Invoices"? How can we preserve this data? Thank you in advance! Best Regards, Vasco Carona, Solvay

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?

Is there a way to automate the tasks captured by Celonis Task mining? I have captured desktop data/user actions for a task using Celonis Task Mining and data are loaded into EMS. After that, does Celonis provide any feature to automate (API or UI etc) those actions/tasks and run on any machine? Or need to use any RPA tool only for this automation?

For example, My KPI Query = SUM(Order Number) My KPI Component Filter is = FILTER NOT (ORDER TYPE = 'A') ; But; somehow I want to combine my component filter into the KPI Query? How can I do that?

Hi All,I want to upgrade a single workbench app in Machine learning.I do not want to disturb any other app present in the the workbench.Is it possible to do it?Please provide any documentation if present. 

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. 

Use Case:One View on which multiple PO items can be selectedUpon selection, an action pops up to create and send an E-MailThe selected PO items, along further information queried in the PA skill, should be bundled in one table and send in one e-mail Problem:By sending multiple PO items to the manual sensor of the PA skill, an e-mail will be created for each PO item, and then send multiple e-mails Question:How can I bundle the multiple selected PO items to one table and e-mail?

I would like to compare the chart and tables based on different dates. The date picker would be a good pick because it ensures that a valid date is inserted. Currently, the date picker is affecting the whole sheet. Is there a possibility to get something similar to a date picker that affects only one component on the sheet? Thanks a lot for the help Paul

we are having a bar chart with a single KPI but stacked by multiple selections. we want to set a default stack when no stacking option is selected when the dashboard is accessed. Is there any way to do so?  Snippets attached for reference.

Hello Peers. Have have a requirement from customer to calculate the Time Duration B/w Customer PO in Sales Order (VBKD-BSTDK) Vs Production PO (via PR MRP Run -MEPO_TOPLINE-BEDAT). Br/VM

Hello, I use my formula (CASEWHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-S%'   THEN 'South Saxony'WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-A%'   THEN 'Saxony-Anhalt'WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-W%'   THEN 'West Saxony'WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-B%'   THEN 'Brandenburg'ELSE ' ' END) to cluster values. Works great, except that it always gives me the ELSE values as 0 in my graph. 0 means that there is actually no ELSE, or in other words, everything is clustered. How can I hide the 0 in the formula or in the component filter?  thx :-)

Hey Peeps,  can someone help me. I try to connect, the correct PO to the corresponding SO in the IM Datamodel.See picture below.  I tried the BIND() and several PU functions.  Would be great if someone could help.  Thank you.  Daniel

Hello, I would like to count how many items have a crossing time under 1 day from activity1 and activity2. To calculate the crossing time, I used this formulated that I recorded in saved formulas: CALC_THROUGHPUT(FIRST_OCCURRENCE[<%=From%>] TO FIRST_OCCURRENCE[<%=To%>], REMAP_TIMESTAMPS("_CEL_P2P_ACTIVITIES".EVENTTIME, <%=unit%>)) Then I tried to write the following formula to do the count but it gives me an error: COUNT(CASE WHEN KPI(TEMPO DI ATTRAVERSAMENTO) =< 1 THEN 1 ELSE 0 END) Is there another solution? Thanks

Hi @all, I have cases like this A-B-C-A-B-C or A-B-A-C-B-C like a loop with 3 activities, I want calculate between A and C activities. Also I have activity attribute for example first A-B-C activities have "ORDER" column value "1" and second A-B-C loop have "2". How can I calculate this situation?Thanks, Selim

I have tables A, B, C, D, E which are connected as on attached scheme. I want to create an OLAP table which shows A, C and E data. I already have one OLAP with A + C and second with C + E but when I try to have A + C + E I get an error message. It is possible to join these tables?

Hello, could someone tell me where can I find the Celonis Process Repository?

===============================Usability of MarketPlace Connectors in "REALITY"================================= Hi Team,I have started my market place journey by installing SAP "Order to Cash" Connector. Below was my experience :1)I tried to install the app in studio but it gave multiple errors for the Data Model.2)I looked at the data model and tried understanding it. -There are no documents to understand why that data model is build in the way it is.3)I looked at standard SAP tables and tried to understand it by looking into transformation.4)Transformation does have big quereis and most of the places there is no explanation of what does those quereis mean.5)I finally reached SAP functional consultant and technical resource to help me understand the quereies.6)Currently i am working with them and reverse engineering to understand what has been provided with connector.7)Parallely i raised a ticket to Celonis support for providing comprehensive documents but they re

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 

How to search for a tag in the new data pool GUI?Since the data pools are presented as a list instead of tiles the functionality to search for a data pool with a specific tag attached seems to be missing. Unfortunately the search bar doesn't take tags into account and even the browser search (Ctrl+F) is useless because Celonis splits up the pool list into several pages. We have a lot of data pools and tags in use and without a filter for a certain tag I have to got through every page manually. Is there still a way to filter data pools on base of their tags? br Florian

Is there a standard in Celonis for stock transport orders with delivery in SAP?

Is there an easy way to move everything I have from a server to another? I.E., I'm going from eu3 to us1 and I'd like to duplicate all my analysis and workspaces in Studio

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

and always start with User ID. How can I fix it? When I use advanced CSV, it doesnt allow me to name the column. it automatically name as Column1 name, Column2 name etc.Thanks

But, I will have to keep these records once the system is processed and published using OLAP table in the Studio. So, for example the columns might be Record Number and Record Created Date (System processed date). What is the best way to do so?

I'm getting an error when trying to add a table to a data modelThe main problem is: it was working last week and, when I tried to re-run today, I got the following error: HTTPStatusError: Client error '400 Bad Request' for url I dont know what could be triggering it, specially because it was working before and I didn't