BW on HANA Pushdown Formula Exception Aggregation

[Gunter_Cokl]

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.

BR

Gunter

[Gunter_Cokl]

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!

BR

Gunter