title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	ms.custom
MDX Scripting Statements (MDX)	MDX Scripting Statements (MDX)	kfollis	kfollis	kfollis	02/17/2022	sql	analysis-services	reference	mdx

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.