MDX in SQL Server 2005 Analysis Services brings exciting improvements, Explain.

Question

MDX in SQL Server 2005 Analysis Services brings exciting improvements including query support and expression/calculation language, Explain.

Answer 1

MDX in SQL server 2005 Analysis services offers CASE and SCOPE statements. CASE returns specific values based upon its comparison of an expression to a set of simple expressions. It can perform conditional tests within multiple comparisons. SCOPE is used to define the current subcube. CALCULATE statement is used to populate each cell in the cube with aggregated data.