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

None : No permissions assigned
Read : Read data
Read and Process : Read data and reload data
Process : Reload data, but no ability to read
Administrator : Full access
3. We also made no changes in the Row Filters tab when we created the Read
Only user. As a result, the permissions that were assigned apply to the entire
model. By assigning a group to our Read Only role, that group would be
able to use our entire model in their analysis.
4. Let's add a filtered role that only allows the role to see data related to a
specific sales territory, that is, Central. This territory is defined in the Sales
Territory table. Once again, you open the Role Manager dialog. Add a
new role named Central Sales . Assign the Read permission to the new
role, and add your filtered user to the Members area.
5. Now, you double-click on the DAX Filter cell by Sales Territory. You get no
help at all. So, you will need to create the filter by hand. Add the following
filter to the dialog:
=[SalesTerritoryRegion]="Central"
You need a DAX formula that will return a Boolean value . In this case, the
formula tests the name of the region and sets the result to TRUE or FALSE .
Note
In order to create this formula, I created it as a calculated member in the
model. This allowed me to verify the results and the syntax. Once I was
done, I removed the column.