OBIEE - Outer Join

Obi Edition

About

Outer Joins in OBIEE:

In the Business Model

Outer joins in logical table sources are always included in a query, even if the table source is not used. If possible, create one logical table source without the outer join and another with the outer join. Order the logical table source with the outer join after the non-outer join so that it will be used only when necessary.





Discover More
Bi Server Architecture With Client
OBIEE 10G/11G - Driving Table

You can specify a Driving table parameter in a complex join. Driving tables are for use in optimizing the manner in which the Oracle BI Server processes cross-database joins when one table is very small...



Share this page:
Follow us:
Task Runner