background preloader

Sql olap

Facebook Twitter

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.

Microsoft OLAP by Mosha Pasumansky

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.

Microsoft Analysis Services

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. MSDN Library Design Tools Development Tools and Languages Mobile and Embedded Development Online Services patterns & practices.

Define attribute relationships as 'Rigid' where appropriate