Search This Blog

Showing posts with label Joins in OBIEE. Show all posts
Showing posts with label Joins in OBIEE. Show all posts

Friday, May 6, 2011

Physical Layer & Business Layer joins in OBIEE

In general different tables are joined with foreign key. Drag the FK link from Dimension table to Fact table.
it should be 1 to N join.

In Business layer use complex joins.

Always drag the link from Dimension to Fact