Microsoft OLAP Blog by Hilmar Buchta. Microsoft OLAP by Mosha Pasumansky. 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 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.