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

Setting up Date Specific Metrics

The time dimension in the Oracle BI repository for Oracle Business Analytics Warehouse is a standard or canonical time dimension that links to the important time role in each star schema.

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. Additional dates in a fact table that a metric could be queried by are known as Secondary dates. These are available to the end users inside a detailed presentation folder. The detailed presentation folder is typically called the Details folder.

In Table 36, 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 OracleBIAnalyticsApps.rpd with the Oracle BI Administration Tool.

   The OracleBIAnalyticsApps.rpd file is located in the \OracleBI\server\Repository folder.

2. Right-click on Oracle Business Analytics 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.