Measure Element
X-Ref:
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 | |
| AggregateColumnName | AstTableColumnBaseNode | 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. | |
| AggregateFunction | SsasAggregationFunction | Sum | 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. |
| BackColorExpression | String | 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. | |
| Collation | String | This value specifies which collation method is used by the measure. | |
| DataFormat | SsasDataFormat | Unknown | 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. |
| DataMimeType | SsasDataMimeType | None | This value, where applicable, specifies the Multipurpose Internet Mail Extensions (MIME) type of the data represented by the DataItem element. |
| 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. | |
| FontFlagsExpression | String | 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. | |
| FontSizeExpression | String | 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. | |
| ForeColorExpression | String | 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. | |
| InvalidXmlCharacterProcessing | SsasInvalidXmlCharacterProcessing | Preserve | This value determines how invalid XML characters in the source data are handled. |
| MeasureFormat | SsasMeasureFormat | Standard | 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. |
| NullProcessing | SsasNullProcessing | Automatic | This value specifies how null values are processed. The default value is Automatic. |
| SsasDataType | SsasDataType | Inherited | 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. |
| Trimming | SsasTrimming | Right | This value specifies how data from the data source is trimmed. The default setting is Right. |
| Visible | Boolean | true | This value specifies whether the parent element measure is visible. The default value is True. |
Singleton Children
| Child | API Type | Description |
|---|---|---|
| <Expression /> | 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. |
| <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. |