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…

Continue Reading

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…

Continue Reading

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…

Continue Reading