Entries Published On June, 2014
Building an OLAP Farm in the Cloud with Azure Virtual Machines – Part 1
FYI: the features needed to implement the OLAP Farm architecture (Remote partitions, Remote linked measure groups, Linked dimensions) have been deprecated as of SQL 2014. The “OLAP Farm” is an Analysis Services architecture that makes use of remote partitions on the backend and linked dimensions and measure groups on the front end in order to …
SSAS Scale-Out Architectures
Processing can be a very resource intensive task which will absolutely interfere with query performance when using a single server deployment. Most clients can get around this issue by simply processing after hours and/or designing and implementing a complex incremental processing scenario (e.g. process add + process partitions). However, when it comes to large data …
Case Study Review: Using Tabular Models in a Large-scale Commercial Solution
Just a few days ago, a case study was released by one of the top Microsoft BI folks in the world – Alberto Ferrari (b | t) – outlining the evaluation process of using SSAS Tabular in a large-scale commercial solution. This paper is a must-read for those considering the use of SSAS Tabular in …