Unary Operators
In Multidimensional Expressions (MDX), unary operators perform an operation on a single operand, such as returning the negative or positive value of a numeric expression.
MDX supports the unary operators listed in the following table.
| Operator | Description |
|---|---|
Returns the negative value of a numeric expression. |
|
Returns the positive value of a numeric expression. |
The following example demonstrates the use of a unary operator to return the negative value of a measure:
WITH
MEMBER [Measures].[NegDiscountAmount] AS
-[Measures].[Discount Amount]
SELECT
[Measures].[NegDiscountAmount] on COLUMNS,
NON EMPTY [Product].[Product].MEMBERS ON Rows
FROM [Adventure Works]
WHERE [Product].[Category].[Bikes]
In addition, MDX uses special unary operators to determine the aggregation operation performed by the RollupChildren function.