Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

What's New for Oracle Business Intelligence Applications Administration

• New Features for Oracle BI Applications System Administrators

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.4 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
• 1.6 Trimming the RPD
  • 1.6.1 Extracting Projects From Full RPD
    • 1.6.1.1 About Resolving Dimension Keys

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 Oracle Business Intelligence Endeca Discovery Option

• 5.1 Introduction
• 5.2 Setting Up Endeca Integration with Oracle BI Applications
• 5.3 Tasks for Setting Up Oracle Endeca with Oracle BI Applications
  • 5.3.1 Setup Step: Install Oracle Endeca Server
  • 5.3.2 Setup Step: Install Endeca 3.1 Studio
  • 5.3.3 Setup Step: Set Up ODI Connectivity for Oracle BI and Endeca
  • 5.3.4 Setup Step: Load Data
  • 5.3.5 Setup Step: Create a New Endeca Application
• 5.4 ODI Package, Interface, and Procedure Design Overview
• 5.5 Deploying Sample Applications
• 5.6 Applying the Custom BI Applications Security Manager
• 5.7 Troubleshooting

6 Researching Data Lineage

• 6.1 Introduction
• 6.2 Setting Up Data Lineage
• 6.3 Tasks for Setting Up Data Lineage Dashboards
  • 6.3.1 Setup Step: Configure ODI Topology and Load Plan
  • 6.3.2 Setup Step: Configure the WebLogic Server Heap Size
  • 6.3.3 Setup Step: Disable Fusion Step (Optional)
  • 6.3.4 Setup Step: Create the Data Lineage Warehouse Tables
• 6.4 Tasks for Loading and Refreshing Data Lineage Dashboards
  • 6.4.1 Extracting Oracle Business Intelligence Metadata Using Catalog Manager and Administration Tool
  • 6.4.2 Executing and Monitoring the Data Lineage Load Plan
• 6.5 Performing Analysis with Data Lineage Dashboards
  • 6.5.1 Overview of the Oracle BI Applications Data Lineage Dashboard
  • 6.5.2 Analyzing Data Lineage for Oracle Business Intelligence Applications

7 Administering Oracle GoldenGate and Source Dependent Schemas

• 7.1 Introduction
• 7.2 Source Dependent Schema Architecture
• 7.3 Setting Up Oracle GoldenGate and Source Dependent Schemas
• 7.4 Tasks for Setting Up Oracle GoldenGate and the Source Dependent Schema
  • 7.4.1 Setup Step: Configure Source and Target Database
  • 7.4.2 Setup Step: Install Oracle GoldenGate on Source and Target Systems
  • 7.4.3 Setup Step: Configure BI Applications Configuration Manager and Oracle Data Integrator to Support the Source Dependent Schema
  • 7.4.4 Setup Step: Generate, Deploy, and Populate the Source Dependent Schema Tables on Target Database
  • 7.4.5 Setup Step: Generate and Deploy Oracle GoldenGate Parameter Files to Source and Target Machines
    • 7.4.5.1 Generate Oracle GoldenGate Parameter Files
    • 7.4.5.2 Configure the Source System
    • 7.4.5.3 Configure the Target System
  • 7.4.6 Setup Step: Start Oracle GoldenGate on Source and Target Machines
• 7.5 Customization
  • 7.5.1 Adding a Non-Custom Source Column to an Existing ETL Task
  • 7.5.2 Adding a Custom Source Column to an Existing ETL Task
  • 7.5.3 Adding a Non-Custom Source Table to an Existing ETL Task
  • 7.5.4 Creating a Custom ETL Task
• 7.6 Patching
• 7.7 Troubleshooting
  • 7.7.1 Create the SDS Tables
  • 7.7.2 Using the DML Option to Perform an Initial Load
  • 7.7.3 Create SDS Indexes and Analyze the SDS schema

Index