Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 What's New in This Release

• 1.1 What's New in Oracle Business Intelligence Applications Fusion Edition Upgrade Guide

2 Overview of Oracle BI Applications Upgrade

• 2.1 Supported Upgrade Paths
• 2.2 Preupgrade Considerations
• 2.3 Best Practices for Preparing to Upgrade
• 2.4 Major Stages of Oracle BI Applications Upgrade
  • 2.4.1 Sequence of Upgrade Stages

Part I Upgrading When Your Source System is Siebel CRM

3 Upgrading Siebel Analytics 7.5.x

• 3.1 Upgrading Oracle BI Infrastructure
• 3.2 Upgrading Oracle BI Applications
• 3.3 Upgrading to Informatica PowerCenter Version 8.1.1, SP4
• 3.4 Configuring Informatica PowerCenter Version 8.1.1, SP4 to Work with the DAC
• 3.5 Upgrading the Informatica Repository
• 3.6 Upgrading the DAC Repository
• 3.7 Overview of Upgrading the Data Warehouse Schema and Migrating Data
• 3.8 Upgrading the Data Warehouse Schema to Version 7.7 and Migrating Data
• 3.9 Upgrading the Data Warehouse Schema to Version 7.9.0
• 3.10 Importing New Schema Definitions into the Siebel Transactional Database
  • 3.10.1 Verifying the Siebel Transactional Database Upgrade
• 3.11 Migrating Data into the Data Warehouse Upgraded to Version 7.9.0
• 3.12 Upgrading the Data Warehouse Schema to Versions 7.9.4 and 7.9.5 and Migrating Data
  • 3.12.1 Upgrading the Data Warehouse Schema to Version 7.9.4 and Migrating Data
  • 3.12.2 Upgrading the Data Warehouse Schema to Version 7.9.5 and Migrating Data
• 3.13 Upgrading the Siebel Analytics Repository
  • 3.13.1 Preparing for the Oracle BI Repository Upgrade
  • 3.13.2 Equalizing the Oracle BI Repositories
  • 3.13.3 Comparing the Siebel Analytics and Oracle BI Repositories
  • 3.13.4 Merging the Siebel Analytics and Oracle BI Repositories
  • 3.13.5 Regression Testing the Oracle BI Repository Merge
• 3.14 Upgrading the Oracle BI Presentation Catalog
  • 3.14.1 Trimming the Input Presentation Catalog
  • 3.14.2 Upgrading the Oracle BI Presentation Catalog to a Newer Version
  • 3.14.3 Testing the Results of the Presentation Catalog Upgrade

4 Upgrading Siebel Business Analytics 7.7, 7.7.x and 7.8.x

• 4.1 Upgrading Oracle BI Infrastructure
• 4.2 Upgrading Oracle BI Applications
• 4.3 Upgrading to Informatica PowerCenter Version 8.1.1, SP4
• 4.4 Configuring Informatica PowerCenter Version 8.1.1, SP4 to Work with the DAC
• 4.5 Upgrading the Informatica Repository
• 4.6 Upgrading the DAC Repository
• 4.7 Overview of Upgrading the Data Warehouse Schema and Migrating Data
• 4.8 Upgrading the Data Warehouse Schema to Version 7.9.0
• 4.9 Importing New Schema Definitions into the Siebel Transactional Database
  • 4.9.1 Verifying the Siebel Transactional Database Upgrade
• 4.10 Migrating Data into the Data Warehouse Upgraded to Version 7.9.0
• 4.11 Upgrading the Data Warehouse Schema to Versions 7.9.4 and 7.9.5 and Migrating Data
  • 4.11.1 Upgrading the Data Warehouse Schema to Version 7.9.4 and Migrating Data
  • 4.11.2 Upgrading the Data Warehouse Schema to Version 7.9.5 and Migrating Data
• 4.12 Upgrading the Siebel Analytics Repository
  • 4.12.1 Preparing for the Oracle BI Repository Upgrade
  • 4.12.2 Equalizing the Oracle BI Repositories
  • 4.12.3 Comparing the Siebel Analytics and Oracle BI Repositories
  • 4.12.4 Merging the Siebel Analytics and Oracle BI Repositories
  • 4.12.5 Regression Testing the Oracle BI Repository Merge
• 4.13 Upgrading the Oracle BI Presentation Catalog
  • 4.13.1 Trimming the Input Presentation Catalog
  • 4.13.2 Upgrading the Oracle BI Presentation Catalog to a Newer Version
  • 4.13.3 Testing the Results of the Presentation Catalog Upgrade

5 Upgrading Oracle BI Applications 7.9.x for the Siebel Adapter

• 5.1 Upgrading Oracle BI Infrastructure
• 5.2 Upgrading Oracle BI Applications
• 5.3 Upgrading to Informatica PowerCenter Release 8.1.1, SP4
• 5.4 Configuring Informatica PowerCenter Release 8.1.1, SP4 to Work with the DAC
• 5.5 Upgrading the Informatica Repository
• 5.6 Upgrading the DAC Repository
• 5.7 Upgrading the Data Warehouse Schema and Migrating Data
  • 5.7.1 Upgrading the Data Warehouse Schema to Version 7.9.4 and Migrating Data
  • 5.7.2 Upgrading the Data Warehouse Schema to Version 7.9.5 and Migrating Data
• 5.8 Upgrading the Oracle BI Repository
  • 5.8.1 Preparing for the Oracle BI Repository Upgrade
  • 5.8.2 Equalizing the Oracle BI Repositories
  • 5.8.3 Comparing the Oracle BI Repositories
  • 5.8.4 Merging the Oracle BI Repositories
  • 5.8.5 Regression Testing the Oracle BI Repository Merge
• 5.9 Upgrading the Oracle BI Presentation Catalog
  • 5.9.1 Trimming the Input Presentation Catalog
  • 5.9.2 Upgrading the Oracle BI Presentation Catalog to a Newer Version
  • 5.9.3 Testing the Results of the Presentation Catalog Upgrade

Part II Upgrading When Your Source System Is Oracle EBS

6 Upgrading Oracle BI Applications for the Oracle Adapter

• 6.1 Upgrading Oracle BI Infrastructure
• 6.2 Upgrading Oracle BI Applications
• 6.3 Upgrading to Informatica PowerCenter Release 8.1.1, SP4
• 6.4 Configuring Informatica PowerCenter Release 8.1.1, SP4 to Work with the DAC
• 6.5 Upgrading the Informatica Repository
• 6.6 Upgrading the DAC Repository
• 6.7 Upgrading the Data Warehouse Schema and Migrating Data
  • 6.7.1 Performing Data Warehouse Schema Upgrade Steps Common to All Previous Releases
  • 6.7.2 Upgrading the Data Warehouse Schema to Version 7.9.3 and Migrating Data
  • 6.7.3 Upgrading the Data Warehouse Schema to Version 7.9.4 and Migrating Data
  • 6.7.4 Upgrading the Data Warehouse Schema to Version 7.9.5 and Migrating Data
• 6.8 Upgrading the Oracle BI Repository
  • 6.8.1 Preparing for the Oracle BI Repository Upgrade
  • 6.8.2 Equalizing the Oracle BI Repositories
  • 6.8.3 Comparing the Oracle BI Repositories
  • 6.8.4 Merging the Oracle BI Repositories
  • 6.8.5 Regression Testing the Oracle BI Repository Merge
• 6.9 Upgrading the Oracle BI Presentation Catalog
  • 6.9.1 Trimming the Input Presentation Catalog
  • 6.9.2 Upgrading the Oracle BI Presentation Catalog to a Newer Version
  • 6.9.3 Testing the Results of the Presentation Catalog Upgrade

Part III Upgrading When Your Source System is Peoplesoft

7 Upgrading Oracle BI Applications for the PeopleSoft Adapter

• 7.1 Upgrading Oracle BI Infrastructure
• 7.2 Upgrading Oracle BI Applications
• 7.3 Upgrading to Informatica PowerCenter Version 8.1.1, SP4
• 7.4 Configuring Informatica PowerCenter Version 8.1.1, SP4 to Work with the DAC
• 7.5 Upgrading the Informatica Repository
• 7.6 Upgrading the DAC Repository
• 7.7 Upgrading the Data Warehouse Schema and Migrating Data
  • 7.7.1 Performing Data Warehouse Schema Upgrade Steps Common to All Previous Releases
  • 7.7.2 Upgrading the Data Warehouse Schema to Version 7.9.4 and Migrating Data
  • 7.7.3 Upgrading the Data Warehouse Schema to Version 7.9.5 and Migrating Data
• 7.8 Upgrading the Oracle BI Repository
  • 7.8.1 Preparing for the Oracle BI Repository Upgrade
  • 7.8.2 Equalizing the Oracle BI Repositories
  • 7.8.3 Comparing the Oracle BI Repositories
  • 7.8.4 Merging the Oracle BI Repositories
  • 7.8.5 Regression Testing the Oracle BI Repository Merge
• 7.9 Upgrading the Oracle BI Presentation Catalog
  • 7.9.1 Trimming the Input Presentation Catalog
  • 7.9.2 Upgrading the Oracle BI Presentation Catalog to a Newer Version
  • 7.9.3 Testing the Results of the Presentation Catalog Upgrade

A Upgrading the Oracle BI Repository for Industry-Specific Analytics Applications

• A.1 Common Dimensions
• A.2 Merging Siebel Analytics and Oracle BI Repositories
  • A.2.1 Creating Working Folders
  • A.2.2 Trimming Repository Files
  • A.2.3 Renaming Objects in the Original Pharma Base Repository File
  • A.2.4 Equalizing the Oracle BI Repositories
  • A.2.5 Merging the Core Repository Files
  • A.2.6 Merging the Pharma Repository Files
  • A.2.7 Making Merge Decisions in the Server Admin Tool
• A.3 Replacing Common Dimensions After the Repository Merge

Index