MDX Scripting Statements (MDX)

In Multidimensional Expressions (MDX), the following statements manage context, scope, and control of flow within MDX scripts.

In This Section

Topic Description


Calculates a subcube, optionally determining the solve order of dimensions included within the subcube.

CASE Statement (MDX)

Lets you conditionally return specific values from multiple comparisons.


Forces a specified set to be evaluated within the current context.

FREEZE Statement (MDX)

Locks the cell values of a specified subcube to their current values.

IF Statement (MDX)

Executes a statement if the condition is true.

SCOPE Statement (MDX)

Limits the scope of specified MDX statements to a specified subcube.

See Also


MDX Scripting Fundamentals (MDX)

Other Resources

MDX Statement Reference (MDX)
MDX Data Definition Statements (MDX)
MDX Data Manipulation Statements (MDX)

Help and Information

Getting SQL Server 2005 Assistance