I have imported a Essbase cube into OBIEE rpd using admin tool.
As we know that Measure's are stored as numeric value's in Essbase even if it's actual data is a text. So , i need to bring that text to show in reports. In a RDBMS table(HSP_TEXT_CELL_VALUE) , text is stored with its corresponding numeric value (as in Essbase measure). Somehow I have to perform a join between this table and Essbase measure's .
A federation technic is described in the below link :