This topic has not yet been rated - Rate this topic

OR (MDX)

Performs a logical disjunction on two numeric expressions.

Copy


          

Expression1 OR 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 either or both arguments evaluate to true; otherwise, false.

Remarks

The OR operator treats both arguments as Boolean values (zero, 0, as false; otherwise, true) before the operator performs the logical disjunction. The following table illustrates how the OR operator performs the logical disjunction.

Expression1	Expression2	Return Value
true	true	true
true	false	true
false	true	true
false	false	false

Example

The following query contains a calculated measure that returns the string “MARRIED OR MALE” if the current member on the Gender hierarchy of the Customer dimension is Male or the current member on the Marital Status hierarchy of the Customer dimension is Married; otherwise it returns the string “UNMARRIED OR FEMALE”.

Copy

WITH
MEMBER MEASURES.ORDEMO AS
IIF(
([Customer].[Gender].CURRENTMEMBER IS [Customer].[Gender].&[M])
OR
([Customer].[Marital Status].CURRENTMEMBER IS [Customer].[Marital Status].&[M]),
"MARRIED OR MALE",
"UNMARRIED OR FEMALE")
SELECT [Customer].[Gender].[Gender].MEMBERS ON 0,
[Customer].[Marital Status].[Marital Status].MEMBERS ON 1
FROM [Adventure Works]
WHERE(MEASURES.ORDEMO)

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