Skip Headers
Oracle® Fusion Middleware Administrator's Guide for Oracle Business Intelligence Applications
11
g
Release 1 (11.1.1.7)
Part Number E37988-01
Home
Book List
Index
Contact Us
Next
PDF
·
Mobi
·
ePub
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documentation
Conventions
What's New in This Release
Notable Features in Oracle BI Applications Documented in This Guide
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.5
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
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
Administering Oracle GoldenGate and Source Dependent Schemas
5.1
Introduction
5.2
Source Dependent Schema Architecture
5.3
Setting Up Oracle GoldenGate and Source Dependent Schemas
5.4
Tasks for Setting Up Oracle GoldenGate and the Source Dependent Schema
5.4.1
Setup Step: Configure Source and Target Database
5.4.2
Setup Step: Install Oracle GoldenGate on Source and Target Systems
5.4.3
Setup Step: Configure BI Applications Configuration Manager and Oracle Data Integrator to Support the Source Dependent Schema
5.4.4
Setup Step: Generate, Deploy, and Populate the Source Dependent Schema Tables on Target Database
5.4.5
Setup Step: Generate and Deploy Oracle GoldenGate Parameter Files to Source and Target Machines
5.4.5.1
Generate Oracle GoldenGate Parameter Files
5.4.5.2
Configure the Source System
5.4.5.3
Configure the Target System
5.4.6
Setup Step: Start Oracle GoldenGate on Source and Target Machines
Index