OBIEE - Join

Bi Server Architecture With Client

About

This article talk about the SQL joins in OBIEE.

You have two ways to define a join in OBIEE:

Special OBIEE join

Stitch join

OBIEE can perform internal join in its memory. This in-memory joins are called stitch join.

Multi-Database

A multi-database join (or cross-database) is defined as a table under one metadata database object that joins to a table under a different database object in the physical layer.

You need to specify multi-database joins to combine the data from different databases.

The joins can be between tables in any databases, regardless of the database type, and are performed within the Oracle BI Server (known as stitch join)

While the Oracle BI Server has several strategies for optimizing the performance of multi-database joins, multi-database joins will be significantly slower than joins between tables within the same database. It is recommended to avoid them whenever possible.





Discover More
Bi Server Architecture With Client
OBIEE - Physical Layer

The physical layer is the layer of the Logical Business Model where you define the physical data model of your data source. It contains information the physical data sources. The most common way to...
Obiee Logical Join Bmm
OBIEE - Full outer Join

To perform a , you have two ways : in the repository by using the fact vertical partitioning capabilities or with the Obiee logical sql To know what sort of join is a full outer join, follow this...
Obiee Foreign Key Complex Join
OBIEE - Joins definitions in the repository (complex, foreign, logical table source)

You have three way to define joins when you model your repository: You can define: a Complex join a Foreign key a logical join property: From 11g, joins in the Physical and Business Model...
Obiee Logical Join Bmm
OBIEE - Left outer join

How can we perform a join with the type left outer in OBIEE. To know what is a left outer join, follow this link : In the logical join of the business model layer: Example of left outer join...
Obiee Logical Join Bmm
OBIEE - Right outer join

How can we perform a join with the type right outer in OBIEE. To know what is a right outer join, follow this link : In the logical join of the business model layer:
Obiee Ceim
OBIEE - the Cross/Cartesian Join

To perform a cross join (often between the dimension), you have two ways : in the repository or with the Obiee logical sql To know what sort of join is is a cross join, follow this link : ...
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