Print      Open PDF Version of Online Help

Previous Topic

Next Topic

Opportunity Product Revenue History Analytic Subject Area


This subject area is available in all editions of Oracle CRM On Demand.

Business Purpose

This subject area allows you to analyze opportunity product revenues by account, account territory, partner, campaign, opportunity, opportunity product, owned by user, product, and product category. Because each recurring product-revenue record might have a different start date, this subject area is at the most granular level of detail and contains one row for each recurring product-revenue record within the opportunity. Given the high level of detail of this subject area, it provides the greatest flexibility to roll up data at any level of the supported dimensions. This subject area also contains the quota dimension and metrics, which allow you to report on both opportunity product revenue and quota metrics in the same report.

Relationship Type



This subject area has the following dimensions:

  • Account
  • Account Territory
  • Campaign
  • Date
  • Opportunity
  • Opportunity Product Revenue
  • Owned By User
  • Principal Partner Account (available only in Oracle CRM On Demand Partner Relationship Management Edition)
  • Product
  • Product Category
  • Quota
  • Territory


The complete list of metrics for this subject area is as follows:

  • Opportunity Product Revenues Metrics
    • Number (#) of Products
    • Average Number (Avg #) of Products
  • Quota Metrics
    • Quota Value

Usage Notes

The Account and Primary Contact dimensions include a Book hierarchy, which enables you to analyze metrics and related attributes at any level.

Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.