BW on HANA Pushdown Formula Exception Aggregation

Gunter_Cokl — Thu, 17 Aug 2023 12:23:22 GMT

Hi,

I do not understand why a formula in my query is not executed in HANA DB. We are on BW750/25 on HANA. I use this formula:

IF("[ZPLPRODTM] Planned Production Time" > "[0ACTEXECTMX] Production time (1000; Sensor T+Z; PP01)"; "[0ACTEXECTMX] Production time (1000; Sensor T+Z; PP01)"; 0)

with exception Aggregation SUM using on reference characteristic:

When I run the query via RSRT (Query property: Operations in SAP HANA/BWA = 7 (Formulas calculated in SAP HANA ) ) the formula is executed in ABAP, not HANA.

Any ideas why there is no PushDown? Query is based on a Composite Provider using aDSOs.

Gunter

Re: BW on HANA Pushdown Formula Exception Aggregation

Gunter_Cokl — Thu, 17 Aug 2023 14:00:56 GMT

Hi,

after a few more hours of research I have a solution. First of all "IF" is not supported, so we had to go back to the old version with "< * =". Second reason was that key figures have units. When we use KeyFigures without units, the formula works fine and is pushed down to HANA DB.

Would be nice if KeyFigures with Units would work too!

Gunter

Question Re: BW on HANA Pushdown Formula Exception Aggregation in Technology Q&A

BW on HANA Pushdown Formula Exception Aggregation

Re: BW on HANA Pushdown Formula Exception Aggregation