THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » MDX » performance   (RSS)
  • Gross margin - dense vs. sparse block evaluation mode in MDX

    Gross margin (also known as Gross profit margin or Gross profit rate) is defined as (Revenue – Cost of Sales)/Revenue. In terms of Adventure Works sample database we can write this in MDX as [Gross Margin] = ([Measures].[Internet Sales Amount] - [Measures].[Internet Total Product Cost]) / [Measures].[Internet Sales Amount]; While this ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on November 1, 2008
  • Optimizing order of sets in MDX crossjoins

    For scalar values a*b is the same as b*a. (although we saw that performance of these two could be different in MDX in “Performance of multiplication in MDX” article). But if a and b are sets, then obviously results are different – since the order of tuples in the resulting set will be different. But does it matter if we were to perform some other ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on October 24, 2008
  • Optimizing MDX aggregation functions

    One of the most significant changes in Analysis Services 2008 was improving performance of MDX queries and calculations. In particular, query optimizer can choose block (a.k.a. subspace) computation mode in query plan more often than in AS2005, and usually using block/subspace computation mode brings performance orders of magnitude better than ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on October 22, 2008
  • Get most out of partition slices

    Setting partition slice has always been an important optimization technique in Analysis Services. Every presentation talked about it and every whitepaper mentioned it, for example the Microsoft SQL Server 2000 Analysis Services Performance Guide contains a chapter appropriately named “Define the Data Slice for Each Partition”, here is a quote from ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on October 14, 2008
  • Product Volatility: Optimizing MDX with MDX Studio

    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 ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on July 29, 2008
Privacy Statement