Essbase @ENUMVALUE

Returns the internal numeric value for a text value in a text list.

Syntax

@ENUMVALUE (enum_string)
Parameter Description
enum_string String of the format text_list_name.char_string_literal, where:

  • text_list_name is the name
    of a text list, or of a member that is associated with a text list.
  • char_string_literal is
    one of the text values represented in the text list.

Example

The following example is based on a variation of ASOSamp.Sample. Assume
there is a text list named CustSatRatings, in which text values are mapped
to numeric IDs as follows: Good=1, Average=2, Poor=3.

@ENUMVALUE(CustSatRatings, "Good");

returns 1.