Syntax

tuple[.Value]

or

member[.Value]

Parameters

tuple

A tuple for which to return a value.

member

A member for which to return a value.

Notes

The VALUE keyword is optional. In Example 2, the value of Sales can be represented either as [Sales].VALUE or [Sales]. Any value expression (for example, the value expressions supplied to functions such as Filter, Order, or Sum) has an implicit Value function in it. The expression [Qtr1] <= 0.00 is a shortcut for [Qtr1].VALUE <= 0.00.

Example 1

[Sales].Value 

returns the value of the Sales measure.

([Product].CurrentMember, [Sales]).Value 

returns the value of the Sales measure for the current member of the Product dimension.

[Sales]

which is equivalent to [Sales].Value, and

([Product].CurrentMember, [Sales])

which is equivalent to ([Product].CurrentMember, [Sales]).VALUE.

Example 2

The following MDX query sorts level-0 members of the Product dimension by the value of Sales, in descending order:

SELECT
 {[Sales]}
ON COLUMNS,
  Order([Product].Levels(0).Members,
        [Sales].VALUE, BDESC)
ON ROWS
FROM Sample.Basic

The above query returns the following output: