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
- (Negative)	Returns the negative value of a numeric expression.
+ (Positive)	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.

See Also

Reference

MDX Operator Reference (MDX)

Concepts

Operators (MDX Syntax)

Help and Information

Getting SQL Server 2005 Assistance