Calculated Member Builder Dialog Box (Analysis Services - Multidimensional Data)
Use the Calculated Member Builder dialog box in SQL Server Data Tools (SSDT) to build a calculated member.
Options
Term |
Definition |
|---|---|
Name |
Type the name of the calculated member. |
Parent Hierarchy |
Select the hierarchy in which to create the calculated member. |
Parent Member |
This option is enabled if you select a parent hierarchy (other than the Measures dimension) that has more than one level. Click the ellipsis (…) button to select a parent member. The parent member determines the location of the calculated member in the dimension structure. |
Expression |
Type the MDX expression that will be used. |
Check |
Click Check to test the MDX expression defined in Expression. |
Metadata |
Displays metadata for the current Analysis Services object that can be included in the MDX expression defined in Expression. You can copy the MDX syntax for the selected item by right-clicking the item and selecting Copy, or by dragging the selected item to Expression. |
Functions |
Displays the available MDX functions for the current Analysis Services instance. The items listed are retrieved from the MDSCHEMA_FUNCTIONS schema rowset. You can copy the MDX syntax for the selected item by right-clicking the item and selecting Copy, or by dragging the selected item to Expression. |