Custom Subject Area: Need A Left Join Of Sales Account To Order History
Last updated on MARCH 08, 2017
Applies to:Oracle Fusion Sales Cloud Service - Version 126.96.36.199.0 and later
Oracle Fusion Sales - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
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.
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