Outer Option in Join is disabled/grayed out how to enable it

building semantic layer
1

Friends I am trying to use outer join, but its has been disabled or grayed out. Do i need to change any settings to enable it and use it?
Thanks so much.

toblerone65 (BOB member since 2009-08-21)

2

It sounds like you are using incorrect middleware for your DBMS - avoid using the generic connector where possible.

3

If you have a complex join, the outer join options will be grayed out as well. If this is the case, remove everything from the join SQL except on set up Table1.Column = Table2.Column. You should be able to set the outer join and then add the rest of you complex join back in.

4

I think you could also just add the outer join manually in the expression as well if you have a compound join, i.e. If you are in Oracle you could just add (+) at the end of the table/columns that are to have the outer join on - Table1.Column(+) = Table2.Column. Think it is an * in SQL server but don’t quote me on that one, the only other option is as mentioned earlier, strip the join down, add the outer join and rebuild the compound.

Rolls.

dunbarr (BOB member since 2009-09-17)

5

I am having the same issues.
I am using Sybase DB with ODBC connection.
Is this a problem with my middle ware? Is there a way I can use outer joins, for now they are all grayed out.

Thanks,
Eran.

eransh10 (BOB member since 2008-09-09)