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.
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.