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

MDX Statement Reference (MDX)
MDX Data Definition Statements (MDX)
MDX Data Manipulation Statements (MDX)
MDX Scripting Fundamentals (Analysis Services)