THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » DAX » MDX   (RSS)
Showing page 2 of 2 (14 total posts)
  • Recursive calculations in MDX #ssas #mdx

    Jeffrey Wang wrote a very detailed blog post about recursive calculations in MDX with Analysis Services. In these days I'm doing some comparison between DAX and MDX (well, between Vertipaq/PowerPivot and OLAP/SSAS engines) and I'm discovering that MDX calculation engine is much more smart than you might think in certain conditions. I cannot ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 28, 2011
  • The Last Ever Non Empty calculation in MDX

    Chris Webb posted a wonderful solution to the Last “ever” non empty calculation in MDX. I never thought to this solution and it is really a nice approach. I think that DAX might be faster in this scenario – a similar calculation has been shown in this post from Alberto Ferrari, but to do a better comparison we should replicate the same calculation ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 27, 2011
  • Attribute Overwriting in MDX

    Jeffrey Wang wrote a great blog post about attribute overwriting in MDX that is very clear and full of helpful pictures to show what happens when you write an MDX statement that writes into your multidimensional space. This is very common in an MDX Script and if you tried to customize the DateTool solution you probably experienced how hard this ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 24, 2011
  • The Microsoft BI Roadmap: BISM, UDM and Beyond

    Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it will be queryable through MDX and DAX. DAX has been introduced in PowerPivot as an expression ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 15, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement