AND (MDX)
Performs a logical conjunction on two numeric expressions.
Syntax
Expression1 AND Expression2
Parameters
Expression1
A valid Multidimensional Expressions (MDX) expression that returns a numeric value.
Expression2
A valid MDX expression that returns a numeric value.
Return Value
A Boolean value that returns true if both parameters evaluate to true; otherwise, false.
Remarks
The AND operator treats both expressions as Boolean values (zero, 0, as false; otherwise, true) before the operator performs the logical conjunction. The following table illustrates how the AND operator performs the logical conjunction.
| Expression1 | Expression2 | Return Value |
|---|---|---|
| true | true | true |
| true | false | false |
| false | true | false |
| false | false | false |
Example
-- This query returns the gross profit margin (GPM)
-- for clothing sales where the GPM is between 20% and 30%.
With Member [Measures].[LowGPM] as
IIF(
[Measures].[Gross Profit Margin] <= .3 AND
[Measures].[Gross Profit Margin] >= .2,
[Measures].[Gross Profit Margin],
null)
SELECT NON EMPTY
[Sales Territory].[Sales Territory Country].Members ON 0,
[Product].[Category].[Clothing] ON 1
FROM
[Adventure Works]
WHERE
([Measures].[LowGPM])