Opportunity and Competitor Historical Analytics Subject AreaAvailabilityThis subject area is available in all editions of Oracle CRM On Demand. Business PurposeThis subject area allows you to analyze the many-to-many relationship between opportunities and competitor accounts. This subject area is almost identical to the opportunity subject areas. The only difference is that it includes the competitor account dimension, which has a many-to-many relationship with the opportunity record type. This subject area allows you to create reports that show all the competitors for an opportunity. Because this subject area represents the many-to-many relationship between opportunities and competitor accounts, opportunities that do not have an association with at least one competitor account cannot be reported using this subject area. The attributes that define the competitor account relationship that are available for reporting include the following:
Relationship TypeMany-to-many DimensionsThis subject area has the following dimensions:
MetricsThe complete list of metrics for this subject area is as follows:
Usage NotesThe Account and Primary Contact dimensions include a Book hierarchy, which enables you to analyze metrics and related attributes at any level. Relationship Contact DimensionOpportunities can be linked to an opportunity as competitors. Any opportunities that are linked to an opportunity as competitors are listed in the Opportunity Competitors related information section of the Opportunity Detail page. The relationship between two opportunities that are linked in this way can also have a primary contact that is different from the primary contacts on the linked opportunities. To extract information about the primary contact for the relationship between the opportunity and the competitor, select the columns from the Relationship Contact dimension. To extract information about the primary contact for the opportunity, select the columns from the Primary Contact folder under the Opportunity dimension. To extract information about the primary contact for a competitor, select the columns from the Primary Contact folder under the Opportunity Competitor dimension. |
Published 6/21/2021 | Copyright © 2005, 2021, Oracle and/or its affiliates. Legal Notices. |