- From the Schema Tree View, select the role under the Security folder. The Schema Element Properties View displays in the right pane.
- In the Permissions pane, expand the cube and dimension until the hierarchy is in view.
-
Select the hierarchy (not the check box).
The Allowed Range of Levels panel appears.
-
Under the Top Level column, select the radio button for the topmost level the role should be allowed to access.
Lowering the top level automatically removes the check mark from Allow All Levels, which removes the availability of BI client tools to see grand totals.
-
Under the Bottom Level column, select the radio button for the lowest level the role should be allowed to access.
The bottom level can be set at the same as the top level, but the bottom level cannot be set higher than the top level.