Calculated Member Element
X-Ref:
- Ast Calculated Member Node
- Ast Mdx Script Item Node
Attributes
Attribute | API Type | Default | Description |
---|---|---|---|
Name | String | Specifies the name of the object. This name can be used to reference this object from anywhere else in the program. This is a required property | |
ParentDimensionName | AstCubeDimensionNode | This value specifies the parent cube dimension that should be associated with this calculated member. This is a required reference to an existing definiton. | |
AssociatedMeasureGroupName | AstCubeMeasureGroupNode | This value specifies the measure group in which this calculated member should be displayed. This references an existing definiton. | |
DisplayFolder | String | This value specifies the folder in which the parent element is listed. The default setting is None. The display folder is used by the OLAP client, such as Microsoft Excel, to visualize the measure in context of the larger measure/dimension hierarchy. Display folders enable better organization of measures to ease the navigation of large cubes for end-user analysts. | |
FormatString | SsasMeasureFormat | Standard | This value specifies the format that should be used to display the result of the calculated member in the client application. |
NonemptyBehaviorOverride | String | This property allows a user to specify an arbitrary MDX expression to be used as the NonemptyBehavior property of the calculation. It overrides any values in the NonemptyBehaviors collection. | |
ParentAttributeName | AstAttributeNode | This value specifies the parent dimension attribute that should be associated with this calculated member. This references an existing definiton. | |
ParentHierarchyName | AstDimensionHierarchyNode | This value specifies the parent dimension hierarchy that should be associated with this calculated member. This references an existing definiton. | |
ParentMember | String | This value specifies the name of the parent member that should be associated with this calculated member. | |
Visible | Boolean | true | This value indicates whether the parent element is visible. The default setting is True. |
Singleton Children
Child | API Type | Description |
---|---|---|
<MdxScript /> | String | String is the .NET Framework String class. More information can be found at http://msdn.microsoft.com/en-us/library/system.string.aspx. This is a required property |
<BackColor /> | String | String is the .NET Framework String class. More information can be found at http://msdn.microsoft.com/en-us/library/system.string.aspx. |
<FontFlags /> | String | String is the .NET Framework String class. More information can be found at http://msdn.microsoft.com/en-us/library/system.string.aspx. |
<FontName /> | String | String is the .NET Framework String class. More information can be found at http://msdn.microsoft.com/en-us/library/system.string.aspx. |
<FontSize /> | String | String is the .NET Framework String class. More information can be found at http://msdn.microsoft.com/en-us/library/system.string.aspx. |
<ForeColor /> | String | String is the .NET Framework String class. More information can be found at http://msdn.microsoft.com/en-us/library/system.string.aspx. |
Collection Children
Child | API Type | Description |
---|---|---|
<Annotations> <Annotation /> </Annotations> | AstAnnotationNode | This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code. |
<NonemptyBehaviors> <NonemptyBehavior /> </NonemptyBehaviors> | AstMeasureReferenceNode | This value specifies a collection of references to measures in the cube will use to determine if this calculation produces an empty value. If this list is empty, Analysis Services must evaluate the MDX to determine this, which can be far more expensive. |