Print      Open PDF Version of Online Help

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

Custom Objects and Accounts Real-Time Reporting Subject Area

This topic covers the following reporting subject areas:

• Custom Object 1 and Accounts
• Custom Object 2 and Accounts
• Custom Object 3 and Accounts

Availability

This subject area is available in all editions of Oracle CRM On Demand.

Business Purpose

These subject areas allow you to analyze the many-to-many relationship between accounts and Custom Objects 1, 2, and 3. The account 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 accounts. Because this subject area represents the many-to-many relationship between accounts and Custom Objects 1, 2, and 3, the accounts 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:

• Account
• Campaign
• Custom Object
• Date Created
• Owned By User
• Territory

Metrics

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

• Account Metrics
  • Account Custom Metrics
    • Indexed Currency
    • Average (Avg) Indexed Currency
    • Indexed Number
    • Average (Avg) Indexed Number
  • Revenue
  • Revenue (000)
  • Average (Avg) Revenue
  • Closed Revenue
  • Closed Revenue (000)
  • Average (Avg) Closed Revenue
  • Average (Avg) Days to Close Opportunity (Definition: The number of days to close an opportunity divided by the number of wins.)
  • Number (#) of Accounts
  • Number (#) of Accounts with Opportunities
  • Number (#) of Contacts
  • Number (#) of Opportunities
  • Number (#) of Wins
  • Number (#) of Service Requests (SRs)
  • Number (#) of Cancelled SRs
  • Number (#) of Closed SRs
  • Number (#) of Open SRs
  • Number (#) of Pending SRs
  • Average (Avg) Open SR Age
  • Average (Avg) Days to Close SR

Usage Notes

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