Databases Reference
In-Depth Information
Figure 19-15
9. You can define security permissions on roles so that the totals re-
turned by Analysis Services are calculated for the visible members
rather than all the members in the dimension. Open the role David
and switch to the Dimension Data tab. Select the cube dimension
Location and the hierarchy Area. Switch to the Advanced security
definition tab and enable the check box Enable Visual Total as shown
in
Figure 19-16
. Similarly enable the check box for the hierarchies
City, Location, and State, and deploy the project to your Analysis
Services instance so that new security definitions are updated on the
server.
Figure 19-16
If you return to the cube browser and refresh the connection you will
see that user David can see the sales information for the city New
York and all the totals now match the sales of the city New York as
shown in
Figure 19-17
. By enabling visual totals while defining di-
Search WWH ::
Custom Search