MDX Scripting Statements (MDX)

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

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)