Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Pipeline History Analytic Subject Area

Availability

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

Business Purpose

The pipeline history subject area provides a monthly snapshot of all opportunities in Oracle CRM On Demand. Pipeline snapshots are taken daily during the nightly process, but the archiving process keeps only the latest pipeline snapshot for each month and purges the other snapshots. These pipeline snapshots are never deleted. During the full extract, transform and load (ETL) of data, these snapshots are backed up and fully restored. If companies change their fiscal calendar type, these historical snapshots will not be realigned with their new fiscal calendar definition. For companies with a custom fiscal calendar type, these historical snapshots can be reported only for the fiscal year definitions that are defined in Oracle CRM On Demand. Snapshots are taken only for opportunities that were closed in the last quarter. However, snapshots are taken for all open opportunities.

Relationship Type

Simple

Dimensions

This subject area has the following dimensions:

  • Account
  • Date
  • Opportunity
  • Owned By User
  • Pipeline Snapshot Date
  • Territory

Metrics

The complete list of metrics for this subject area is as follows:

  • Historical Pipeline Metrics
    • Revenue. This metric indicates the revenue from the opportunity.
    • Expected Revenue. This metric indicates the opportunity revenue multiplied by the probability of the opportunity.
    • Closed Revenue. This metric indicates the revenue of the closed/won opportunity. When the opportunity's status is Closed/Won, then the revenue and closed revenue have the same value.
    • Revenue (000). This metric indicates the revenue from the opportunity, in thousands.
    • Expected Revenue (000). This metric indicates the opportunity revenue multiplied by the probability of the opportunity, in thousands.
    • Closed Revenue (000). This metric indicates the revenue of the closed/won opportunity, in thousands. When the opportunity's status is Closed/Won, then the revenue and closed revenue have the same value.
    • Quarter Ago Opportunity Revenue. This metric indicates the value of the revenue from one quarter ago.
    • Quarter Ago Expected Revenue. This metric indicates the value of the expected revenue from one quarter ago.
    • Quarter Ago Closed Revenue. This metric indicates the value of the closed revenue from one quarter ago.
    • Quarter Ago Opportunity Revenue (000). This metric indicates the value of the revenue from one quarter ago, in thousands.
    • Quarter Ago Expected Revenue (000). This metric indicates the value of the expected revenue from one quarter ago, in thousands.
    • Quarter Ago Closed Revenue (000). This metric indicates the value of the closed revenue from one quarter ago, in thousands.
    • Territory

Usage Notes

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


Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.