MDX Scripting Statements (MDX)


Updated: March 2, 2016

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

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.

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

Community Additions