Returns a value for the specified member or tuple.
tuple[.Value]
OR
member[.Value]
| tuple | A tuple for which to return a value. |
| member | A member for which to return a value. |
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.
[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
([Product].CurrentMember, [Sales])
which is equivalent to ([Product].CurrentMember, [Sales]).VALUE
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:
| 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 |
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |