MDX Scripting Statements (MDX)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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)