Creating Analysis Services Cubes - SQL Server Analysis Services 2012 Cube Development - page 98

How to do it...
Creating a partition through XMLA is straightforward, regardless of the method you
choose to use. The statement for creating a partition will be sent to the SSAS server
in XMLA language, so it makes sense to first take a look at the XMLA used to define
a partition:
1. Connect to an SSAS instance using SSMS, expand the database of your
choice, and navigate to cube | measure groups | partition . If you have been
following along the recipes included in this chapter, you will see a measure
group with a single partition in the database you created earlier.
2. Right-click on the partition , navigate to Script partition as | Create to | New
Query Editor Window , and you will see XMLA similar to following:
<Createxmlns="http://schemas.microsoft.com/
analysisservices/2003/engine">
<ParentObject>
<DatabaseID>ssas_cookbook_chapter3</DatabaseID>
<CubeID>AdventureWorksSample</CubeID>
<MeasureGroupID>Fact Reseller
Sales</MeasureGroupID>
</ParentObject>
<ObjectDefinition>
<Partitionxmlns:xsd="http://www.w3.org/
2001/
XMLSchema"xmlns:xsi="http://www.w3.org/
2001/
XMLSchema-instance"xmlns:ddl2="http://schemas.microsoft.com/
analysisservices/2003/engine/
2"xmlns:ddl2_2= http://schemas.microsoft.com/
analysisservices/2003/engine/
2/2 x mlns:ddl100_100="http://schemas.microsoft.com/
analysisservices/2008/engine/100/
100"xmlns:ddl200="http://schemas.microsoft.com/
analysisservices/2010/engine/
200"xmlns:ddl200_200="http://schemas.microsoft.com/
analysisservices/2010/engine/200/
200"xmlns:ddl300="http://schemas.microsoft.com/