| Print Open PDF Version of Online Help

##### Opportunity Product Revenues Real-Time Reporting 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, campaign, opportunity, opportunity product, owned by user, product, and product category. Because each recurring product revenue record might have a different start date, the level of detail for this subject area is at the lowest level and contains one row for each recurring product revenue record within the opportunity. Given the level of detail for this subject area, it provides the utmost 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 both opportunity product revenue and quota metrics in the same report. ### Relationship Type Simple ### Dimensions This subject area has the following dimensions: Account Account Territory Campaign Opportunity Opportunity Product Revenue Owned By User Primary Contact Product Product Category Quota ### Metrics The complete list of metrics for this subject area is as follows: Opportunity Product Revenue Metrics Number (#) of Products Average (Avg) Number (#) 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. Reports made with this subject area include a summary revenue record row for each revenue record displayed in the report. If you do not want the summary revenue record rows included in the report, then either add the Product Name field to the report or use the Opportunity Historical Analytics Subject Area.

Published 5/23/2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.