Withdrawing Drill Down Access to a Level - Teradata Schema Workbench

Teradata Schema Workbench User Guide

Product
Teradata Schema Workbench
Release Number
16.20
16.10
15.10
Published
June 2015
Language
English (United States)
Last Update
2018-05-25
dita:mapPath
gvf1512702977003.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-4106
Product Category
Teradata Tools and Utilities
  1. From the Schema Tree View, select the role under the Security folder. The Schema Element Properties View displays in the right pane.
  2. In the Permissions pane, expand the cube and dimension until the hierarchy is in view.
  3. Select the hierarchy (not the check box). The Allowed Range of Levels panel appears.


  4. 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.
  5. 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.