This discussion is archived
0 Replies Latest reply: Dec 13, 2012 5:38 AM by 979762 RSS

Join Essbase and Relational datasource

979762 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points