Search This Blog

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

No comments:

Post a Comment