Contents

Title and Copyright Information

Preface

• Audience
• Related Documentation
• Conventions

What's New for Oracle Business Intelligence Applications Administration

• New Features for Oracle BI Applications System Administrators

1 About Multi-Language Support

• About Pseudo-Translations
• About Oracle BI Applications Domains
• About Dimension Translation Tables

2 Localizing Oracle Business Intelligence Deployments

• Maintaining Translation Tables Workflow for Oracle BI EE
  • Adding String Localizations for Oracle BI Repository Metadata
• About Translating Presentation Services Strings
• Changing the Default Currency in Analytics Applications

3 Oracle Business Analytics Warehouse Naming Conventions

• Naming Conventions for Oracle Business Analytics Warehouse Tables
• Table Types for Oracle Business Analytics Warehouse
  • Aggregate Tables in Oracle Business Analytics Warehouse
  • Dimension Class Tables in Oracle Business Analytics Warehouse
  • Dimension Tables in Oracle Business Analytics Warehouse
  • Dimension Tables With Business Role-Based Flags
  • Fact Tables in Oracle Business Analytics Warehouse
  • Helper Tables in Oracle Business Analytics Warehouse
  • Hierarchy Tables in Oracle Business Analytics Warehouse
  • Mini-Dimension Tables in Oracle Business Analytics Warehouse
  • Staging Tables in Oracle Business Analytics Warehouse
  • Translation Tables in Oracle Business Analytics Warehouse
• Internal Tables in Oracle Business Analytics Warehouse
• Standard Column Prefixes in Oracle Business Analytics Warehouse
• Standard Column Suffixes in Oracle Business Analytics Warehouse
• System Columns in Oracle Business Analytics Warehouse Tables
• Multi-Currency Support for System Columns
• Oracle Business Analytics Data Warehouse Primary Data Values
• About Multi-Language Support in Oracle Business Analytics Warehouse
• Oracle Business Analytics Warehouse Currency Preferences

4 Oracle Business Intelligence Endeca Discovery Option

• Setting Up Endeca Integration with Oracle BI Applications
• Tasks for Setting Up Oracle Endeca with Oracle BI Applications
  • Setup Step: Install Oracle Endeca Server and Endeca Studio
  • Setup Step: Set Up ODI Connectivity for Oracle BI and Endeca
  • Setup Step: Load Data
  • Setup Step: Create a New Endeca Application
• ODI Package, Interface, and Procedure Design Overview
• Deploying Sample Applications
• Applying the Custom BI Applications Security Manager
• Troubleshooting Endeca Integration

5 Researching Data Lineage

• Setting Up Data Lineage
  • Setup Step: Configure ODI Topology and Load Plan
  • Setup Step: Configure the WebLogic Server Heap Size
  • Setup Step: Disable Fusion Step (Optional)
  • Setup Step: Create the Data Lineage Warehouse Tables
• Tasks for Loading and Refreshing Data Lineage Dashboards
  • Extracting Oracle Business Intelligence Metadata Using Catalog Manager and Administration Tool
  • Executing and Monitoring the Data Lineage Load Plan
• About Performing Analysis with Data Lineage Dashboards
  • Analyzing Data Lineage for Oracle Business Intelligence Applications

6 Administering Oracle GoldenGate and Source Dependent Schemas

• Source Dependent Schema Architecture
• Tasks for Setting Up Oracle GoldenGate and the Source Dependent Schema
  • Setup Step: Configure Source and Target Database
  • Setup Step: Install Oracle GoldenGate on Source and Target Systems
  • Setup Step: Configure BI Applications Configuration Manager and Oracle Data Integrator to Support the Source Dependent Schema
  • Setup Step: Generate, Deploy, and Populate the Source Dependent Schema Tables on Target Database
  • Setup Step: Generate and Deploy Oracle GoldenGate Parameter Files to Source and Target Systems
  • Setup Step: Start Oracle GoldenGate on Source and Target Systems
• ETL Customization
• Patching
• Troubleshooting GoldenGate and SDS
  • Create the SDS Tables
  • Using the DML Option to Perform an Initial Load
  • Create SDS Indexes and Analyze the SDS Schema
• Setting up Ledger Correlation using GoldenGate