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 18.104.22.168.0 and later
Oracle Fusion Sales - Version 22.214.171.124.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|