O'Reilly logo

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook by Derek Wilson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configuring dynamic filter security

Dynamic security uses additional information to filter the data to allow more flexibility than row-level security. In this recipe, you will create a security table that has two users, Bob and John. Then, by implementing dynamic security, the data that each is able to see will be shown.

Getting ready

Open the Crash_Data_Model in Visual Studio to bring up Model.bim. Then change your view to the Diagram view to see the table relationships. In this recipe, you will create a new security table and then implement dynamic security for these users by using the USERNAME() function. The USERNAME() function will return the DOMAIN\User from the account accessing the model.

How to do it...

  1. Select the Model menu and the Existing ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required