Value

Returns a value for the specified member or tuple.

Syntax

tuple[.Value]

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

Example 1

[Sales].Value 

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

[Sales] 

([Product].CurrentMember, [Sales]) 

Example 2

The following 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

This query returns the grid: