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...
- Select the Model menu and the Existing ...
Get Tabular Modeling with SQL Server 2016 Analysis Services 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.
