OBIEE - Joins definitions in the repository (complex, foreign, logical table source)

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

Table of Contents

1 - About

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

You can define:

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.

Advertising