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