Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

What's New in This Release

• Notable Features in Oracle BI Applications Documented in This Guide

1 Customizing the Oracle Business Analytics Warehouse

• 1.1 Overview of Customization in Oracle Business Intelligence Applications
  • 1.1.1 What is Customization in Oracle Business Intelligence Applications?
  • 1.1.2 About the Customization Process
  • 1.1.3 About the Impact of Patch Installation on Customizations
• 1.2 Category 1 Customizations: Adding Columns to Existing Fact or Dimension Tables
  • 1.2.1 About Extending Mappings
  • 1.2.2 Typical Steps to Extend Mappings in the Oracle Business Analytics Warehouse
  • 1.2.3 Other Types of Customizations Requiring Special Handling
    • 1.2.3.1 How to Modify Category 2 SCD Behavior
    • 1.2.3.2 How to Add A Dimension to an Existing Fact
    • 1.2.3.3 How to Add a DATE_WID column to a Fact
• 1.3 Category 2 Customizations: Adding Additional Tables
  • 1.3.1 About Creating New Tables
    • 1.3.1.1 About the Main Required Columns
  • 1.3.2 About the DATASOURCE_NUM_ID Column
  • 1.3.3 Additional Information About Customizing
    • 1.3.3.1 About the Update Strategy
    • 1.3.3.2 About Indices and Naming Conventions
  • 1.3.5 Adding a New Fact Table to the Oracle Business Analytics Warehouse
• 1.4 Category 3 Customizations: Adding New Data as a Whole Row into a Standard Dimension Table
  • 1.4.1 How to Add New Data as a Whole Row Into a Standard Dimension Table
  • 1.4.2 Configuring Extracts
    • 1.4.2.1 Extracting Additional Data
    • 1.4.2.2 Setting Up the Delimiter for a Source File
  • 1.4.3 Configuring Loads
    • 1.4.3.1 About Primary Extract and Delete Mappings Process
    • 1.4.3.2 About Working with Primary Extract and Delete Mappings
• 1.5 Customizing Stored Lookups and Adding Indexes
  • 1.5.1 About Stored Lookups
    • 1.5.1.1 About Resolving Dimension Keys
  • 1.5.2 How to add an index to an existing fact or dimension table

2 About Multi-Language Support

• 2.1 Introduction to Multi-Language Support
• 2.2 About Pseudo-Translations
• 2.3 About Oracle BI Applications Domains
• 2.4 About Dimension Translation Tables

3 Localizing Oracle Business Intelligence Deployments

• 3.1 Process of Maintaining Translation Tables for Oracle BI EE
  • 3.1.1 Upgrading Oracle Business Intelligence Seed Data for Non-English Locales
    • 3.1.1.1 Verify the Translation Table (W_LOCALIZED_STRING_G) and Corresponding Indexes
    • 3.1.1.2 Importing Locale Seed Data Into The Translation Table (W_LOCALIZED_STRING_G)
  • 3.1.2 Externalizing Customer Metadata Strings
  • 3.1.3 Adding Custom Translations to the W_LOCALIZED_STRING_G Table
    • 3.1.3.1 Adding String Translations for Analytics Metadata
• 3.2 About Translating Presentation Services Strings
• 3.3 Changing the Default Currency in Analytics Applications

4 Oracle Business Analytics Warehouse Naming Conventions

• 4.1 Naming Conventions for Oracle Business Analytics Warehouse Tables
• 4.2 Table Types for Oracle Business Analytics Warehouse
  • 4.2.1 Aggregate Tables in Oracle Business Analytics Warehouse
  • 4.2.2 Dimension Class Tables in Oracle Business Analytics Warehouse
  • 4.2.3 Dimension Tables in Oracle Business Analytics Warehouse
  • 4.2.4 Dimension Tables With Business Role-Based Flags
  • 4.2.5 Fact Tables in Oracle Business Analytics Warehouse
  • 4.2.6 Helper Tables in Oracle Business Analytics Warehouse
  • 4.2.7 Hierarchy Tables in Oracle Business Analytics Warehouse
  • 4.2.8 Mini-Dimension Tables in Oracle Business Analytics Warehouse
  • 4.2.9 Staging Tables in Oracle Business Analytics Warehouse
  • 4.2.10 Translation Tables in Oracle Business Analytics Warehouse
• 4.3 Internal Tables in Oracle Business Analytics Warehouse
• 4.4 Standard Column Prefixes in Oracle Business Analytics Warehouse
• 4.5 Standard Column Suffixes in Oracle Business Analytics Warehouse
• 4.6 System Columns in Oracle Business Analytics Warehouse Tables
• 4.7 Multi-Currency Support for System Columns
• 4.8 Oracle Business Analytics Warehouse Primary Data Values
• 4.9 About Multi-Language Support in the Oracle Business Analytics Warehouse
• 4.10 Oracle Business Analytics Warehouse Currency Preferences

5 Administering Oracle GoldenGate and Source Dependent Schemas

• 5.1 Introduction
• 5.2 Source Dependent Schema Architecture
• 5.3 Setting Up Oracle GoldenGate and Source Dependent Schemas
• 5.4 Tasks for Setting Up Oracle GoldenGate and the Source Dependent Schema
  • 5.4.1 Setup Step: Configure Source and Target Database
  • 5.4.2 Setup Step: Install Oracle GoldenGate on Source and Target Systems
  • 5.4.3 Setup Step: Configure BI Applications Configuration Manager and Oracle Data Integrator to Support the Source Dependent Schema
  • 5.4.4 Setup Step: Generate, Deploy, and Populate the Source Dependent Schema Tables on Target Database
  • 5.4.5 Setup Step: Generate and Deploy Oracle GoldenGate Parameter Files to Source and Target Machines
    • 5.4.5.1 Generate Oracle GoldenGate Parameter Files
    • 5.4.5.2 Configure the Source System
    • 5.4.5.3 Configure the Target System
  • 5.4.6 Setup Step: Start Oracle GoldenGate on Source and Target Machines

Index