Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in This Guide

1 Oracle BI Applications Architecture and Installation Overview

• 1.1 Oracle BI Applications Architecture
• 1.2 Oracle BI Applications Installation Roadmap

2 Preinstallation and Deployment Requirements for Oracle BI Applications

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

3 Installing and Setting Up Oracle BI Applications

• 3.1 Hardware Requirements
• 3.2 Installing Prerequisites for Oracle BI Applications
  • 3.2.1 Installing JDK or JRockit
  • 3.2.2 Installing Oracle WebLogic Server
  • 3.2.3 Running Fusion Middleware RCU
  • 3.2.4 Installing Oracle Business Intelligence Enterprise Edition 11g
  • 3.2.5 Installing Oracle Data Integrator (ODI)
• 3.3 Installing and Configuring Oracle BI Applications
  • 3.3.1 Creating Database Instances for Schemas and Repositories
  • 3.3.2 Creating Schemas Using Business Analytics Applications Suite RCU
  • 3.3.3 Installing Oracle BI Applications Using the Business Analytics Applications Suite Installer
  • 3.3.4 Applying Platform Patches
  • 3.3.5 Configuring Oracle Business Intelligence
  • 3.3.6 Configuring Oracle BI Applications
  • 3.3.7 Upgrading to WebLogic Server 10.3.6
  • 3.3.8 Installing ODI Studio and Load Plan Generator Plug-In
    • 3.3.8.1 Installing ODI Studio
    • 3.3.8.2 Configuring User Access for ODI Studio
    • 3.3.8.3 Installing Oracle BI Applications Load Plan Generator Plug-In
  • 3.3.9 Applying Post-Installation Patches
    • 3.3.9.1 Applying the ATGLite Patch
    • 3.3.9.2 Applying Patch 16629917 to ODI Studio
    • 3.3.9.3 Applying Patch 16492220 to BI Clients
  • 3.3.10 Copying Source Files
• 3.4 Performing Post-Installation System Set Up Tasks
  • 3.4.1 Setting the Business Analytics Warehouse Connection in ODI
  • 3.4.2 Registering Source Systems and Propagating Connection Details to ODI
  • 3.4.3 Enabling Offerings for Deployment
  • 3.4.4 Editing Preferred Currency Display Names and Enabling Document Currency
  • 3.4.5 Setting Languages for Data Load into the Business Analytics Warehouse
  • 3.4.6 Running the Domains Load Plan
  • 3.4.7 Granting Users Access to Configuration Manager, FSM and ODI
  • 3.4.8 Trimming the RPD
    • 3.4.8.1 Extracting Projects From Full RPD
    • 3.4.8.2 Merging Repositories
• 3.5 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.6.1 Specifying Custom Variables for Oracle Business Intelligence Applications and Operational Planning Applications
  • A.6.2 Specifying Custom Variables for Master and Work Repository (ODI)
  • A.6.3 Specifying Custom Variables for Oracle WebCenter Portal's Activity Graph and Analytics
• 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 Installer Screens Common to All Oracle Fusion Middleware Suites

• B.1 Specify Inventory Location
• B.2 Inventory Location Confirmation
• B.3 Welcome
• B.4 Prerequisite Checks
• B.5 Security Updates
• B.6 Software Updates
• B.7 Installation Location
• B.8 Application Server
• B.9 Summary
• B.10 Installation Progress
• B.11 Configuration Progress
• B.12 Complete

C Oracle BI Applications Installation and Configuration Screens

• C.1 Welcome (When Running Business Analytics Applications Suite Installer)
• C.2 Specify Installation Location (When Running Business Analytics Applications Suite Installer)
• C.3 Welcome (When Running the configApps.bat/sh File)
• C.4 Extend BI Domain
• C.5 Specify Installation Location (When Running the configApps.bat/sh File)
• C.6 Configure Components
• C.7 RPD Encryption Password
• C.8 BI Applications Administrator User
• C.9 MDS Schema
• C.10 BI Applications Components Repository Schema
• C.11 OPL Schema
• C.12 Business Analytics Warehouse Schema
• C.13 BI Applications ODI Repository Schema
• C.14 Configure Ports

D Oracle BI Applications Configuration Manager System Setup UI Reference

• D.1 Define Business Intelligence Applications Instance: Source System Tab
• D.2 Define Business Intelligence Applications Instance: Target Warehouse Tab
• D.3 Define Business Intelligence Applications Instance: Environment Configuration Tab
• D.4 Edit Business Analytics Warehouse Dialog
• D.5 Edit Preferred Currency Name Dialog
• D.6 Edit Source Dialog
  • D.6.1 Edit Source in Configuration Manager
  • D.6.2 Edit Source in Oracle Data Integrator Topology
    • D.6.2.1 Oracle Data Integrator Connection Information
    • D.6.2.2 Provide Context Details
    • D.6.2.3 Provide Connection Details
• D.7 Manage BI Applications: BI Application Offerings Tab
• D.8 Manage BI Applications: BI Application Offerings and Associated Sources Tab
• D.9 Manage Preferred Currencies
• D.10 Manage Warehouse Languages
• D.11 Register Source Dialog
  • D.11.1 Register Source in Configuration Manager
  • D.11.2 Register Source in Oracle Data Integrator Topology
    • D.11.2.1 Oracle Data Integrator Connection Information
    • D.11.2.2 Provide Context Details
    • D.11.2.3 Provide Connection Details

E Generating DDL and Assigning Tablespaces to Tables and Indexes

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

F Integrating Interactive Dashboards and Siebel Operational Applications Data

• F.1 Updating the Siebel Operational Application
• F.2 Reapplying Customized Style Sheets
• F.3 How to Configure Oracle Business Intelligence with Oracle's Siebel Web Server Extension (SWSE)
• F.4 Creating a Virtual IP Address for the SWSE and Oracle BI Presentation Services
• F.5 Testing the Virtual IP Configuration for Oracle Business Intelligence and the SWSE
• F.6 About Configuring Oracle BI Action Links
• F.7 Accessing Optional Analytics Applications
• F.8 Customizing Oracle BI Application Home Page and Dashboards
  • F.8.1 Configure a new Home Page to use a symbolic URL
  • F.8.2 Determine the Oracle BI Report Path Argument
  • F.8.3 Add Views for Custom Oracle BI Interactive Dashboards
• F.9 Viewing Information About Preconfigured Dashboards
  • F.9.1 Exposing Dashboards and Requests
  • F.9.2 Locating Dashboards, Page Names and Reports

G Preconfigured Mappings for Siebel System Subject Area

• G.1 About Preconfigured Mappings for Siebel System Subject Area

Index