Skip Headers
Oracle® Fusion Middleware Installation Guide for Oracle Business Intelligence Applications
11
g
Release 1 (11.1.1.7)
Part Number E35981-04
Home
Book List
Index
Contact Us
Next
PDF
·
Mobi
·
ePub
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