How to Create BI Report on Employee Dimension of Opportunity Revenue Line?

(Doc ID 2390597.1)

Last updated on APRIL 24, 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

Report on Revenue Line Owner

Customer is using CRM Pipeline to report on Opportunity Pipeline.
Customer is only getting Employee dimension based on Opportunity Owner. They want to get Employee Dimension of Revenue Line Owner in the report.

They need to be able to report on a second Employee Dimension based on Revenue line Owner

Customer has two questions:

1. Is there a possibility to use / modify a standard subject area to report on Revenue line owner instead of opportunity owner ?
2. What is best practice to report on this employee dimension?

Example opportunity:

Owner = User1 - she is opportunity owner
Revenue line Owner: User2 - he is responsible for Revenue line1
Revenue line Owner: User3 - he is responsible for Revenue line2
 

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