Configuring Measure Group Properties
Measures groups have properties that enable you to define how measure groups function.
Measure Group Properties
Measure group properties determine behaviors for the entire measure group and set the default behaviors for certain properties new objects created within a measure group.
| Property | Definition |
|---|---|
AggregationPrefix |
Specifies the common prefix that is used for aggregation names. |
DataAggregation |
Determines whether Analysis Services can aggregate persisted data or cached data for the measure group. Default is to aggregate persisted data and cached data. |
ErrorConfiguration |
Configurable error handling settings for handling of duplicate keys, unknown keys, null keys, error limits, action upon error detection, and the error log file. |
EstimatedRows |
Specifies the estimated number of rows in the fact table. |
EstimatedSize |
Specifies the estimated size (in bytes) of the measure group. |
ID |
Specifies the identifier of the object. |
IgnoreUnrelatedDimensions |
Determines whether unrelated dimensions are forced to their top level when members of dimensions that are unrelated to the measure group are included in a query. Default setting is True. |
ProactiveCaching |
Specifies the proactive caching settings for the measure group. |
ProcessingMode |
Indicates whether indexing and aggregating should occur during or after processing. Options are Regular and LazyAggregations. |
ProcessingPriority |
Determines the processing priority of the cube during background operations, such as lazy aggregations and indexing. The default value is 0. |
StorageLocation |
The file system storage location for the measure group. If none is specified, the location is inherited from the cube that contains the measure group. |
StorageMode |
The storage mode for the measure group. Available values are MOLAP, ROLAP, or HOLAP. |
Type |
Specifies the type of the measure group. |
Note
For more information about setting values for the ErrorConfiguration property when working with null values and other data integrity issues, see Handling Data Integrity Issues in Analysis Services 2005.
See Also
Concepts
Defining and Configuring a Measure