Cube Measure Group Element
X-Ref:
- Ast Cube Measure Group Node
- Ast Securable Node
- Ast Scope Boundary 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 | |
| AggregationPrefix | String | This value provides a common prefix for aggregation names used throughout the associated measure group. | |
| DataAggregation | DataAggregation | DataAndCacheAggregatable | This value specifies whether persisted data, cached data, or both will be aggregated for the measure group. |
| EstimatedCount | Int64 | 0 | This value indicates the estimated number of items in the measure group. The default setting is zero. This value is used to assist in aggregation design choices and other internal operations. While EstimatedCount can be set manually to reflect estimated member counts, BimlStudio also provides an automatic Member Count Estimator in the Cube ribbon. |
| FactName | AstMeasureGroupMetadataNode | This value specifies a direct reference to the fact table that contains the rows that will comprise this measure group. This references an existing definiton. | |
| IgnoreUnrelatedDimensions | Boolean | true | This value specifies when indexing and aggregating occur. The options are Regular, which means that indexing and aggregating occur during processing, or Lazy, which means that indexing and aggregation occur after processing is completed. |
| Type | MeasureGroupType | Regular | This value specifies the measure group’s type. |
| ProcessingMode | ProcessingMode | Regular | This value specifies when indexing and aggregating occur. The options are Regular, which means that indexing and aggregating occur during processing, or Lazy, which means that indexing and aggregation occur after processing is completed. |
| ProcessingPriority | Int32 | 0 | This value specifies when indexing and aggregating occur. The options are Regular, which means that indexing and aggregating occur during processing, or Lazy, which means that indexing and aggregation occur after processing is completed. |
| StorageLocation | String | This value specifies the full path where the measure group’s files are located. If this value is not specified, then the storage location comes from the cube that contains the measure group. | |
| StorageMode | StorageMode | Molap | This value specifies which storage mode the measure group will use. |
Singleton Children
| Child | API Type | Description |
|---|---|---|
| <ErrorConfiguration /> | AstErrorConfigurationNode | The AstErrorConfigurationNode type defines how the SQL Server Analysis Services engine will respond to various potential error conditions while processing objects in the cube. |
| <ProactiveCaching /> | AstProactiveCachingNode | The AstProactiveCachingNodecorresponds directly to a proactive caching configuration definition in SQL Server Analysis Services. |
Collection Children
| Child | API Type | Description |
|---|---|---|
| <AggregationDesigns> <AggregationDesign /> </AggregationDesigns> | AstAggregationDesignNode | This is a container for aggregation designs associated with the measure group. |
| <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. |
| <CubeDimensionBindings> Multiple Choices... </CubeDimensionBindings> | AstCubeDimensionBindingBaseNode | This is a container for cube dimension bindings associated with the measure group. |
| <Measures> <Measure /> </Measures> | AstMeasureReferenceNode | This is a container for the measures that are associated with the measure group. Measures are defined in the underlying fact table and can be overridden in this collection with additional metadata values. |
| <Partitions> <Partition /> </Partitions> | AstPartitionNode | This is a container for partitions associated with measure group. |
| <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. |