Administering Analysis Services - Professional SQL Server Analysis Services 2005 with MDX - page 573

1. Launch the Merge partition dialog by right-clicking the Partitions
folder within a measure group. You will see the Merge partition dialog
as shown in Figure 12-16 .
Figure 12-16
2. Select the Target partition that will contain the merged data and the
list of partitions to merge data from in the Merge partition dialog as
shown in Figure 12-16 and click OK.
All the data from the source partitions will merge into the target partition, and
the source partitions are deleted due to this operation. SSMS sends the fol-
lowing command to Analysis Services to merge the partitions:
<MergePartitions xmlns="http://schemas.microsoft.com/
analysisservices/2003/engine">
<Sources>
<Source>
<DatabaseID>AnalysisServices2005Tutorial</DatabaseID>
<CubeID>Adventure Works DW</CubeID>
<MeasureGroupID>Fact Internet