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