2.2.4.2.2.13 Partition
The Partition complex type represents a partition of a measure group.
-
<xsd:complexType name="Partition"> <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 Partition object--> <xsd:element name="Source" type="TabularBinding" minOccurs="0" /> <xsd:element name="ProcessingPriority" type="xsd:integer" minOccurs="0"/> <xsd:element name="AggregationPrefix" type="xsd:string" minOccurs="0"/> <xsd:element name="StorageMode" minOccurs="0"> <xsd:complexType> <xsd:simpleContent> <xsd:extension base="PartitionStorageModeEnumType"> <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="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="ErrorConfiguration" type="ErrorConfiguration" minOccurs="0" /> <xsd:element name="StorageLocation" type="xsd:string" minOccurs="0"/> <xsd:element name="RemoteDatasourceID" type="xsd:string" minOccurs="0"/> <xsd:element name="Slice" type="xsd:string" minOccurs="0"/> <xsd:element name="ProactiveCaching" type ="ProactiveCaching" minOccurs="0" /> <xsd:element name="Type" minOccurs="0"> <xsd:simpleType> <xsd:restriction base="xsd:string" > <xsd:enumeration value="Data" /> <xsd:enumeration value="Writeback" /> </xsd:restriction> </xsd:simpleType> </xsd:element> <xsd:element name="EstimatedSize" type="xsd:long" minOccurs="0"/> <xsd:element name="EstimatedRows" type="xsd:long" minOccurs="0"/> <xsd:element name="CurrentStorageMode" minOccurs="0"> <xsd:complexType> <xsd:simpleContent> <xsd:extension base="PartitionCurrentStorageModeEnumType"> <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="AggregationDesignID" type="xsd:string" minOccurs="0"/> <xsd:element name="AggregationInstances" minOccurs="0"> <xsd:complexType> <xsd:sequence> <xsd:element name="AggregationInstance" type="AggregationInstance" minOccurs="0" maxOccurs="unbounded"/> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="AggregationInstanceSource" type="DataSourceViewBinding" minOccurs="0" /> <xsd:element name="LastProcessed" type="xsd:dateTime" minOccurs="0"/> <xsd:element name="State" minOccurs="0"> <xsd:simpleType> <xsd:restriction base="xsd:string" > <xsd:enumeration value="Processed" /> <xsd:enumeration value="Unprocessed" /> </xsd:restriction> </xsd:simpleType> </xsd:element> <xsd:element ref="eng300:StringStoresCompatibilityLevel" minOccurs="0"/> <xsd:element ref="eng300:CurrentStringStoresCompatibilityLevel" minOccurs="0"/> <xsd:element ref="eng300_300:DirectQueryUsage" minOccurs="0"/> </xsd:all> </xsd:complexType> <xsd:simpleType name="PartitionStorageModeEnumType"> <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> <xsd:simpleType name="PartitionCurrentStorageModeEnumType"> <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>
In the namespace eng300_300:
-
<xsd:element name="DirectQueryUsage" > <xsd:simpleType> <xsd:restriction base="xsd:string" > <xsd:enumeration value="InMemoryWithDirectQuery" /> <xsd:enumeration value="DirectQueryOnly" /> <xsd:enumeration value="InMemoryOnly" /> </xsd:restriction> </xsd:simpleType> </xsd:element>
The following table describes the elements that are included in the XSD schema for Partition. Those elements common to all major objects are described in section 2.2.4.2.2.1.
|
Element |
Read-Only |
Default value |
Description |
|---|---|---|---|
|
Source |
|
Empty |
Specifies the source of the partition data. |
|
ProcessingPriority |
|
Zero |
Integer that determines the priority for processing. |
|
AggregationPrefix |
|
Empty |
A prefix that is pre-pended to the names of aggregation tables/views. |
|
StorageMode |
|
StorageMode of the parent MeasureGroup |
Determines the storage mode for the partition. When the value of StorageMode is "InMemory", the valuens attribute MUST be used. |
|
ProcessingMode |
|
ProcessingMode of the parent Cube |
A string that specifies whether aggregations and indexes are to be built lazily. For more information about lazy aggregations, see section 1.1. |
|
ErrorConfiguration |
|
Empty |
Error configuration settings to handle issues in the source data. |
|
StorageLocation |
|
StorageLocation of the parent MeasureGroup |
The file system storage location for the partition. |
|
RemoteDatasourceID |
|
Empty |
Specifies the ID of the OLAP data source that points to the remote server where this partition is stored. |
|
Slice |
|
Empty |
An MDX expression that defines the slice that is contained in the partition. |
|
ProactiveCaching |
|
Empty |
Proactive caching settings for this partition. |
|
Type |
|
"Data" |
Indicates partition type as either Data or Writeback. If Type is set to "Writeback", the Source element MUST NOT be empty, and all Measure objects for the cube MUST use "Sum" as the value of the AggregateFunction element. |
|
EstimatedSize |
Yes |
|
The estimated size of the partition in bytes. |
|
EstimatedRows |
|
0 |
Estimated number of rows. |
|
CurrentStorageMode |
Yes |
|
The current storage mode of the partition. Used for proactive caching when StorageMode might transiently change. When the value of StorageMode is "InMemory", the valuens attribute MUST be used. |
|
AggregationDesignID |
|
Empty |
The ID of the AggregationDesign for the partition. |
|
AggregationInstances |
|
Empty |
A collection of AggregationInstance objects. |
|
AggregationInstanceSource |
|
Defaults to Source element of the cube. |
The source of the aggregation instance data. |
|
LastProcessed |
Yes |
|
The date and time when the partition was last processed. |
|
State |
Yes |
|
Represents the processing state of the partition. Values include:
|
|
StringStoresCompatibilityLevel |
|
1050 |
An enumeration value that specifies the string store compatibility level that will be instituted the next time the object is processed. The valid values are the following:
|
|
CurrentStringStoresCompatibilityLevel |
Yes |
1050 |
An enumeration value that specifies the string store compatibility level that is currently in effect. The interpretation of the values is the same as for StringStoresCompatibilityLevel. |
|
DirectQueryUsage |
|
InMemoryWithDirectQuery |
DirectQueryUsage specifies how a partition is to be queried. Values are:
|