Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring the Siebel Business Analytics Repository for Siebel Customer-Centric Enterprise Warehouse >

About the Period Ago Keys for Siebel Customer-Centric Enterprise Warehouse

The Period Ago Key fields are used to set up the time series metrics like Year Ago, Quarter Ago, and so on. The Period Ago Key fields represent metrics for a prior period, for example, Quarter Ago Revenue, Year Ago Revenue, and so on. Siebel Customer-Centric Enterprise Warehouse is preconfigured with a set of fields in the W_DAY_D table. These fields are:

• MONTH_AGO_KEY
• QUARTER_AGO_KEY
• TRIMESTER_AGO_KEY
• WEEK_AGO_KEY
• YEAR_AGO_KEY

These fields are used in joins to Siebel Customer-Centric Enterprise Warehouse fact tables to achieve the period ago metrics. The surrogate keys in Siebel Customer-Centric Enterprise Warehouse fact tables uses are different to the surrogate keys that the Siebel Relationship Management Warehouse uses. The joins in Siebel Customer-Centric Enterprise Warehouse uses the Period Ago fields in the W_DAY_D table.