Using Tabular Models - SQL Server Analysis Services 2012 Cube Development - page 359

Now you have a role that will only show data that is available based on that
filter in related tables. In this case, your Sales table will be filtered. If you
want to have this filter apply to other lists, you could create a lookup table that
associates data such as customers directly with the sales territories, which
would result in a filtered customer list as well.
How it works…
Role-based security in the Tabular Model is very similar to role-based security in mul-
tidimensional models. Permissions within the model are additive, which means user
permissions are accumulative across all the roles they belong to. For instance, this
means that administrators cannot be limited in their ability to see the data even if that
user has read-only permissions on a table.
There's more…
You want to verify that your roles and users have the expected permissions. You can
do this using the Analyze with Excel feature. When you open the Analyze with Ex-
cel dialog, you can see that you have the option to select users, roles, and even per-
spectives. If you use the Central Sales role you created and click on OK , you will
see the effect of the role using Excel. This helps administrators test security during
development and helps verify the results, which are what you need to support the
role you created.