Introducing Outer Join Feature in OAC Data Modeler

Apurva Tripathi

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

HSBC

Description (Required):

Currently, there is no outer join facility available in Data Modeler. Two tables [Fact and Dimension] can joined only via inner join and hence yield only the matching records, If for a row in one table, there is no corresponding row in another, we miss that row completely in the report/Visualization.

Use Case and Business Need (Required):

Data gets missed when there is just an inner join between two tables. In order to fetch complete data we do need the outer join facility between two tables in a subject area.

Ex Use Case: 

An Inner join between Invoice Detail and Invoice Payment will not yield unpaid invoices

An Inner join between Invoice Detail and Supplier Table - yields only those invoices in the report which do have a supplier and misses the one with no Supplier details available.

And, similar scenarios.

Enhancement Request / Service Request: SR 3-27665392311