Report Portal

SSAS: Automating OLAP cube deployment, dynamic partitioning and processing

Imagine been able to deploy your OLAP database, dynamically partition the cube and then process the new database all in one step from an .asDatabase file with minimal configuration. Well now you can! Today's release of the OlapPartitionManager provides a set of features which allow you to do just that. What is more, for the first time you can easily integrate the build and deployment of OLAP databases into your continuous integration tasks so you can write regression tests that check the figures in your cube. OLAP cube deployment is usually done using the Analysis Services Deployment Wizard. However, the wizard only deploys the partitions that were part of the original cube design; it will not dynamically add the new partitions required by your partitioning scheme.

Read more...

Tags: management, process

 

2007-2015 VidasSoft Systems Inc.