How To Define Measure Group Partitions in SQL Server Analysis Services (SSAS) 2005-SSAS

How To Define Measure Group Partitions in SQL Server Analysis Services (SSAS) 2005

Written by Ray Barley

Monday, 25 August 2008 02:32

Problem
We are anticipating building some very large cubes and would like to get a handle on how to partition our measure groups to provide flexibility in processing and administering our cubes. Can you guide us through the steps to define multiple partitions for a measure group and provide some explanations?

Solution
The default behavior in SSAS is to create a single partition for a measure group. Creating multiple partitions for a measure group is definitely a best practice when you have very large fact tables. The following are the advantages of multiple partitions: