Advanced DSO Features.

SAP HANA – Advanced DSO Features

This blog post describes the features of ADSO’s and how to use them. View details on http://scn.sap.com/community/bw-hana/blog/2015/07/10/sap-hana–advanced-dso-features SUMMARY Our experience with Advanced DSO’s is good; we did not encounter severe problems. Everything worked after we gain the knowledge how to use it. thx 2 mario

SAP HANA Security.

SAP HANA Security – Create Roles and Privileges from BW System in SAP HANA

This blog post explains how to create roles with privileges for SAP HANA Studio from BW for DBMS profiles in order to give the users the possibilities to see views on generated SAP HANA BW content (like calculated views generated out of new composite provider and SAP BW queries 7.4). View details on http://scn.sap.com/community/bw-hana/blog/2015/06/19/sap-hana-security-create-roles-and-privileges-from-bw-system-in-sap-hana thx …

Selection in variable screen.

Key figure selection in variable screen

If there is a requirement to restrict the key figures in the variable screen of a BEx Query, you have to work with some sort of workarounds ( formula variables, zero suppression and so on). With BW 7.4 SP8 another option is now available. It is called Visibility of Structure Members. Once activated a new …

Hierarchical Display of Calculated.

Hierarchical Display of Calculated and Restricted Key Figures in BEx Query Designer

Calculated (CKF) and restricted (RKF) key figures are often used in BW mainly for re-usability and maintenance reasons. However, the handling in the Query Designer is not optimal in case of huge  number of CKF or RKF. Finding a certain CKF/RKF can be tedious and very time consuming. Using the sorting might help, but typically …