| title | IF Statement (MDX) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/02/2016 | |
| ms.prod | sql-server-2016 | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | language-reference | |
| dev_langs |
|
|
| helpviewer_keywords |
|
|
| ms.assetid | 8830cce5-9e06-4f89-a555-295bb0d0a8a1 | |
| caps.latest.revision | 13 | |
| author | Minewiskan | |
| ms.author | owend | |
| manager | erikre |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Executes a statement if the condition is true.
IF expression THEN assignment END IF
expression
A Multidimensional Expressions (MDX) expression that evaluates to a Boolean that returns true or false.
assignment
An MDX expression that assigns a value to either a subcube or a calculated property.
Use the IF statement for control flow, which is unlike the IIf (MDX) function and the CASE Statement (MDX) that can only be used to return values or objects.
In the following example, the scope is restricted to the Country level of the Customers Geography hierarchy in the Customers dimension. If the current measure is Internet Sales Amount, then the Internet Sales Amount is set to 10:
SCOPE ([Customer].[Customer Geography].[Country].MEMBERS);
IF Measures.CurrentMember IS [Measures].[Internet Sales Amount] THEN this = 10 END IF;
END SCOPE;