Report Portal

SQL Server Analysis Services Multidimensional Model - Merging Partitions with Slice

According to SQL Server Books Online: Partitions can be merged only if you meet all of the following criteria:

  • They are in the same cube.
  • They have the same structure.
  • They have the same storage modes.
  • They contain identical aggregation designs.
  • They share the same string store compatibility level (applies to partitioned distinct count measure groups only).


Tags: partition, management, performance, aggregation


2007-2015 VidasSoft Systems Inc.