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!
Category: mdx
From what I see there are no decent MDX training course in Ireland as being a smaller country we don’t have any world class “gurus” in the MDX training business. If we do, drop me an email 😉 I’ve helped organize a once off MDX training course with Chris Webb on 16th/17th of September. If … Continue reading MDX Training in September with Chris Webb