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

Setting Up Additional Time Series Metrics for Oracle Business Analytics Warehouse

The Oracle BI repository provides a framework to add Period Ago metrics. The repository for Oracle Business Analytics Warehouse is preconfigured with premapped period ago metrics, however you can map other metrics by using the following procedure.

To set up additional time series metrics

1. Open the OracleBIAnalyticsApps.rpd with the Oracle BI Administration Tool.
2. Right-click on Oracle Business Analytics Warehouse in the Physical layer, and create a new Period Ago physical alias table.
3. Create additional tables in the Physical Layer for each Period Ago alias required.

   For example, Quarter Ago, Year Ago, and so on.

   These aliases need to have the same joins as the base fact table, except for the date join, which you can change in the next step. Setting up this alias is easier to accomplish by copying the base table.

4. Change the join to the date dimension (W_DAY_D) to use the appropriate Period Ago Key.
5. Map the Period Ago metrics in the logical table using the new fact alias by creating a new logical table source under the fact table.
6. Set the content pane levels for the period ago logical table source, to specify the level of the source data.

   These settings are the same as the base fact table.

7. Save and close the OracleBIAnalyticsApps.rpd file.