In-memory, the Future - Getting Started with SQL Server 2012 Cube Development - page 307

Adding security to your in-memory

model

Security is always an important functionality of any BI system. Tabular models have
the ability to adding granular security through the usage of roles. The concept of roles
in the tabular world is the same as it is in the multi-dimensional that we went through
in Chapter 7 , Securing Your Cube Project . To create a new role, perform the following
steps:

1. Click on the Roles button in the designer.
2. Click on the New button to create a new role.
3. Name the role as North America Reader .
4. Change the value of the Permissions column to Read .
5. In the Row Filter section, find the DimSalesTerritory table and add the fol-
lowing DAX filter:

=[SalesTerritoryGroup]="North America"

6. Click on the New button again to create a new role.
7. Name the new role as All but North America .
8. Change the value of the Permissions column to Read .
9. Specify the following filter for the role:

=[SalesTerritoryGroup] <> "North America"