| Print Open PDF Version of Online Help

##### Opportunity Product Revenue Historical Analytics Subject Area ### Availability 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 Multifact ### Dimensions This subject area has the following dimensions: Account Account Territory Campaign Date Opportunity Opportunity Product Revenue Owned By User Primary Contact Principal Partner Account (available only in Oracle CRM On Demand Partner Relationship Management Edition) Product Product Category Quota Territory ### Metrics 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/23/2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.