Here is my scenario
Hi have a dimension Product related to a fact Sale (SSAS 2008 R2)
I am using excel 2010 and I want to filter by Product, but I want to hide some members of the filter. Let's Say that I want to consider only Product 1 and Product 2 for the filter. The user only can only see this products. I can't use Roles to do this, since
in another excel I want that the some user can only see Product 3 and 4.
In fact, what I wanted is to have tha ability to control the grant to members by perspective: in this perspective, the members of this dimension to consider is Product 1 and Product 2.
How can I do this?
Thanks in advance
View Complete Post