Creating Calculated Members - 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
A calculated member is a member whose value that calculates at query execution run time. You can specify an MDX formula for the calculation. The formula and definition is saved in the cube schema definition. No calculated data is stored.
Calculated members are not supported by Excel 2003 or earlier versions.
  1. From the Schema Tree View, right-click the cube, and select New Calculated Member.


    The Schema Element Properties View appears in the right pane.



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

    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. Select the parent hierarchy for the new calculated member from the Hierarchy menu.
  5. [Optional] To prevent measure visibility to BI client applications, uncheck the Visible check box.
  6. Type the MDX query language formula for the new calculated member in the MDX Expression box, and click Validate Expression to validate the MDX expression. See MDX Expressions in Calculations. For a list of supported MDX functions, methods and operators, see Supported MDX Functions and Operators.

    If an MDX validation error occurs, see MDX Validation Errors.

  7. Type a number in the Solve Order box. Solve order is an integer priority for your calculated member relative to other MDX calculations. Unless a non-default solve order is required, leave the value at zero.

    Find useful information by searching for solve order in the Microsoft Developer Network Library at http://msdn.microsoft.com/library/.