How to include a LTS filter as part of an outer join (instead of the Where clause) in OBIEE RPD 11g

Question

We have and outer join between two tables - let's say TableA and TableB - where TableB currently have a filter in the Content definition in the BMM of the RPD. This filter is negating the outer join, which then behaves as a normal inner join. A SQL statement from this join looks like this:

SELECT * FROM TableA A
LEFT OUTER JOIN TableB B ON B.TableA_Wid = A.Row_Wid
WHERE B.Category = 'ASSESSMENT';

Is there a way to configure TableB, so the filter is part of the outer join instead? We would like a SQL statement from these tables to look like this:

SELECT * FROM TableA A
LEFT OUTER JOIN TableB B ON B.TableA_Wid = A.Row_Wid AND B.Category = 'ASSESSMENT';

Joel Acha · Answer

You only specify the join type (inner, left outer join, right outer join or full outer join) in the LTS and the actual join condition is defined in the physical layer.

[Deleted User] · Answer

The physical join condition must be in the physical layer - not in an LTS filter. That latter one will only ever add a WHERE clause and never change the join condition.