OBIEE - Left outer join

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 : 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 
  • Bookmark "OBIEE - Left outer join" at del.icio.us
  • Bookmark "OBIEE - Left outer join" at Digg
  • Bookmark "OBIEE - Left outer join" at Ask
  • Bookmark "OBIEE - Left outer join" at Google
  • Bookmark "OBIEE - Left outer join" at StumbleUpon
  • Bookmark "OBIEE - Left outer join" at Technorati
  • Bookmark "OBIEE - Left outer join" at Live Bookmarks
  • Bookmark "OBIEE - Left outer join" at Yahoo! Myweb
  • Bookmark "OBIEE - Left outer join" at Facebook
  • Bookmark "OBIEE - Left outer join" at Yahoo! Bookmarks
  • Bookmark "OBIEE - Left outer join" at Twitter
  • Bookmark "OBIEE - Left outer join" at myAOL
 
dat/obiee/left_outer_join.txt · Last modified: 2010/05/24 14:33 by gerardnico