1/34

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

What's New for Oracle BI 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 Enterprise Edition
  • 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 WarehouseTables
• 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 WarehouseTables
• Multi-Currency Support for System Columns
• Oracle Business Analytics Warehouse Primary Data Values
• About Multi-Language Support in Oracle Business Analytics Warehouse
• Oracle Business Analytics Warehouse Currency Preferences

4 Researching Data Lineage

• Setting Up Data Lineage
  • Setup Step: Configure ODI Topology and Load Plan
  • Setup Step: Configure the Oracle 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 BI Metadata Using Catalog Manager and Oracle BI Administration Tool
  • Executing and Monitoring the Data Lineage Load Plan
• About Performing Analysis with Data Lineage Dashboards
  • Analyzing Data Lineage for Oracle BI Applications

5 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 Configuration Manager and ODI 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 Oracle 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 Oracle GoldenGate