| Print Open PDF Version of Online Help

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

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