Adding a Dimension 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
You can add a dimension level to a hierarchy.
  1. From the Schema Tree View, vertically expand the Dimensions folder and right-click the hierarchy to add a new level to.


    The Schema Element Properties View appears in the right pane.

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

    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. Type or select a level type from the Level Type menu.
    Currently, not all Microsoft level types are used by Microsoft BI tools.

    Set the level type to a data type the level represents. Properly set the type for time levels.

    MDX functions, other tools, and third party applications use dimension type and level type values. For example, PeriodsToDate, Account Intelligence, and Currency Conversion Wizard.

    For a list of Microsoft 2008 BI tool level types, search the Microsoft Developer Network Library (http://msdn.microsoft.com/library/) for LevelTypeEnum Enumeration.

    See Level Member Columns.

  5. Select the level table from the Table menu. This table is from the level database Teradata Schema Workbench uses as the source data for hierarchy members at this level.
  6. Select a caption column from the Caption Column menu. This caption column exists in the level table and represents caption data for this level.
  7. Select a sort column from the Sort Column menu.
    Choose a Sort Column that represents an attribute of members of that level. For example, when selecting a custom sort order for a store location level called region, choose a column representing a region attribute.

    The following figure shows the properties for a newly-added Dimension level.