Skip to content

measuregroup-element-assl.md

Latest commit

 

History

History
119 lines (100 loc) · 7.11 KB

measuregroup-element-assl.md

File metadata and controls

119 lines (100 loc) · 7.11 KB
title MeasureGroup Element (ASSL) | Microsoft Docs
ms.custom
ms.date 03/07/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
analysis-services
docset-sql-devref
ms.tgt_pltfrm
ms.topic reference
apiname
MeasureGroup Element
apilocation
apitype Schema
applies_to
SQL Server 2016 Preview
f1_keywords
MeasureGroup
helpviewer_keywords
MeasureGroup element
ms.assetid 7aa099db-5dc7-4cac-b437-f73fc0921b24
caps.latest.revision 36
author Minewiskan
ms.author owend
manager erikre

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 See the table below.
Default value None
Cardinality 0-n: Optional element that can occur more than once.
Ancestor or Parent Data Type
Cube None
CubeBinding MeasureGroupBinding
Perspective PerspectiveMeasureGroup

Element Relationships

Relationship Element
Parent elements MeasureGroups
Child elements See the table below.
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 xref:Microsoft.AnalysisServices.MeasureGroup and xref:Microsoft.AnalysisServices.PerspectiveMeasureGroup.

See Also

Objects (ASSL)