0 Replies Latest reply: Dec 13, 2012 7:38 AM by 979762 RSS

    Join Essbase and Relational datasource

    979762
      Hi all,

      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?


      Thanks for any suggestions

      BR
      Tom