How to: Merge Partitions

You merge partitions in SQL Server Management Studio. In order for partitions to be merged successfully,both partitions must have the same aggregation design, and they must be in a processed state. For more information about partition processing, see Processing (Analysis Services - Multidimensional Data).

To merge partitions

  1. In Object Explorer, expand the Measure Groups node of the cube containing the partitions that you want to merge, expand Partitions, right-click the partition, and then click Merge Partitions.

    The Merge Partition <partition name> dialog opens.

  2. Under Source Partitions, select the check box next to each source partition that you want to merge with the target partition, and click OK.