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

Setting Up Additional Time Series Metrics for Siebel Customer-Centric Enterprise Warehouse

Siebel Business Analytics repository provides a framework to add Period Ago metrics. The repository for Siebel Customer-Centric Enterprise 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 SiebelBusinessAnalytics.rpd with the Admin Tool.
2. Right-click on Siebel Business Analytics Data 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 SiebelBusinessAnalytics.rpd file.