Export (0) Print
Expand All

MDX Scripting Statements (MDX)

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

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft