BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Perspectives in Analysis Services let you show different parts of your tabular model to different people, but they don't have any security. To ensure that the right eyes see the right bits of your model, you'll need to create and manage security roles, as explained in this blog.
- Security in SSAS Tabular - creating and managing roles
- Creating a permissions table
- Using CustomData to make row filters dynamic
- Controlling what a user sees using their logon name
- Assigning members to roles (this blog)
Posted by Andy Brown on 26 February 2016
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Assigning members to roles
In practice you'd probably want a security role to be shared by a number of different users of your model:
You've created a role called RegionRole to show only London data, but now want to assign this to specific people.
To choose people for a role, start by clicking on the Members tab in the dialog box above:
Click on the Members tab, and then choose to add a member.
In the dialog box which appears, choose Locations:
Choose which location to use.
Expand the Entire Directory to choose which domain to use:
Click on the + shown to expand the category to see the groups available.
Choose a group:
Choose a group which should be assigned to this role.
As an alternative to the above, you could search for a person or group:
Here I'm searching for a user containing Andy.B within the Entire Directory. Clicking on Check Names as shown will tell me whether the user exists (and if the user does exist, will fill in their full name).
Notes on how to add an Active Directory user group are shown in this StackOverflow article.
And with that, you've reached the end of this blog on security roles within SSAS Tabular!