Udostępnij za pośrednictwem

AND (MDX)

  • Artykuł

Performs a logical conjunction on two numeric expressions.

Składnia

Expression1 AND Expression2

Parametry

  • Expression1
    A valid Multidimensional Expressions (MDX) expression that returns a numeric value.

  • Expression2
    A valid MDX expression that returns a numeric value.

Wartość zwracana

A Boolean value that returns true if both parameters evaluate to true; otherwise, false.

Uwagi

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

Przykład

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

Zobacz także

Odwołanie

MDX Operator Reference (MDX)