|
Analytics > Designing an Analysis > Getting Started with Analytics > Selecting Subject Areas > Pipeline Historical Analytics Subject Area
Pipeline Historical Analytics 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 of opportunities without a close date or of opportunities in which the close date is in the current quarter or in a future quarter.
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.
|
