by senthil
5. October 2009 12:33
In addition to associating numeric values to measures, in System 11, Text and Date type can be associated. Typed measures enhance analytical capabilities of Essbase.
Here is how to use the "Text" typed measure in Essbase outline.
1. First enable the "Typed Measures" option in Outline properties.

2. Add a Outline member which is used to associate the text value. In this example it is called "sometext". I wanted to associate a color (Red, Green, Blue) to this member. Since it is text type, I made consolidation sign as non-aggregation symbol (^).

3. Even though you can associate or lock and send Text values for this new member "sometext", you must pre-define the Texts and values. I guess, Essbase indirectly stores the numeric values ultimately. So create a list of allowed Text members and values.

4. Next you can Lock and Send or associate a Text (must be pre-defined in the list).
