Implementing security in Tabular Models
One of the key differentiators or reasons to move Power Pivot models into SQL Server Analysis Services is security. Tabular Models support a much more robust security model than what is available in Power Pivot in Excel or SharePoint.
Getting ready
In order to work with security, you will need some users that you can assign to the roles. In my solution, I have added SteveReader and SteveFiltered to my local computer. Normally, you would be using Active Directory users and groups to manage your security. If you have a test or development environment with users at your disposal, use them. In either case, you will need users to complete this next recipe.
How to do it…
You can open the Role Manager dialog by clicking ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
