title MDX Scripting Statements (MDX) | Microsoft Docs ms.custom ms.date 03/02/2016 ms.prod sql-server-2016 ms.reviewer ms.suite ms.technology analysis-services ms.tgt_pltfrm ms.topic language-reference dev_langs kbMDX helpviewer_keywords MDX [Analysis Services], scripts scripts [MDX], statements Multidimensional Expressions [Analysis Services], scripts ms.assetid a4e5f377-6f06-4888-9663-91105b205ac1 caps.latest.revision 31 author Minewiskan ms.author owend manager erikre MDX Scripting Statements (MDX) [!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md] 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)