MeasureGroup Element (ASSL)

Defines a set of measures at the same level of granularity.

Syntax

<MeasureGroups>
   <MeasureGroup> <!-- ancestor: Cube -->
      <Name>...</Name>
      <ID>...</ID>
      <CreatedTimestamp>...</<Create
      <LastSchemaUpdate>...</LastSchemaUpdate>
      <Description>...</Description>
      <LastProcessed>...</LastProcessed>
      <Translations>...</Translations>
      <Type>...</Type>
      <State>...</State>
      <MeasureQualification>...</MeasureQualification>
      <Measures>...</Measures>
      <DataAggregation>...</DataAggregation>
      <Source>...</Source>
            <StorageMode>...</StorageMode>
      <StorageLocation>...</StorageLocation>
      <IgnoreUnrelatedDimensions>...</IgnoreUnrelatedDimensions>
            <ProactiveCaching>...</ProactiveCaching>
      <EstimatedRows>...</EstimatedRows>
      <ErrorConfiguration>...</ErrorConfiguration>
      <EstimatedSize>...</EstimatedSize>
      <ProcessingMode>...</ProcessingMode>
      <Dimensions>...</Dimensions>
      <Partitions>...</Partitions>
      <AggregationPrefix>...</AggregationPrefix>
      <ProcessingPriority>...</ProcessingPriority>
            <AggregationDesigns>...</AggregationDesigns>
      <Annotations>...</Annotations>
   </MeasureGroup>
   <!-- or  -->
   <MeasureGroup xsi:type="MeasureGroupBinding">...</MeasureGroup> <!-- ancestor: CubeBinding -->
   <!-- or  -->
   <MeasureGroup xsi:type="PerspectiveMeasureGroup">...</MeasureGroup> <!-- ancestor: Perspective -->
</MeasureGroups>

Element Characteristics

Characteristic

Description

Data type and length

Ancestor or Parent

Data Type

CubeNone

CubeBindingMeasureGroupBinding

PerspectivePerspectiveMeasureGroup

Default value

None

Cardinality

0-n: Optional element that can occur more than once.

Element Relationships

Relationship

Element

Parent elements

MeasureGroups

Child elements

Ancestor or Parent

Child elements

CubeAggregationDesigns, AggregationPrefix, Annotations, CreatedTimestamp, DataAggregation, Description, Dimensions, ErrorConfiguration, EstimatedRows, EstimatedSize, ID, IgnoreUnrelatedDimensions, LastProcessed, LastSchemaUpdate, MeasureQualification, Measures, Name, Partitions, ProactiveCaching, ProcessingMode, ProcessingPriority, Source, State, StorageLocation, StorageMode, Translations, Type

CubeBindingNone

PerspectiveNone

Remarks

All the measures of a measure group must be sourced from a single table. A measure group can define default bindings that can be overridden for each partition.

The MeasureGroup element defines details common to measure groups on regular cubes and virtual cubes. Separate subtypes define the details specific to each type.

The State property of a MeasureGroup has the following values:

• FullyProcessed if all partitions are processed.
• PartiallyProcessed if at least one partition is processed.
• Unprocessed if no partitions are processed.

The corresponding elements in the Analysis Management Objects (AMO) object model are MeasureGroup and PerspectiveMeasureGroup.

See Also

Reference

Objects (ASSL)

Help and Information

Getting SQL Server 2005 Assistance