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

Customizing Time Dimensions

The time dimension in the Siebel Business Analytics repository for Siebel Customer-Centric Enterprise Warehouse is a standard or canonical time dimension that links to the important time role in each star schema.

Secondary dates are shown to the end users by a detailed presentation folder. The detailed presentation folder is typically called the Details folder.

About the Date Specific Metrics

If a fact table contains a distinct set of metrics that needs to be reported by different dates, the metadata is organized so that each metric is reported by its causal date.

For example, if the Invoice fact table has three metrics called Invoice Amount, Fulfill Amount, and Paid Amount, then each of these metrics need to be reported by the corresponding date—Invoice Date, Fulfill Date, and Payment Date.

In Table 14, each of the metrics reflect the activity related to that event for the entire period, for example, Invoice Amount by Invoice Date, Fulfill Amount by Fulfill date, and Payment Amount by Payment Date.

To implement data specific 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 physical alias for the fact table.
3. Create Joins for the physical alias which are the similar to the base fact table.

   The Join to the date dimension is changed to use the date role in question.

4. Create a new logical table source in the logical fact table that maps the metrics for the physical fact alias.

   The grain of the fact table is the same as the base fact table.

   NOTE:  You need to map each metric to one logical table source at the Detail Level.