| Print Open PDF Version of Online Help

##### 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 analyse 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 analyse metrics and related attributes at any level.

Published August 2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.