This topic has not yet been rated - Rate this topic

AND (MDX)

Performs a logical conjunction on two numeric expressions.

Copy


          

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

Copy

-- 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])

Reference

MDX Operator Reference (MDX)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ