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

CALCULATE Statement (MDX)

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.

EXISTING Keyword (MDX)

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

Concepts

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