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.aspx … Continue reading Finished the SSAS Maestro Week !!
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!