Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide

Time for action – security in tabular

In this example, we will create a role in the tabular model and authorize it to access only the data of the year 2008. We will also show you how to use perspectives to provide a better view for users by performing the following steps:

1. In the Model menu, click on Roles. Create a new role and name it as SampleRole. Set its permission as Read.
2. Write the following DAX filter in front of the Date row:

   ='Date'[CalendarYear]=2008

   
3. Save changes and analyze the model in Excel. In the Analyze option in the Excel window, choose SampleRole under Roles.
4. Select the Calendar hierarchy under Date and the Sum of Sales Amount measure; ...