EnumValue

The MDX EnumValue function for Essbase returns the internal numeric value for a text value in a text list.

Syntax

EnumValue (enum_string)

Parameters

enum_string

Either textlistname.string_literal or textlistmembername.string_literal, where

• textlistname is the name of a text list defined on the outline

• textlistmembername is the name of a member that has an associated text list

• string_literal is the text value stored in the text list

Example

The following expression shows how EnumValue can be used to filter employees based on their title, which is stored as a text list in [Measures].[Title].

FILTER([Employee].Levels[0].Members, [Measures].[Title] = EnumValue([Job Titles]."Manager") )