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?
Articles Related
In the repository
In the logical join of the business model layer:
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