My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.