Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in This Guide

1 Oracle BI Applications Architecture

• 1.1 Oracle BI Applications Architecture

2 Preinstallation and Deployment Requirements for Oracle BI Applications

• 2.1 Hardware Requirements
• 2.2 Guidelines for Setting Up Databases for Oracle BI Applications
  • 2.2.1 Guidelines for Oracle Business Analytics Warehouse Databases
  • 2.2.2 Why Use a Separate Database for the Oracle Business Analytics Warehouse?
• 2.3 Oracle-Specific Database Guidelines for Oracle Business Analytics Warehouse
  • 2.3.1 General Guidelines for Oracle Databases
  • 2.3.2 Using Oracle Template Files

3 Setting Up Oracle BI Applications

• 3.1 Overview of Setting Up Oracle BI Applications
  • 3.1.1 About Setting Up Oracle BI Applications
  • 3.1.2 Summary of Home Directories
• 3.2 Prerequisites for Setting Up Oracle BI Applications
• 3.3 Tasks for Setting Up Oracle BI Applications
  • 3.3.1 Downloading Critical Oracle BI Applications Patches
  • 3.3.2 Creating Database Instances for Schemas and Repositories
  • 3.3.3 Creating Schemas Using Business Analytics Applications Suite RCU
  • 3.3.4 Creating Oracle Business Analytics Warehouse Objects with the Oracle Sales Prediction Engine RCU
  • 3.3.5 Updating ATGLite
  • 3.3.6 Updating FSM
  • 3.3.7 Installing Oracle BI Administration Tool
  • 3.3.8 Creating a User for ETL
  • 3.3.9 Extending the BI Domain
  • 3.3.10 Starting the BI and ODI Managed Servers
  • 3.3.11 Configuring Oracle HTTP Server
  • 3.3.12 Configuring SSO and Portlet Provider for Oracle BI Applications Configuration Manager and FSM
    • 3.3.12.1 How to configure SSO for Oracle BI Applications Configuration Manager and FSM
    • 3.3.12.2 How to configure Portlet Provider for Oracle BI Applications Configuration Manager and FSM
  • 3.3.13 Installing ODI Studio and Configuring User Access
    • 3.3.13.1 Installing ODI Studio
    • 3.3.13.2 Configuring User Access for ODI Studio
  • 3.3.14 Applying ODI Patch
  • 3.3.15 Copying Source Files
  • 3.3.16 Performing System Setup Tasks
    • 3.3.16.1 Setting the Business Analytics Warehouse Connection in ODI
    • 3.3.16.2 Registering Source Systems and Propagating Connection Details to ODI
    • 3.3.16.3 Enabling Offerings for Deployment
    • 3.3.16.4 Editing Preferred Currency Display Names and Enabling Document Currency
    • 3.3.16.5 Setting Languages for Data Load into the Business Analytics Warehouse
    • 3.3.16.6 Restoring the BI Metadata Repository File for Oracle BI Applications
    • 3.3.16.7 Mapping Externally Conformed Domains
    • 3.3.16.8 Running the Domains Load Plan
    • 3.3.16.9 Granting Users Access to Configuration Manager, FSM and ODI
  • 3.3.17 Next Steps

A Repository Creation Utility Screens

• A.1 Welcome
• A.2 Create Repository
• A.3 Database Connection Details
  • A.3.1 Specifying Connection Credentials for Oracle Databases and Oracle Databases Enabled for Edition-Based Redefinition
  • A.3.2 Specifying Connection Credentials for Oracle MySQL Databases
  • A.3.3 Specifying Connection Credentials for Microsoft SQL Server Databases
  • A.3.4 Specifying Connection Credentials for IBM DB2 Databases
• A.4 Select Components
  • A.4.1 Creating Database Users for IBM DB2 Databases
  • A.4.2 Creating Prefixes
  • A.4.3 Selecting Components and Dependencies
  • A.4.4 Specifying Custom Schema Names
  • A.4.5 Checking Schema Prerequisites
  • A.4.6 Dropping Schemas
• A.5 Schema Passwords
• A.6 Custom Variables
• A.7 Map Tablespaces
  • A.7.1 Default Tablespace Mappings
  • A.7.2 Changing Default and Temporary Tablespaces
  • A.7.3 Viewing and Changing Additional Tablespaces
  • A.7.4 Managing Tablespaces and Datafiles
    • A.7.4.1 Adding, Modifying, and Removing Tablespaces
    • A.7.4.2 Adding, Modifying, and Removing Datafiles
• A.8 Summary
• A.9 Completion Summary

B Generating DDL and Assigning Tablespaces to Tables and Indexes

• B.1 Overview
• B.2 Generating the Business Analytics Warehouse DDL
• B.3 Patching Oracle BI Applications
• B.4 Assigning Tablespaces

C Customizing Oracle-Delivered Presentation Catalog Content

• C.1 Customizing Oracle-Delivered Presentation Catalog Content

D Available Languages for Oracle BI Applications Release 11.1.1.8.0

• D.1 Available Languages for Release 11.1.1.8.0

Index