Microsoft OLAP Blog by Hilmar Buchta PDW 2012 | SQL Server 2012 | SQL Server 2014 This post is about using the Parallel Data Warehouse as a ROLAP source for SSAS. For PDW v1 this wasn’t recommended but the quintessence of this post is, that this really works well with PDW 2012. In fact, this is the first time I saw MOLAP performance on large ROLAP tables (over a billion rows) and again, another big plus for the PDW with the column store index. In fact, I’m really excited about this (and I’ll tell you why in a minute), but maybe I wasn’t loud enough. So here again:
In this article we will show how to take typical, everyday MDX and optimize it by simply following advices of MDX Studio Analyzer. As a starting point, I will take “Product Volatility” example as published by Thomas Ivarson in his blog. It is a perfect example, because Thomas took a real business problem, and implemented it using very clean and straightforward MDX, just like I expect many MDX practitioners do. This MDX can be optimized, but some of these optimizations might not be obvious. Microsoft OLAP by Mosha Pasumansky
Microsoft Analysis Services Microsoft SQL Server Analysis Services, SSAS, is an online analytical processing (OLAP), data mining and reporting tool in Microsoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing.
Define attribute relationships as 'Rigid' where appropriate