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:

  • Processed

  • Unprocessed

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:

  • 1050 – Standard string handling.

  • 1100 – Enhanced string handling.<89>

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:

  • InMemoryWithDirectQuery

  • DirectQueryOnly

  • InMemoryOnly