CODEWITHSUNDEEP
sql-servervisual-studiossasolaprow-level-security
Jaime
Jaime

Reputation: 21

SSAS OLAP Cube: Row level security with Cube Roles

I got a multidimensional OLAP-Cube that attracts my MS SQL Server Database. By now, there was no need for row level security. Now, we would like to grant access to different sales representatives with Excel-Sheets that have a Live-conneciton to Analysis Services - so every salesman could evaluate the revenues in his sales territory.

This is my data example:

Product table

Customer table

I build a role to restrict the access for the first salesman by customizing the access to dimension data:

new role in my cube

Then I tested my new role and got the following result:

result of product table after restriction

result of customer table after restriction

The restricted role still can see the whole data of the product table and the total amount of the customer table, although the totals are disabled:

disabled totals in Cube

Does anyone one my mistake I did when setting up the new role?

The result, I would like to see after restriction should be this way:

desired result

I hope that someone can help me despite the small amount of information. Thank you so much!

Upvotes: 1

Views: 772

Answers (1)

Brenton
Brenton

Reputation: 444

I believe you can achieve this if you tick "Enable Visual Totals" at the bottom of the popup: enter image description here

Upvotes: 2

Related Questions