Securing Your Data in Analysis Services - Professional SQL Server Analysis Services 2005 with MDX - page 982

Change User icon as shown in Figure 19-13 . You will now have a
dialog where you can select the role you have created. Select the
role David as shown in Figure 19-14 and click OK.
Figure 19-13
Figure 19-14
8. Drag and drop the sales measure and the Geography hierarchy of
the Location dimension into the cube browser as shown in Figure
19-15 . As you can see, the user David can only see results for the
member New York; his access to the sales information is restricted to
that and the totals. However the Totals for the State, Area, and
Country do not match the value for city New York. This is due to the
fact that sales for other cities are included in the totals.