Skip to Content
Former Member
Dec 30, 2015 at 08:26 PM

Restricting Views(?) When Using HANA HTTP Connection and Analysis for Office 2.2



We are implementing reporting directly against HANA Analytic Views (AVs) using Analysis for Office (Excel). I would like to build an organizational structure and security model where the user only sees the AVs relevant to their areas.

The links below explain / talk about this process using an OLAP connection, and I have been successful getting this working with a BIP OLAP connection to HANA (SP9) and AO 1.4. I have not been able to replicate this functionality using AO 2.2 and the HTTP connection to HANA, the only HANA connection available for AO 2.2.

Using HTTP / AO 2.2 ,when attempting to use the same roles which properly restrict the AVs using OLAP / AO1.4, the user is able to see all the AVs in the HANA system. When the user tries to open a view which they do not have access to based on the role the AV will not return any data. Ideally we would like the users to not even see these AVs.

Has anyone tried to restrict the visibility of AVs using HTTP / AO2.2? Is this even possible?

Thanks in advance for any feedback.