This content has been marked as final. Show 4 replies
Answered by Steve Muench
Here is the email response I got from Steve.
There is no way in ADF to mark a view link as a left-outer join type.
For your specific requirement, all need to be done is add a custom property on VL:
Property name: BI_JOINTYPE with either of these values.
LEFTOUTER | RIGHTOUTER | FULLOUTER | INNER
Edited by: Eshwar Mekala on Feb 8, 2010 1:58 PM
Edited by: Eshwar Mekala on Feb 8, 2010 2:03 PM
Edited by: Eshwar Mekala on Feb 8, 2010 2:06 PM
How do you add a property on a VL? Can you please elaborate on the solution.
To add a custom property on a view link, open the link in the editor and scroll down in the General tab to custom properties. Click the green plus to add the property. This property is apparently an implicit property for view links.
Hope that helps,
We had a view link containing outer join syntax but it broke when we attempted to change the linked view to use ANSI joins because you can't combine the Oracle(+) syntax with ANSI "OUTER JOIN" join syntax. I'm guessing we can't use an outer join view link with a view configured to use ANSI joins. Is that the case?