Product Q&A

Iam trying to find out or compare RC vs Delt job vs Full Load, when to use and why

How many characters are supported for naming convention for any object in Studio? For example if I am naming a ID for a KPI, how long can I keep the name? Do we have a constraint in that?

I have the PQL query as follows:  it returns:   How can i amend my query to remove the '0' counts for processes that do not have any rework on them? Thanks

What is the best way to have a good overview of: 1) activity durations 2) waiting times between durations As far as I understood, Celonis can show me the duration between activities (waiting time). What about the activity's duration itself?

We have table A (case table) and table B connected to A as 1:N relationship, 1 A has N BsWe want to show in an OLAP table A and B, and we want to aggregate SUM(B) for each A, so we can use SUM or PU_SUM. We are using SUM because we want the result of SUM(B) to be affected by filter selections. If there is A with missing values at B side we would expect to see A and NULL at the B column However we won't see anything unless we apply PU_SUM(B), and as said above, PU_SUM doesn't support filter selections so it cannot be used for this use case.Is there another way to see the A values together with NULL values at B column?

Hello! I've been having trouble with my queries in the Accounts Payable Case Study Training. Specificaclly, in the section 'Transform - Add an Activity: Set or Remove Payment Block'. I've been able to insert all the other activities without any problems, but I'm stuck at this one. Here are the instructions:   Here is the codes I've tried at first: ```INSERT INTO _CEL_AP_ACTIVITIES( _CASE_KEY, _ACTIVITY_EN, _EVENTTIME, _SORTING)SELECT  BSEG.MANDT||BSEG.BUKRS||BSEG.BELNR||BSEG.GJAHR||BSEG.BUZEI AS _CASE_KEY  , CASE    WHEN CDPOS.VALUE_NEW IS NULL THEN 'Remove payment block'    WHEN CDPOS.VALUE_OLD IS NULL THEN 'Set payment block'  END AS _ACTIVITY_EN  , CAST(CDHDR.UDATE || CDHDR.UTIME AS TIMESTAMP) AS _EVENTTIME  , CASE    WHEN CDPOS.VALUE_OLD IS NULL THEN 20    WHEN CDPOS.VALUE_NEW IS NULL THEN 30  END AS _SORTINGFROM BSEG AS BSEGJOIN BKPF AS BKPF ON 1=1  AND BSEG.MANDT=BKPF.MANDT  AND BSEG.BUKRS=BKPF.BUKRS  AND BSEG.BELNR=BKPF.BELNR  AND BSEG.GJA

so here if the count is just one then i just need to display 1 in the legend/axis. it should not show 200m, 300m.... etc. is there a way to achieve it?

I have calculated the date difference between last load ("Table1"."Column1") and today: DATEDIFF(dd, "Table1"."Column1", TODAY() ). I would like to apply a component filter to my OLAP table to see only the newest cases. I have tried with FILTER MIN(DATEDIFF(dd, "Table1"."Column1", TODAY() )); but no result. How should I reformulate my filter to get rid of the error I get?

Is there a way to view the table structure in data integration? something like "Describe Table_Name" which returns the columns, data types details of the table passed.

essentially i want to bucket cases based on where their latest event is.  what would be the best PQL clause to use in this instance?

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?

Assume the data pool contains of AP, AR and O2C three processes. I want to delete AP process data, for that I have added an activity in transformation where I have droped all the tables related to AP process data and I have executed that activity and data load has been done. But no change in studio part and APC Consumption also, data got not reduced. Is there any way to delete the data ?

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