Print      Open PDF Version of Online Help

Analytics > Designing an Analysis > Getting Started with Analytics > Selecting Subject Areas > Opportunity Product Revenues Real-Time Reporting Subject Area

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.