Contents

4 Customizing the Oracle Business Analytics Warehouse

• What Is Customization in Oracle BI Applications ?
  • About the Customization Process
  • Extending Mappings in Oracle Business Analytics Warehouse
  • Example of Extending the Oracle Business Analytics Warehouse
    • Example of Extracting Data from an Oracle EBS 11.5.10 Data Packaged Source into the ODI Staging Area
    • Example of Loading Data from the Staging Area into an Existing Target Table
    • Tips for Modifying the SQ_BCI_ Interface
    • Modifying Category 2 SCD Behavior
    • Adding a Dimension to an Existing Fact
      • Customizing Fact Datastores and Tasks
      • Additional Information About Customizing
      • Adding New Fact Tables to Oracle Business Analytics Warehouse
      • Creating Custom Dimension Datastore and Tasks
      • About Creating Custom Fact and Dimension Groups
        • Creating Custom Fact and Dimension Groups in ODI
        • Creating Custom Fact and Dimension Groups in Configuration Manager
          • Creating Custom Dimension Groups
          • Adding New Data as a Whole Row Into a Standard Dimension Table
          • Configuring Extracts
            • Extracting New Data Using an Existing Source Table
            • Setting Up the Delimiter for a Source File
            • How Dimension Keys are Looked Up and Resolved
            • Adding an Index to an Existing Fact or Dimension Table
            • Extending Oracle BI Applications with Custom Source Domains