Analysis Services Security - SQL Server Analysis Services 2012 Cube Development - page 256

8. Add a cube named AdventureWorks to the Security project based on
the FactResellerSales , Date , Promotion , SalesTerritory ,
Reseller , and User dimensions. Please refer to Chapter 3 , Creating Ana-
lysis Services Cubes , for cube recipes. You do not have to set up a relation-
ship between the User dimension and the ResellerSales measure group.
9. Add a second measure group to the AdventureWorks cube based on
FactUserTerritory . Expose UserTerritoryCount (row count) as the
only measure from the FactUserTerritory measure group. Ensure that
User and SalesTerritory have regular relationships with FactUser-
Territory .
10. Create a role named Dynamic within the Security project. Grant member-
ship in this role to the domain user that you included in the dimUser table.
11. Grant the Dynamic role Read access to the AdventureWorks cube.
12. Navigate to the Dimension Data page, choose the SalesTerritory di-
mension, go to the Advanced tab, and choose the Sales Territory Re-
gion attribute.
13. Enter the following MDX expression in the Allowed member set box:
NONEMPTY([Sales Territory].[Sales
Territory Region].members,
StrToMember("[user].[user].[" +
UserName() + "]"),
measures.UserTerritoryCount))
14. Check the Enable Visual Totals box. The Dimension Data page should look
as shown in the following screenshot: