Going in Production - Expert Cube Development with SSAS Multidimensional Models - page 294

If we script the Sales of Year 2003 partition into an XMLA query editor window
in SQL Management Studio we can see its definition and understand what the
package has done; here's the part of the definition where all the important properties
are set:
<ObjectDefinition>
<Partition>
<ID>Sales of Year 2003</ID>
<Name>Sales of Year 2003</Name>
<Annotations>
<Annotation>
<Name>MonthsInsidePartition</Name>
<Value>200301200302200303200304200305200306</Value>
</Annotation>
<Annotation>
<Name>PartitionType</Name>
<Value>YEAR</Value>
</Annotation>
</Annotations>
<Source xsi:type="QueryBinding">
<DataSourceID>Adv DM</DataSourceID>
<QueryDefinition>
SELECT * FROM CubeSales.Sales WHERE
OrderYearMonth=200301
UNION ALL
SELECT * FROM CubeSales.Sales WHERE
OrderYearMonth=200302
UNION ALL
SELECT * FROM CubeSales.Sales WHERE
OrderYearMonth=200303
UNION ALL
SELECT * FROM CubeSales.Sales WHERE
OrderYearMonth=200304
UNION ALL
SELECT * FROM CubeSales.Sales WHERE
OrderYearMonth=200305
UNION ALL
SELECT * FROM CubeSales.Sales WHERE
OrderYearMonth=200306
</QueryDefinition>
</Source>
</Partition>
</ObjectDefinition>