Database Reference
In-Depth Information
2. Choose
Fact Reseller Sales
as the target,
Reseller Sales 2006
and
Reseller Sales 2007
as sources, and click on
OK
. Alternatively, you could
also script the XMLA command, which would be similar to the following:
<MergePartitionsx
mlns="http://schemas.microsoft.com/
analysisservices/2003/engine">
<Sources>
<Source>
<DatabaseID>ssas_cookbook_chapter3</DatabaseID>
<CubeID>AdventureWorksSample</CubeID>
<MeasureGroupID>Fact Reseller
Sales</MeasureGroupID>
<PartitionID>Reseller Sales
2008</PartitionID>
Search WWH ::
Custom Search