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

Setting Up Additional Dimension Tables for Oracle Business Analytics Warehouse

Oracle Business Analytics Warehouse is preconfigured to map dimension tables required for analysis. The physical layer in the Oracle BI repository provides several other dimensional table keys that can be used for certain specific analysis. If you need to set up any of the additional dimensions tables to the physical layer, perform the following procedure.

To set up additional dimension tables

1. Validate that the dimension table key is resolved appropriately for the data source that you are using.

   NOTE:  Dimension tables do not apply to every source system.

2. Open the OracleBIAnalyticsApps.rpd with the Oracle BI Administration Tool.
3. Add a dimension table alias in the physical layer.
4. Join the dimension table alias to the fact table alias using the appropriate keys.
5. Save and close the OracleBIAnalyticsApps.rpd file.