Report Portal

SSAS advanced dimension level security using SSRS reports, showing parent of a level you have no access

I was working with a client where i had some difficult security questions. Take the following example from the AdventureWorks cube:

I want to give users a report that show all sales by state province of the country they are in, e.g. you are a sales person belonging to postal code 91801 and you want a report showing all the state-province’s of the United States since that is the country you belong to.
As seen in the dimension below:

Read more...

Tags: security

 

2007-2015 VidasSoft Systems Inc.