2.2.4.2.2.11 MeasureGroup

This complex type represents a measure group in the cube.

   <xsd:complexType name="MeasureGroup">
     <xsd:all>
       <!--These elements are common to each MajorObject-->
       <xsd:element name="Name"  type="xsd:string" />
       <xsd:element name="ID"  type="xsd:string" minOccurs="0" />
       <xsd:element name="CreatedTimestamp" type="xsd:dateTime" minOccurs="0" />
       <xsd:element name="LastSchemaUpdate" type="xsd:dateTime" minOccurs="0" />
       <xsd:element name="Description" type="xsd:string" minOccurs="0" />
       <xsd:element name="Annotations"  minOccurs="0" >
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="Annotation" type="Annotation" minOccurs="0"
                          maxOccurs="unbounded" />
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <!--Extended elements for MeasureGroup object-->
       <xsd:element name="LastProcessed" type="xsd:dateTime" minOccurs="0"/>
       <xsd:element name="Translations" minOccurs="0">
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="Translation"  type="Translation" minOccurs="0"
                          maxOccurs="unbounded"/>
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:element name="Type" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="Regular" />
             <xsd:enumeration value="ExchangeRate" />
             <xsd:enumeration value="Sales" />
             <xsd:enumeration value="Budget" />
             <xsd:enumeration value="FinancialReporting" />
             <xsd:enumeration value="Marketing" />
             <xsd:enumeration value="Inventory" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="State" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="Processed" />
             <xsd:enumeration value="PartiallyProcessed" />
             <xsd:enumeration value="Unprocessed" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="Measures" >
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="Measure"  type="Measure"
                          maxOccurs="unbounded"/>
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:element name="DataAggregation" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="None" />
             <xsd:enumeration value="DataAggregatable" />
             <xsd:enumeration value="CacheAggregatable" />
             <xsd:enumeration value="DataAndCacheAggregatable" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="Source" type="MeasureGroupBinding" minOccurs="0" />
       <xsd:element name="StorageMode" minOccurs="0">
         <xsd:complexType>
           <xsd:simpleContent>
             <xsd:extension base="MeasureGroupStorageModeEnumType">
               <xsd:attribute name="valuens" >
                 <xsd:simpleType>
                   <xsd:restriction base="xsd:string">
                     <xsd:enumeration value=
             "http://schemas.microsoft.com/analysisservices/2010/engine/200/200" />
                   </xsd:restriction>
                 </xsd:simpleType>
               </xsd:attribute>
             </xsd:extension>
           </xsd:simpleContent>
         </xsd:complexType>
       </xsd:element>
       <xsd:element name="StorageLocation" type="xsd:string" minOccurs="0" />
       <xsd:element name="IgnoreUnrelatedDimensions" type="xsd:boolean"
                    minOccurs="0"/>
       <xsd:element name="ProactiveCaching" type="ProactiveCaching"
                    minOccurs="0" />
       <xsd:element name="EstimatedRows" type="xsd:long" minOccurs="0"/>
       <xsd:element name="ErrorConfiguration" type="ErrorConfiguration"
                    minOccurs="0" />
       <xsd:element name="EstimatedSize" type="xsd:long" minOccurs="0"/>
       <xsd:element name="ProcessingMode" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="Regular"/>
             <xsd:enumeration value="LazyAggregations"/>
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="Dimensions" >
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="Dimension"  type="MeasureGroupDimension"
                          maxOccurs="unbounded"/>
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:element name="Partitions" minOccurs="0">
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="Partition"  type="Partition" minOccurs="0"
                          maxOccurs="unbounded"/>
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:element name="AggregationPrefix" type="xsd:string" minOccurs="0"/>
       <xsd:element name="ProcessingPriority" type="xsd:integer" minOccurs="0"/>
       <xsd:element name="AggregationDesigns" minOccurs="0">
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="AggregationDesign"  type="AggregationDesign"
                          minOccurs="0" maxOccurs="unbounded"/>
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
     </xsd:all>
   </xsd:complexType>
            
            
   <xsd:simpleType name="MeasureGroupStorageModeEnumType">
     <xsd:restriction base="xsd:string" >
       <xsd:enumeration value="Molap" />
       <xsd:enumeration value="Rolap" />
       <xsd:enumeration value="Holap" />
       <xsd:enumeration value="InMemory" />
     </xsd:restriction>
   </xsd:simpleType>

The following table describes the elements that are included in the XSD schema for MeasureGroup. Those elements common to all major objects are described in section 2.2.4.2.2.1.

Element

Read-Only

Default value

Description

LastProcessed

Yes

A timestamp indicating the date and time when the MeasureGroup was last processed.

Translations

Empty

A collection of Translation objects.

Type

"Regular"

Provides both the server and client applications with information about the contents of the MeasureGroup.

State

Yes

The state of processing of the object.

Measures

Empty

A collection of Measure objects.

DataAggregation

"DataAndCacheAggregatable"

Indicates whether the server can aggregate data (persisted on disk or cached in memory).

Source

Empty

The source of data for MeasureGroup. MUST NOT be used if DataSourceID for cube is not OLAP sourced DataSourceView. If present, MUST be of type MeasureGroupBinding.

StorageMode

Default is the value from the Cube

The storage mode for this object. When the value of StorageMode is "InMemory", the valuens attribute MUST be used.

StorageLocation

Default is the value from the Cube

The file system storage location.

IgnoreUnrelatedDimensions

True

When true, specifies to ignore dimensions unrelated to this MeasureGroup in an MDX query or expression; otherwise, false.

ProactiveCaching

Empty

Proactive caching settings for the MeasureGroup.

EstimatedRows

Empty

The estimated number of rows in the MeasureGroup.

ErrorConfiguration

Empty

Error configuration settings for this MeasureGroup.

EstimatedSize

Yes

The estimated size of the MeasureGroup in bytes.

ProcessingMode

"Regular"

The processing mode for the object.

Dimensions

Empty

A collection of type MeasureGroupDimension. None are allowed if there is a MeasureGroupBinding at time of creation. When returned by DISCOVER_XML_METADATA, at least one Dimension is always returned.

Partitions

Empty

A collection of Partition objects.

AggregationPrefix

Empty

A prefix used on tables that are used for aggregation. This serves as default for partitions in this MeasureGroup.

ProcessingPriority

Zero

An integer that determines the priority for processing.

AggregationDesigns

Empty

A collection of objects of type AggregationDesign.

  • Last updated on