Ways of Improving MDX Performance and Improvements with MDX in Katmai (SQL 2008)

1. Use calculated members with Scope assignments instead of using IIF The reason this option is faster is because the scope subcube definitions enable the Query Execution Engine to know ahead of time the calculation space for each business rule. Using this information, the Query Execution Engine can select an optimized execution path to execute…

1