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.