Creating a Hierarchy for a Dimension - 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
All hierarchies that belong to the same dimension share the same set of foreign keys.

The Teradata BI Repository solution only handles level-based dimension hierarchies. This means all hierarchies are balanced, with leaf members only at the bottom level. Parent-Child (value-based) hierarchies are not supported unless transformed into a level-based star schema in the underlying database. See Modeling Parent-Child Hierarchies.

Most hierarchies in OLAP have a top level with one member and it is typically named All. This top level might be explicitly visible in some BI client applications, such as Excel 2003, or it might only show as grand total rows and columns in Excel 2007 or Excel 2010.

  1. From the Schema Tree View, right-click a Dimension, and select New Hierarchy.


    The Hierarchy Wizard appears.

  2. In the Name box, type a name for the new hierarchy.
  3. Click the Caption box. The caption automatically fills with the same name as the hierarchy.

    The caption is a name that is displayed and can be localized to different languages in the BI client application. See Cube Schema Localization.

  4. [Optional] Select the Use All Member check box to have Teradata Schema Workbench automatically create a default All level.


  5. Click OK. The Hierarchy is added under its Dimension in tree view, and the Hierarchy page appears in the Schema Elements Properties view.
  6. [Optional] Click Set Default Member to ALL to set the MDX default member to the All member. When including an ALL level, the default member automatically sets to the ALL member.
  7. To override the ALL member, or if the All Level Name is blank, use MDX syntax in the Default Member box to specify the unique member name of the default member. If there is no ALL level and you do not enter MDX syntax to specify a default member, the default member becomes the first member, based on the sort column of the highest level, furthest from the fact table.