The Advanced MDX Course – Performance, Optimization, and the MDX Script
I have just completed writing SolidQ’s new 2-day Advanced MDX course.
There’s one module on Advanced Functions, which covers a whole variety of functions which are less commonly used – drilldown functions, statistical functions, etc.
There’s also a module on Advanced Sets, which covers the Generate function in detail as well as how to reference the hierarchies the user places on the axes.
I have two modules on using MDX scripting, with one of those modules covering date calculation hierarchies. This is one of my favorite topics. The ability to create date calculation hierarchies is a wonderful feature of Analysis Services cubes and most developers don’t come close to taking advantage of the possibilities it offers.
And finally I have 4 modules on MDX performance and optimization. One of those modules is on block computation. Another module covers subcubes and subselects. I wrote this Advanced MDX course using Analysis Services in SQL Server 2012. Almost all the information is relevant for SSAS 2008 and even SSAS 2005. But there are some performance surprises in SSAS2012 which haven’t been documented by Microsoft yet.
I am hoping to normally offer the new beginning SolidQ MDX course (MDX for Business Logic) together with the Advanced Course, so that students can come to either the 2-day Business Logic course by itself, the 2-day Advanced Course by itself, or attend all four days for a comprehensive understanding of MDX.