Role Security at different levels of hierarchy
I have two roles that specify dimension security at two different levels of the same hierarchy. Visual Totals are specified on both roles. Each role works fine individually, but when a user is assigned to both roles, the visual totals don't work as expected. You see the grand total at the parent level.
Upvotes: 0<=-=Oct 13 2008 11:18AM=-=>
Thanks for reporting the problme.
The issue looks to be �by design� (though could look like not immideately intuitive ):
If at least one role has visual totals disabled, then the user will see real totals even if other role enable visual totals (this is also for compatibility with Shiloh).
In this particular case, the per-attribute visual totals settings are:Role1 Role2
State Yes No
City No Yes
So no visual totals get applied on any attribute.
We believe the solution is to enable visual totals for both State and City in both roles.
Hope this helps.
The Analysis Services Team