Showing posts with label sap-hana-modeling. Show all posts
Showing posts with label sap-hana-modeling. Show all posts

Wednesday, 4 January 2017

Constant Selection in SAP HANA Using Dynamic Join

In SAP BW, there is this concept of “Constant Selection” where you can mark a selection in the Query Designer as constant. This means that navigation and filtering will have no effect on the selection at runtime.

In SAP HANA, there is no feature that directly supports this functionality. We have to model it ourselves. One way to implement it is through “self joins” and “dynamic joins”.