Go to main content
1/41
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
Scripting on this page enhances content navigation, but does not change the content in any way.