Left OUter join

building semantic layer
1

Hi All,

I would like to use the left out join condition in my universe. Do i need to write any code within the universe?

Thanks
Muvva

rmuvva (BOB member since 2010-03-30)

2

You want left outer join between two tables, right? Just double click on the join and you can select outer join check box on whichever side you want.

Prashant Purohit :india: (BOB member since 2009-02-18)

3

Occasionally, the checkbox is not enough to give you true outer join, then you have to modify the parameter of OUTERJOINS_GENERATION to USUAL.

Hope this helps.

substring :us: (BOB member since 2004-01-16)

4

Hi,

I am using XI R3.1 version and unable able to find the outer join modification parameter in universe.

Does any one advise where we can do this.

Thanks.

Eswar (BOB member since 2006-05-02)

5

Just out of curiosity, I tried to make it as No, but how to check whether it is stopping me from putting outer join or not ? And what USUAL will do? Can you please help me in understanding this parameter?

aniketp :uk: (BOB member since 2007-10-05)

6

What database do you use?
Depending on your database / middleware you might have to adjust to according PRM file.

Czapie :de: (BOB member since 2009-04-15)

7

That parameter forces BusinessObjects to generate the SQL with the actual “outer join” or “inner join” in the syntax. If you just do the “checkbox” thing, you will still get the “where” keyword and the outer joins will be represented with the (+) signs if you are using Oracle.

substring :us: (BOB member since 2004-01-16)