asked
SSAS Security Access Restriction
Hi, I have created a cube including user roles to restrict the access. Checking with Server Data Tools, everything works fine: the user do see limited data of a particular dimension. I added an user from Active Directoy to that role. After deploying the cube including the new created role and connecting with Excel to that cube with Single Sign On (SSO), I do see all data without any limitation. What is missing? Regards Matt
Not sure exactly what the issue is, but if you have verified that the role was successfully deployed and that the cube permissions have been set for that role in the deployed cube...could it be that instance-level permissions exist for the same user, or that the logged-in user belongs to multiple roles?
18 People are following this question.
