MeasureGroup Element (ASSL)

 

Applies To: SQL Server 2016 Preview

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

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

CharacteristicDescription
Data type and lengthSee the table below.
Default valueNone
Cardinality0-n: Optional element that can occur more than once.
Ancestor or ParentData Type
CubeNone
CubeBindingMeasureGroupBinding
PerspectivePerspectiveMeasureGroup
RelationshipElement
Parent elementsMeasureGroups
Child elementsSee the table below.
Ancestor or ParentChild 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

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.

Objects (ASSL)

Community Additions

ADD
Show: