The following MDX functions can be useful when applying format strings to a measure. Format strings are applied as MDX expressions, in both aggregate and block storage databases.
EnumText, returns the text list label associated with the internal numeric value.
EnumValue, returns the internal numeric value for a text list label.
CellValue, returns the internal numeric value of the current cell.
NumToStr, converts a value to a decimal string.
The @ENUMVALUE calculation function can be useful when writing calculation scripts for a block storage database that has text measures or format strings. This function returns the text list label associated with the internal numeric value.
The MaxL alter session set dml_output statement has a clause set formatted_value on | off. By default, formatted values are displayed in queries, but this statement can be used to turn off the display of formatted values.
The OUTFORMATTEDVALUES Report Writer command returns formatted cell values in a report.
For information about these functions, commands, and statements, see the Oracle Essbase Technical Reference.