How to Create OBIEE Report Showing All Customers (With or Without Contacts) and Show All Contacts on a Customer?

(Doc ID 2381991.1)

Last updated on APRIL 03, 2018

Applies to:

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

Goal

On : 11.12.1.0.0 version, Analytics

Help with a analysis that was created

Customer created a report with "Sales - CRM Customer Overview" subject area , but not all contacts for a customer show on the report
Created report with "Sales - CRM Customers and Contacts Real Time" subject area is only showing customers which have contacts.


Customer requirement is to show all customers (with or without contacts) and show all contacts on a customer

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