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.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

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 Oracle BI 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 Researching Data Lineage

• 5.1 Introduction
• 5.2 Setting Up Data Lineage
• 5.3 Tasks for Setting Up Data Lineage Dashboards
  • 5.3.1 Setup Step: Configure ODI Topology and Load Plan
  • 5.3.2 Setup Step: Configure RPD and Presentation Catalog Extraction Scripts
  • 5.3.3 Setup Step: Create the Data Lineage Warehouse Tables
• 5.4 Tasks for Loading and Refreshing Data Lineage Dashboards
  • 5.4.1 Extracting Oracle Business Intelligence Metadatata Using Scripts
  • 5.4.2 Executing and Monitoring the Data Lineage Load Plan
• 5.5 Performing Analysis with Data Lineage Dashboards
  • 5.5.1 Overview of the Oracle BI Applications Data Lineage Dashboard
  • 5.5.2 Analyzing Data Lineage for Oracle Business Intelligence Applications

A Enabling Fusion Flex Fields for BI and Using ApplCore Grants for Data Security

• A.1 Setting the Extender for BI Applications Administration Tool Option
  • A.1.1 Opening the Administration Tool
  • A.1.2 Setting the Extender for BI Apps Option
• A.2 Importing Metadata from Fusion Application ADF Data Sources
  • A.2.1 Opening the Import Metadata Wizard
  • A.2.2 Performing an Initial Import
• A.3 Using the BI Extender to Propagate Flex Object Changes
  • A.3.1 About Propagating Changes to Flex Objects to the Data Warehouse
    • A.3.1.1 Overview of BI Extender Use with Oracle BI Applications
    • A.3.1.2 Use Cases for Propagating Flexfield Changes
  • A.3.2 Performing Preconfiguration Tasks for the BI Extender
    • A.3.2.1 Configuring the biextension.properties File
    • A.3.2.2 Configuring the JavaHost loaders.xml File
    • A.3.2.3 Updating NQSConfig.INI
    • A.3.2.4 Optionally Changing the Location of the BI Extender Files
  • A.3.3 Publishing Changes to the Data Warehouse and Propagating Changes to the Repository
    • A.3.3.1 Running the BI Extender to Update ODI and the RPD
  • A.3.4 Automatically Publishing and Mapping Flex Object Changes Using the biserverextender Utility
  • A.3.5 Setting Up XSL Transform Files to Customize XML Output to the Oracle BI Extender
    • A.3.5.1 Sample XML Output
• A.4 Setting Up and Using ApplCore Grants for ADF Data Security
  • A.4.1 Setting Up Oracle Business Intelligence to Use ApplSession
    • A.4.1.1 Setting Up Database Objects and Connection Pools for ApplSession Integration
    • A.4.1.2 Setting Up Initialization Blocks for ApplSession Integration
    • A.4.1.3 About the Client Login Process in an ApplSession Integrated Environment
  • A.4.2 Setting Up Authentication for ApplSession Integration
    • A.4.2.1 Setting Up Security Constraints and Security-Related Servlet Filters in web.xml
    • A.4.2.2 Configuring Role-to-Principal Mapping in weblogic-application.xml
    • A.4.2.3 Configuring the Custom Identity Assertion Provider in Oracle WebLogic Server
    • A.4.2.4 Configuring One-Way SSL in Oracle WebLogic Server

Index