Text or date measures can be queried in the same way as numerical measures, using Smart View, Grid API clients, Report Writer, and MDX. The corresponding cells are displayed with the appropriate text values or formatted date values.
The following Report Writer commands are designed to work with numeric data, and are not supported for text or date measures:
RESTRICT
TOP
BOTTOM
SORT* commands
CALCULATE COLUMN
CALCULATE ROW
The MDX function EnumValue and the calculation function @ENUMVALUE are designed specifically for getting the text value of text measures. These functions can be useful in MDX scripts, calc scripts, or formulas, when you need to do operations based on the text value of a member rather than its internally stored numeric value. See the Oracle Essbase Technical Reference