| description | MDX Scripting Statements (MDX) |
|---|---|
| title | MDX Scripting Statements (MDX) | Microsoft Docs |
| ms.date | 02/17/2022 |
| ms.prod | sql |
| ms.technology | analysis-services |
| ms.custom | mdx |
| ms.topic | reference |
| ms.author | owend |
| ms.reviewer | owend |
| author | minewiskan |
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. |
MDX Statement Reference (MDX)
MDX Data Definition Statements (MDX)
MDX Data Manipulation Statements (MDX)
MDX Scripting Fundamentals (Analysis Services)