This topic has not yet been rated - Rate this topic

- (Negative) (MDX)

SQL Server 2008

Performs a unary operation that returns the negative value of a numeric expression.

-Numeric_Expression

Parameters

Numeric_Expression: A valid Multidimensional Expressions (MDX) expression that returns a numeric value.

Return Value

A negative value that has the data type of the specified parameter.

Examples

The following example demonstrates the use of this operator.

-- This member creates a negative version of the
-- Reseller Freight Cost.
WITH MEMBER 
   Measures.[Resell Cost as Negative] 
   AS -Measures.[Reseller Freight Cost]
SELECT 
   [Date].[Calendar Month of Year].Children ON COLUMNS,
   [Product].[Product Categories].Children ON ROWS
FROM
    [Adventure Works]
WHERE
    {[Measures].[Resell Cost as Negative]}

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 Additions

ADD