MDX IIF Execution Plans and Plan Hints

MDX IIF function, and similarly MDX CASE statement, is often a cause of performance issues during execution of MDX formulas. As a developer who worked on this feature, I'll explain the execution plans considered by the MDX formula engine (FE) in this post.

Introduction to some FE concepts