Performs a conditional test, and returns an appropriate numeric expression or set depending on whether the test evaluates to true or false.
IIF ( search_condition, true_part, false_part )
| search_condition | An expression to evaluate as true or false. |
| true_part | A value_expression or a set. IIF returns this expression if the search condition evaluates to TRUE (something other than zero). |
| false_part | A value_expression or a set. IIF returns this expression if the search condition evaluates to FALSE (zero). |
The company plans an expensive promotion of its caffeinated drinks. For the Caffeinated products only, the following query calculates a Revised Budget that is 110% of the regular budget.
WITH MEMBER
[Scenario].[Revised Budget]
AS
'IIF (
[Product].CurrentMember.Caffeinated,
Budget * 1.1, Budget
)'
SELECT
{[Scenario].[Budget], [Scenario].[Revised Budget]}
ON COLUMNS,
[Product].Levels(0).Members
ON ROWS
FROM Sample.Basic
WHERE ([Measures].[Sales], [Year].[Qtr3])
This query returns the grid:
| Budget | Revised Budget | |
|---|---|---|
| 100-10 | 18650 | 20515 |
| 100-20 | 8910 | 9801 |
| 100-30 | 3370 | 3370 |
| 200-10 | 11060 | 12166 |
| 200-20 | 9680 | 10648 |
| 200-30 | 3880 | 3880 |
| 200-40 | 2660 | 2660 |
| 300-10 | 10600 | 11660 |
| 300-20 | 3760 | 4136 |
| 300-30 | 8280 | 9108 |
| 400-10 | 7750 | 7750 |
| 400-20 | 6800 | 6800 |
| 400-30 | 3290 | 3290 |
| 100-20 | 8910 | 8910 |
| 200-20 | 9680 | 9680 |
| 300-30 | 8280 | 8280 |
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |