Search code examples
ssasolapanalysisolap-cubessas-2008

data access management in OLAP cube for organization with multiple compaines

I am building a OLAP Cube in SSAS for an organization which has many different companies under its umbrella.

i have built a principal cube which consists of all the measure groups and dimensions, which has the data of all the companies in this organization.

Now this cube is ok for the top level management, but i need to limit the access of users from each of the companies, only to the data of its own company.

Is there a way to do that in the principal cube, without duplicating it to many sub cubes, each consists of only the relevant company?

Thank you in advance, Tal

Solution

  • You can use role based security in combination cell-based security. below link can be useful:

    https://learn.microsoft.com/en-us/sql/analysis-services/multidimensional-models/grant-custom-access-to-cell-data-analysis-services