Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 Objects.
To merge partitions
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.
Under Source Partitions, select the check box next to each source partition that you want to merge with the target partition, and click OK.