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

Documentation

Support Forums
What can we help you with?
Topics

Measure Element

API Type:
Varigence.Languages.Biml.Fact.AstMeasureNode
X-Ref:
  • Ast Measure 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
AggregateColumnNameAstTableColumnBaseNode 
In cases where a custom MDX expression is not supplied for the measure, an aggregate column is selected to supply the measure value from the underlying data source. Whichever aggregate column is selected will undergo the operation specified by the Aggregate Function property when the measure value is computed for a given query. This references an existing definiton.
AggregateFunctionSsasAggregationFunctionSum
In cases where a custom MDX expression is not supplied for the measure, an Aggregate Function is the operation that will be applied to the column specified by the Aggregate Column property when the measure value is computed for a given query.
BackColorExpressionString 
This value specifies the color-related display properties of the measure. Arbitrary MDX expressions can be used, and this information is sent to the OLAP client (such as Microsoft Excel) for rendering. It is up to the OLAP client to respect these settings.
CollationString 
This value specifies which collation method is used by the measure.
DataFormatSsasDataFormatUnknown
This value specifies the formatting requirements of the DataItem element. For the current versions of SQL Server Analysis Services (SSAS), only whitespace trimming is offered as an option. Future versions reserve the right to offer additional DataFormat options. The default setting is None.
DataMimeTypeSsasDataMimeTypeNone
This value, where applicable, specifies the Multipurpose Internet Mail Extensions (MIME) type of the data represented by the DataItem element.
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.
FontFlagsExpressionString 
This value specifies the font-related display characteristics of the measure, such as font weight and style. Arbitrary MDX expressions can be used, and this information is sent to the OLAP client (such as Microsoft Excel) for rendering. It is up to the OLAP client to respect these settings.
FontSizeExpressionString 
This value specifies the font name to be used for the measure. Arbitrary MDX expressions can be used, and this information is sent to the OLAP client (such as Microsoft Excel) for rendering. It is up to the OLAP client to respect these settings.
ForeColorExpressionString 
This value specifies the color-related display properties of the measure. Arbitrary MDX expressions can be used, and this information is sent to the OLAP client (such as Microsoft Excel) for rendering. It is up to the OLAP client to respect these settings.
InvalidXmlCharacterProcessingSsasInvalidXmlCharacterProcessingPreserve
This value determines how invalid XML characters in the source data are handled.
MeasureFormatSsasMeasureFormatStandard
This value specifies the format string to be used for displaying data in the OLAP client, such as Microsoft Excel. While any Microsoft format string can be provided, several common format strings are offered for convenience.
NullProcessingSsasNullProcessingAutomatic
This value specifies how null values are processed. The default value is Automatic.
SsasDataTypeSsasDataTypeInherited
This value specifies the type of the measure using the SQL Server Analysis Services (SSAS) type system. Note that this type may differ from the type of the aggregate column in the underlying data source or the value computed by the specified expression. In those cases, a type cast will automatically be performed on the basis of this property setting when the types are compatible.
TrimmingSsasTrimmingRight
This value specifies how data from the data source is trimmed. The default setting is Right.
VisibleBooleantrue
This value specifies whether the parent element measure is visible. The default value is True.

Singleton Children

ChildAPI TypeDescription
<Expression />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.
<Translations>
    <Translation />
</Translations>
AstTranslationNode
This value contains alternate language versions of measure groups, measures, cube dimension, perspectives, KPIs, actions, named sets, and calculated members associated with a dimension. These are used by client applications such as Microsoft Excel to show values for dimension metadata that are consistent with the language of the end-user.

© Varigence