OBIEE - How to define a One to Many Relationship

1 - About

How to model a One to Many Relationship in OBIEE ?

3 - Steps

You must in the logical business model from OBIEE designed a Star and/or a snowflake schemas. OBIEE is designed in this way.

To create a one-to-many relationships in the Business Model layer :

  • Select the tables that you want to link
  • Right click / Business Model Diagram / Selected table only. The logical table diagram windows appear.
  • Clik on the new complex join icon

  • select the dimension table and then the fact table. (In case of link between two dimensions in a snowflake schema, you can select the dimensional table of the highest level then the dimensional table with the lowest level)
  • The logical join appear and you can set :

  • Bookmark "OBIEE - How to define a One to Many Relationship" at del.icio.us
  • Bookmark "OBIEE - How to define a One to Many Relationship" at Digg
  • Bookmark "OBIEE - How to define a One to Many Relationship" at Ask
  • Bookmark "OBIEE - How to define a One to Many Relationship" at Google
  • Bookmark "OBIEE - How to define a One to Many Relationship" at StumbleUpon
  • Bookmark "OBIEE - How to define a One to Many Relationship" at Technorati
  • Bookmark "OBIEE - How to define a One to Many Relationship" at Live Bookmarks
  • Bookmark "OBIEE - How to define a One to Many Relationship" at Yahoo! Myweb
  • Bookmark "OBIEE - How to define a One to Many Relationship" at Facebook
  • Bookmark "OBIEE - How to define a One to Many Relationship" at Yahoo! Bookmarks
  • Bookmark "OBIEE - How to define a One to Many Relationship" at Twitter
  • Bookmark "OBIEE - How to define a One to Many Relationship" at myAOL
dat/obiee/obis/obiee_many_to_one.txt ยท Last modified: 2017/03/30 14:01 by 66.249.69.140