Jeffrey Wang wrote an interesting post about internals of IF statement in MDX script, describing how and when it is rewritten as a IIF statement. The interesting news in his post is also a possible query plan tool for MDX in the future. Probably not in Denali time, but I hope very soon…

Originally appeared on: http://sqlblog.com/blogs/marco_russo/archive/2011/06/28/if-and-iif-statement-in-mdx.aspx