|
Reports > Getting Started with Answers (Custom Reports) > About Subject Areas in Reports > Deal Registration Product Revenue History Analytic Subject Area
Deal Registration Product Revenue History Analytic Subject Area
Availability
This subject area is available in all editions of Oracle CRM On Demand.
Business Purpose
The Deal Registration Product Revenue History subject area helps you identify trends and tendencies around your deal registration line items. It enables you to create basic queries involving Deal Registration Product Revenue metrics using core dimension attributes. It can help you answer questions such as:
- What is the maximum revenue expected from a single product on a single deal registration?
- Considering only open deal registrations, what is the average revenue for each deal registration (as calculated from revenue records)?
- How many unique products are referred to on all deal registrations (irrespective of the approval status)?
- What are the top products for all open deal registrations: by total quantity, by total revenue, by occurrence, by average quantity for each deal registration, or by average revenue for each deal registration?
- List all open deal registrations that have at least one product revenue line item with either zero or null quantity or zero or null price.
- What were the top products a quarter ago: by quantity, by revenue, by occurrence, by average quantity per deal registration, or by average revenue for each deal registration?
Relationship Type
One-to-many
Optimized Custom Fields
This subject area has custom fields that are optimized to reduce the query time when they are used in filters. Optimized custom fields are in folders where the name ends with Optimized Custom Fields or Optimized Custom Metrics, such as Account Optimized Custom Fields and Opportunity Optimized Custom Metrics. Numeric custom fields, such as those with a type of CUR, INT, or NUM, are available as metrics in the optimized custom metrics folder, if the record type is the driving object in a specific subject area. For example, the Account record type is the driving object in the Account History subject area.
The following record types have optimized custom fields and metrics coverage in Oracle CRM On Demand Answers and one or more of these record types might be present as dimensions or facts in this subject area:
Record Type
|
Oracle CRM On Demand Answers Coverage
|
Account
|
All optimized fields
|
Activity
|
All optimized fields
|
Assessment
|
All optimized fields
|
Campaign
|
All optimized fields
|
Contact
|
All optimized fields
|
Custom Objects 1-40
|
All optimized fields in CO1, CO2, CO3, CO4, CO5, and CO9 only
|
Lead
|
All optimized fields
|
Opportunity
|
All optimized fields
|
Opportunity Team
|
First five optimized fields of each type
|
Product
|
All optimized fields
|
Revenue
|
All optimized fields
|
Service Request
|
All optimized fields
|
Dimensions
This subject area has the following dimensions:
- Associated Contact
- Associated Customer
- Associated Opportunity
- Date (based on the Close Date of the Deal Registration)
- Deal Registration
- Deal Registration Product Revenue
- Principal Partner Account (available only in Oracle CRM On Demand Partner Relationship Management Edition)
- Product
- Product Category
Metrics
The subject area has the following metrics:
- Deal Registration Product Revenue Metrics
- Deal Registration Product Revenue Custom Metrics:
- Avg Indexed Currency
- Avg Indexed Number
- Indexed Currency
- Indexed Number
- Number (#) of Products
- Number (#) of Products on Deal Registrations without Opportunities
- Number (#) of Products on Open Deal Registrations
- Average Number (Avg #) of Products on Deal Registrations without Opportunities
- Average Number (Avg #) of Products on Open Deal Registrations
- Avg Price
- Avg Quantity
- Avg Quarter Ago Total Revenue
- Avg Revenue
- Avg Total Quantity on Deal Registrations without Opportunities
- Avg Total Quantity on Open Deal Registrations
- Avg Total Revenue on Deal Registrations without Opportunities
- Avg Total Revenue on Open Deal Registrations
- Average Number (Avg #) of Products (Per Deal Registration)
- Quarter Ago Total Revenue
- Quarter Ago Total Revenue (000)
- Total Quantity
- Total Quantity (000)
- Total Quantity on Deal Registrations without Opportunities
- Total Quantity on Open Deal Registrations
- Total Revenue
- Total Revenue (000)
- Total Revenue on Deal Registrations without Opportunities
- Total Revenue on Deal Registrations without Opportunities (000)
- Total Revenue on Open Deal Registrations
- Total Revenue on Open Deal Registrations (000)
- Principal Partner Account
Usage Notes
None
|
