Finished the SSAS Maestro Week !!

Just finished the Analysis Services Maestro Week in Redmond. Phew quite a hectic week. So what’s it like ? Well a lot of the content is NDA, but to be fair most of the content seems to also be in three sources: The Ops Whitepaper, The Perf Whitepaper and the Analysis Services Unleashed Book: http://msdn.microsoft.com/en-us/library/hh226085.aspxContinue reading Finished the SSAS Maestro Week !!

No more IF Statements in MDX for Null Handling!

One of the most common things to need an IF statement for in MDX is to determine if a measure is NULL to ensure that you output Null instead of the actual calculation. Mosha pioneered an interesting “trick” for avoiding the use of “IF” to account for Null handling in Budget Variance (See http://sqlblog.com/blogs/mosha/archive/2006/11/05/budget-variance-a-study-of-mdx-optimizations-evaluation-modes-and-non-empty-behavior.aspx) Basically we … Continue reading No more IF Statements in MDX for Null Handling!