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

Setting Up Additional Dimension Tables for Siebel Customer-Centric Enterprise Warehouse

Siebel Customer-Centric Enterprise Warehouse is preconfigured to map dimension tables required for analysis. The physical layer in the Siebel Business Analytics 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 (for example, SAP R/3) you are using.

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

2. Open the SiebelBusinessAnalytics.rpd with the Admin 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 SiebelBusinessAnalytics.rpd file.