Value

The MDX Value() function for Essbase returns a value for the specified member or tuple.

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.

Note:

The Value keyword is optional. The above expressions can also be entered as:

[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:

Table 4-138 Output Grid from MDX Example

(axis)	Sales
100-10	62824
300-10	46956
200-10	41537
200-20	38240
200-20	38240
300-30	36969
300-30	36969
400-10	35799
400-20	32670
100-20	30469
100-20	30469
200-30	17559
300-20	17480
400-30	15761
100-30	12841
200-40	11750