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
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.
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
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