Defining Fact Table Measures - 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. Right-click the fact table in Tree View and select New Measure.
  2. Type the measurein the Name field. By default, the text you enter in Name automatically fills the Caption field with the same text. You can modify the caption text.
  3. Select the column this measure identifies from the Measure Column list.
  4. Select the aggregation policy for this measure from the Aggregator list (default is Sum).
  5. If the cube administrator designates the measure for a specific format, select the option from the Format String list.