Report Portal

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

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:

Read more...

Tags: partition

 

2007-2015 VidasSoft Systems Inc.