Custom Subject Area: Need A Left Join Of Sales Account To Order History (Doc ID 1912223.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.7.0.0 and later
Oracle Fusion Sales - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Goal

We have a custom subject area called "Order History 7-12-2013".
This includes Sales Account, which is a parent to a custom object: Order History.
In this CSA in OBIEE, if we only use fields from Sales Account, we can extract ALL customers in an analysis.
However, once we pull in any records from "Order History", it appears to default to an inner join, and we lose any customers who do not have a record in Order History.

How can we update this CSA so that we specify whether we want an inner join or a left join?
In many cases, we want to include ALL customers from Sales Account, even if there are no child records in Order History.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms