Database Reference
In-Depth Information
15. Save and deploy the project to your SSAS instance and process the data-
base.
16. To test the role, open the cube browser and click on the
Change User
button
to impersonate the domain user that you added to the
Dynamic
role. The
user will only see the data for
sales territory region = "Germany"
and the corresponding visual total.
17. After you have confirmed that the dynamic security role works as expected,
set the
User
dimension's and the
UserTerritoryCount
measure's visible
property to
False
. These do not add any value to cube consumers; they are
simply used for implementing security.
Search WWH ::
Custom Search