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
-
Right-click the fact table in Tree View and select New Measure.
-
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.
-
Select the column this measure identifies from the Measure Column list.
-
Select the aggregation policy for this measure from the Aggregator list (default is Sum).
-
If the cube administrator designates the measure for a specific format, select the option from the Format String list.