Implementing data security in tabular models
Just to recap, we have covered the administrator roles for Analysis Services, which give full access to the model, and we have created a Read Only role for the tabular model. In tabular models, dimensional and cell-level security are not available. When we created the Read Only role, we set the database level permission as Read in the Role Manager.
In the following sections, we will create two additional roles – Tailspin Toys Group and Dynamic Sales. The first will use the Row Filters option to limit a user's access to the data based on the filter. The second role will be dynamic and will leverage some of the work we did to support the multidimensional dynamic dimension security.
Creating a role to limit access to a customer
Now, we are going to limit what users can see by creating a new role that will limit the data to Tailspin Toys. To do this, we will use row filters. Let's get started:
- Open
WideWorldImportersTAB...
