Cube Storage: Introduction to Partitions

In this article, we will continue the general exploration of cube storage that we began in Cube Storage: Introduction, this time focusing upon partitions. Our introduction to partitions here will lead to more detailed exploration of various concepts surrounding partitions in subsequent articles that examine partition planning, as well as hands-on sessions focused upon various tasks surrounding partitions, including:

• the creation of local partitions within the Business Intelligence Development Studio;
• the creation of multiple partitions for a single measure group, based upon views in the underlying relational database;
• the creation of multiple partitions for a single measure group, based upon named queries in Analysis Services;
• the creation of remote partitions within the Business Intelligence Development Studio;
• the creation of partitions within SQL Server Management Studio;
• filtering partitions;
• merging partitions.

Read more...