Data-level restriction in BO Analysis Edition for OLAP

[Former Member]

Hi. Our current reporting setup is using Microsoft Analysis Services for OLAP and another tool for the front end. We are currently using MSAS Roles to restrict the data the users can see (restrict users by country). We are migrating our front end tool to Business Objects Analysis Edition for OLAP. Is it possible to use the same data-level restriction in BO Analysis Edition for OLAP?

[I_MCA]

Hello Ednalynn

Yes... the security which you define in SSAS is honoured by AOLAP. When you define the connection to SSAS in the CMC, just make sure you either use "SSO" or "Prompted" for the login option. This will ensure that SSAS returns the correct data to AOLAP, based on the user.

Regards

Ian

[Former Member]

Hi Ian,

Thank you for the reply. Unfortunately, they would not allow us to use SSO and Prompted log in types due to some security compliance within the company. Can you recommend another strategy on how to overcome this?

Regards,

Ednalynn