• PRODUCTS
  • SUPPORT
  • DOCS
  • PARTNERS
  • COMPANY
  • QUOTE
  • ACCOUNT
  • STORE
QUOTE

Documentation

Support Forums
What can we help you with?
Topics

Calculated Member Element

API Type:
Varigence.Languages.Biml.Cube.Calculation.AstCalculatedMemberNode
X-Ref:
  • Ast Calculated Member Node
  • Ast Mdx Script Item Node

Attributes

AttributeAPI TypeDefaultDescription
NameString 
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
ParentDimensionNameAstCubeDimensionNode 
This value specifies the parent cube dimension that should be associated with this calculated member. This is a required reference to an existing definiton.
AssociatedMeasureGroupNameAstCubeMeasureGroupNode 
This value specifies the measure group in which this calculated member should be displayed. This references an existing definiton.
DisplayFolderString 
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.
FormatStringSsasMeasureFormatStandard
This value specifies the format that should be used to display the result of the calculated member in the client application.
NonemptyBehaviorOverrideString 
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.
ParentAttributeNameAstAttributeNode 
This value specifies the parent dimension attribute that should be associated with this calculated member. This references an existing definiton.
ParentHierarchyNameAstDimensionHierarchyNode 
This value specifies the parent dimension hierarchy that should be associated with this calculated member. This references an existing definiton.
ParentMemberString 
This value specifies the name of the parent member that should be associated with this calculated member.
VisibleBooleantrue
This value indicates whether the parent element is visible. The default setting is True.

Singleton Children

ChildAPI TypeDescription
<MdxScript />StringString 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 />StringString is the .NET Framework String class. More information can be found at http://msdn.microsoft.com/en-us/library/system.string.aspx.
<FontFlags />StringString is the .NET Framework String class. More information can be found at http://msdn.microsoft.com/en-us/library/system.string.aspx.
<FontName />StringString is the .NET Framework String class. More information can be found at http://msdn.microsoft.com/en-us/library/system.string.aspx.
<FontSize />StringString is the .NET Framework String class. More information can be found at http://msdn.microsoft.com/en-us/library/system.string.aspx.
<ForeColor />StringString is the .NET Framework String class. More information can be found at http://msdn.microsoft.com/en-us/library/system.string.aspx.

Collection Children

ChildAPI TypeDescription
<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.

© Varigence