I am having an issue that involves SSAS and Sharepoint. I don't think I can fix the issue in Sharepoint, I think it has to be in my ssas cube. THe issue is that in sharepoint I have a ssas filter webpart that displays the geography hierarchy
based on the role that is defined in SSAS. So if I have a user that only has permissions to Switzerland than they will see the geography hierarchy as (Region, Sub Region, Area, Country)
All Sales Region
What I want to know is in SSAS can I restrict the hierarchy to only show country if the user belongs to a certain role. So what I want to basically say is if the user belongs to SSAS_CH then the hierarchy should just show Switzerland, not All Sales
Region > Europe, etc....
Can this be done?
View Complete Post