About

You have three way to define joins when you model your repository:

You can define:

1. a Complex join
2. a Foreign key
3. a logical join property: OBIEE 10G/11G - How to model a bridge table (Many-to-Many relationship) with the joins property of a Logical Table ?

From 11g, joins in the Physical and Business Model Diagrams are now represented by a line with an arrow at the “one” end of the join, rather than the line with crow’s feet at the “many” end of the join that was used in previous releases. When creating joins in the Physical and Business Model Diagrams, you now select the “many” end of the join first, and then select the “one” end of the join. In previous releases, joins in the diagrams were created by selecting the “one” end of the join first.

Articles Related