Oracle® Business Intelligence Applications Installation and Configuration Guide > Customizing the Oracle Business Analytics Warehouse > Type II Customizations: Adding Additional Tables >

Adding a New Dimension Table for a New Fact Table in the Oracle Business Analytics Warehouse


The steps for creating a new dimension table are similar to the steps for incremental change capture.

To add a new dimension table for a new fact table

  1. In the new custom fact loading mapping (SIL), use lookups for getting foreign keys to the new dimension.
  2. Use existing maps as examples.
Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.