562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
How to use security roles to restrict access to your SSAS Tabular model
Part five of a five-part series of blogs
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.
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!
|Parts of this blog|
25 Aytoun Street