I'm new in OBIEE and I have problem how to create repository to solve requirment.
I would like to make model for Hyperion Planning which data source is essbase but some planning informations (text descritpions) are stored in relational table.
I have 2 datasources in my repository:
1. essbase (planning application) - measure dimension (accounts) is converted to flat measures
2. relational table (from planning aplication) including texts and its ID's
when i create analysis in OBIEE one of measure (Asset description) returns ID for relational source which include text value.
What should I do to join that 2 sources nad receive in analizys measures from essbase with text value from relational source?