SSAS Partition Manager: automating partitioning for Tabular and Multidimensional databases

SSAS Partition Manager automatically creates and manages partitions in both SQL Server Analysis Services (SSAS) multidimensional cubes and tabular models using a wide variety of partitioning schemes (yearly, monthly, etc.) and supports multiple measure groups in multiple cubes in multiple OLAP or Tabular databases.

What is more, for OLAP cubes it correctly sets the MDX in the PartitionSlice property of the partition so you don't have to rely on SQL Server Analysis Services' auto-slice functionality which has known bugs and limitations.

SSAS Partition Manager is a production ready application which is very easy to configure and can be easily integrated into your deployment scripts and regular data warehouse processing jobs. Indeed, a full set of unit and integration tests has been prepared for the SSAS Partition Manager to ensure the quality of the code.

Deploy and Partition Your Tabular Model or Multidimensional Cube

The latest release of SSAS Partition Manager provides the ability to both deploy a database (either Tabular or Multidimensional), add the partitions and process the newly deployed database.

Using command-line options you can now:
  • Deploy an OLAP cube or Tabular model
  • Create partitions using a wide variety of partitioning schemes
  • Process the newly deployed OLAP or Tabular database using ProcessFull
  • You can also create partitions in all databases on the server and then process them all using ProcessFull
See SSAS Partition Manager Command-Line Options for further information.

Supports multiple Partitioning Schemes

Each measure group can have its own partitioning scheme and out of the box it supports the following partitioning schemes.
  • Yearly
  • Quarterly
  • Monthly
  • Weekly
  • Daily
  • Hybrid
  • Matrix
Hybrid partitioning schemes are where some years use one scheme and other years use another. For example, previous years could be partitioned by quarter whereas the current year is partitioned by day. Matrix partitioning schemes are where you partition by date and some other dimension.

Easy to configure

All of this power is easy to configure by changing two SQL views and the content of three tables - well within the realms of the average business intelligence consultant!

So read the documentation and go to the download page and start using it today!

Written by Dr. John Tunnicliffe, independent business intelligence consultant
Available for consultancy assignments and speaking engagements

Last edited May 26, 2015 at 7:38 PM by JohnTunnicliffe, version 11