Securing Your Cube Project - Getting Started with SQL Server 2012 Cube Development - page 221

3. Perform the same with the North America Reader role.
4. Deploy the project and switch to the Adventure Works DW2012.cube file.
5. Click on the Browser tab, click on the Change User button, and then select
the Europe Reader role.
6. Test the Visual Totals with the following statement:
select [Measures].[Order Quantity] on
columns,
[Product].[Product Hierarchy].members on
rows
from [Adventure Works DW2012]
7. Now the total of the Order Quantity column is limited by the European
sales even though Sales Territory is not referenced in the query.