…brew your own Business Intelligence

Archive for January 2015

Moving a Cube Partition Without Unprocessing It

Last week I spent some time redesigning a SSAS multidimensional cube and part of that effort involved re-partitioning the measure group by customer (instead of date) and redistributing the partitions across a new set of drives. Initial testing shows serious performance improvement (which I plan to blog about in a […]

Read more

Building an OLAP Farm in the Cloud with Azure Virtual Machines – Part 3

This is the third part in a series of posts on the “OLAP Farm” – which is an Analysis Services architecture that makes use of remote partitions on the backend and linked dimensions and linked measure groups on the front end in order to support solutions where datasets and latency […]

Read more