Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring the Oracle BI Repository for Oracle Business Analytics Warehouse >

About the Period Ago Keys for Oracle Business Analytics 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. Oracle Business Analytics Warehouse is preconfigured with a set of fields in the W_DAY_D table. These fields are:

• MONTH_AGO_KEY
• QUARTER_AGO_WID
• TRIMESTER_AGO_WID
• WEEK_AGO_WID
• YEAR_AGO_WID

These fields are used in joins to Oracle Business Analytics Warehouse fact tables to achieve the period ago metrics. The surrogate keys in Oracle Business Analytics Warehouse fact tables uses are different to the surrogate keys that the Oracle Business Analytics Warehouse uses. The joins in Oracle Business Analytics Warehouse uses the Period Ago fields in the W_DAY_D table.