EnumText

The MDX EnumText function for Essbase returns the text value corresponding to a numeric value in a text list.

Syntax

EnumText (textlistname, numeric_value_expression )

Parameters

textlistname

Name of a text list defined on the outline.

numeric_value_expression

Numeric value expression (see MDX Grammar Rules).

Example

EnumText(CSRatings, 1)

returns “Excellent” if there is a text list named CSRatings containing the text “Excellent” mapped to ID 1. This example returns an empty string if there is no text associated with the given numeric ID.