Print      Open PDF Version of Online Help

Analytics > Designing an Analysis > Getting Started with Analytics > Selecting Subject Areas > Custom Objects and Opportunities Real-Time Reporting Subject Area

Custom Objects and Opportunities Real-Time Reporting Subject Area

This topic covers the following reporting subject areas:

• Custom Object 1 and Opportunities
• Custom Object 2 and Opportunities
• Custom Object 3 and Opportunities

Availability

These subject areas are available in all editions of Oracle CRM On Demand.

Business Purpose

These subject areas allow you to analyze the many-to-many relationship between opportunities and Custom Objects 1, 2, and 3. The opportunities subject area is replicated and added with the Custom Objects 1, 2, and 3 dimensions. Often companies redesign Custom Objects 1, 2, and 3 and want to report on these redesigned objects with opportunities. Because this subject area represents the many-to-many relationship between opportunities and Custom Objects 1, 2, and 3, the opportunities that do not have an association with at least one instance of Custom Objects 1, 2, and 3 cannot be reported using these subject areas.

Relationship Type

Many-to-many

Dimensions

These subject areas have the following dimensions:

• Custom Object
• Account
• Campaign
• Close Date
• Date Opened
• Opportunity
• Owned By User
• Primary Contact
• Territory

Metrics

The complete list of metrics for these subject areas is as follows:

• Opportunity Metrics
  • Opportunity Custom Metrics
    • Indexed Currency
    • Average (Avg) Indexed Currency
    • Indexed Number
    • Average (Avg) Indexed Number
  • Revenue
  • Expected Revenue
  • Closed Revenue
  • Revenue (000)
  • Expected Revenue (000)
  • Closed Revenue (000)
  • Number (#) of Opportunities
  • Number (#) of Open Opportunities
  • Number (#) of Closed Opportunities
  • Number (#) of Wins
  • Average Number (Avg #) of Days in Stage

Usage Notes

The Account dimension includes a Book hierarchy, which enables you to analyze metrics and related attributes at any level.