OR (DMX)
Applies to: SQL Server Analysis Services
A logical operator that performs a logical disjunction on two numeric expressions.
Syntax
Expression1 OR Expression2
Parameters
Expression1
A valid Data Mining Extensions (DMX) expression that returns a numeric value.
Expression2
A valid DMX expression that returns a numeric value.
Return Value
A Boolean value that returns TRUE if either argument or both arguments evaluate to TRUE; otherwise FALSE.
Remarks
Both arguments are treated as Boolean values (0 as FALSE; otherwise TRUE) before the operator performs the logical disjunction. If either argument or both arguments evaluate to TRUE, the operator returns TRUE. If Expression1 evaluates to TRUE and Expression2 evaluates to FALSE, the operator returns TRUE.
The following table illustrates how the logical disjunction is performed.
If Expression1 is | If Expression2 is | Return value is |
---|---|---|
TRUE | TRUE | TRUE |
TRUE | FALSE | TRUE |
FALSE | TRUE | TRUE |
FALSE | FALSE | FALSE |
See Also
Data Mining Extensions (DMX) Operator Reference
Logical Operators (DMX)
Operators (DMX)
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om