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 (Analysis Services)

Other Resources

MDX Statement Reference (MDX)

MDX Data Definition Statements (MDX)

MDX Data Manipulation Statements (MDX)