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:
Tags: security