Creating a Schema Scope Named Set - 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
Schema-scoped named sets are used with members that belong to a dimension.
  1. From Schema Tree View, right-click the Named Sets folder, and select New Named Set.


    The Schema Element Properties View appears in the right pane.

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

    The caption displays and can be localized to different languages in the BI client application. See Cube Schema Localization.

  4. Type the MDX expression in the MDX Expression box and click Validate Expression to validate the MDX expression. See MDX Expressions in Calculations, Supported MDX Functions and Operators and MDX Validation Errors.

    This figure shows the MDX Topcount function. It is also valid to enter a comma-separated list within braces of fully qualified members for the set.



  5. From the Hierarchy list, select a hierarchy in which this named set displays in BI client applications.
  6. In the Display Folder box, type a display folder in which this folder displays in BI clients applications. The following figure shows a newly-created display folder in Excel called Sets.