Print      Open PDF Version of Online Help

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

Custom Objects and Service Requests Real-Time Reporting Subject Area

This topic covers the following reporting subject areas:

• Custom Object 1 and Service Requests
• Custom Object 2 and Service Requests
• Custom Object 3 and Service Requests

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 service requests and Custom Objects 1, 2, and 3. The service requests 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 service requests. Because this subject area represents the many-to-many relationship between opportunities and Custom Objects 1, 2, and 3, the service requests 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
• Contact
• Custom Object
• Date Closed
• Date Opened
• Owned By User
• Service Request

Metrics

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

• Service Request Metrics
  • Service Request Custom Metrics
    • Indexed Currency
    • Average (Avg) Indexed Currency
    • Indexed Number
    • Average (Avg) Indexed Number
  • Number (#) of Service Requests (SRs)
  • Number (#) of Open SRs
  • Number (#) of Closed SRs
  • Number (#) of Pending SRs
  • Number (#) of Cancelled SRs
  • Average (Avg) Open SR Age
  • Average (Avg) Days to Close SR

Usage Notes

The Account, Contact, and Service Request dimensions include a Book hierarchy, which enables you to analyze metrics and related attributes at any level.