Creating Analysis Services Partitions Using BIDS

As your database grows in size, Analysis Services cubes that use that database grow along with it. As such, one thing that can improve performance of your cube is partitioning (splitting up) your measures. In this post, I am going to quickly show you how to switch from a table binding partition (default) to a query binding partition using a cube that I have built off of the AdventureWorksDW2008R2 database. In the end, you'll know how to split your large measure groups into smaller chunks of data based on the year.