RealValue

The MDX RealValue function for Essbase returns a value for the specified member or tuple without the inherited attribute dimension context.

Syntax

tuple[.RealValue]

member[.RealValue]

Parameters

tuple

A tuple for which to return a real value

member

A member for which to return a real value

Example

The following query sorts level-0 members of the Product dimension by the real value of Sales without the attribute dimension (Ounces_12) context, in descending order, and returns their sales for Ounces_12.

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