OBIEE - Left outer join

Bi Server Architecture With Client

About

How can we perform a join with the type left outer in OBIEE.

To know what is a left outer join, follow this link : What is a SQL Left (Outer) Join?

In the repository

In the logical join of the business model layer:

Obiee Logical Join Bmm

With the Logical Sql

Example of left outer join in logical sql

 SELECT A.saw_0, B.saw_0  FROM 
(SELECT Calendar."Calendar Year" saw_0 FROM SH WHERE Calendar."Calendar Year" IN (1999, 2000, 2001) )  A LEFT OUTER JOIN
(SELECT Calendar."Calendar Year" saw_0 FROM SH WHERE Calendar."Calendar Year" IN (2000, 2001) )  B ON A.saw_0 = B.saw_0 





Discover More
Obiee Ceim
OBIEE - Logical Sql

The logical SQL is the SQL that understand BI Server. It's a full Ansi 92 SQL (including subqueries and derived tables), plus special functions (SQL extensions) like AGO, TODATE, EVALUATE, and others....
Obi Edition
OBIEE - Outer Join

Outer Joins in OBIEE: 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...



Share this page:
Follow us:
Task Runner