MeasureGroup Element (ASSL)

  • Article

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

Cube

None

CubeBinding

MeasureGroupBinding

Perspective

PerspectiveMeasureGroup

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

Cube

AggregationDesigns, 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

CubeBinding

None

Perspective

None

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)