Contents

List of Figures

List of Tables

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 BI Applications Release 7.9.6.2

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.6.1 and Hotfix 11
• 3.4 Upgrading the Informatica Repository
• 3.5 Configuring Informatica PowerCenter Version 8.6.1 to Work with Oracle BI Applications and DAC
• 3.6 Installing and Configuring DAC
• 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 Version 7.9.4 and Migrating Data
• 3.13 Upgrading the Data Warehouse Schema to Version 7.9.5 and Migrating Data
• 3.14 Upgrading the Data Warehouse Schema to Version 7.9.5.1
• 3.15 Upgrading the Data Warehouse Schema from Version 7.9.5.1 to 7.9.6.1 and Migrating Data
  • 3.15.1 Upgrading the Data Warehouse Schema from Version 7.9.5.1 to 7.9.6.1
  • 3.15.2 Migrating Data into the Upgraded Data Warehouse
  • 3.15.3 Verifying the Data Migrated Successfully
  • 3.15.4 Resetting Refresh Dates
• 3.16 Upgrading the Data Warehouse Schema from Version 7.9.6 to 7.9.6.1
  • 3.16.1 Upgrading the Data Warehouse Schema to Version 7.9.6.1
  • 3.16.2 Migrating Data into the Upgraded Data Warehouse
  • 3.16.3 Verifying the Data Migrated Successfully
• 3.17 Upgrading the Data Warehouse Schema from Version 7.9.6.1 to 7.9.6.2 and Migrating Data
  • 3.17.1 Upgrading the Data Warehouse Schema to Version 7.9.6.2
  • 3.17.2 Migrating Data into the Upgraded Data Warehouse
  • 3.17.3 Verifying the Data Migrated Successfully
• 3.18 Upgrading the Siebel Analytics Repository
  • 3.18.1 Preparing for the Oracle BI Repository Upgrade
  • 3.18.2 Equalizing the Oracle BI Repositories
  • 3.18.3 Comparing the Siebel Analytics and Oracle BI Repositories
  • 3.18.4 Merging the Siebel Analytics and Oracle BI Repositories
  • 3.18.5 Regression Testing the Oracle BI Repository Merge
• 3.19 Upgrading the Oracle BI Presentation Catalog
  • 3.19.1 Trimming the Input Presentation Catalog
  • 3.19.2 Upgrading the Oracle BI Presentation Catalog to a Newer Version
  • 3.19.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.6.1 and Hotfix 11
• 4.4 Upgrading the Informatica Repository
• 4.5 Configuring Informatica PowerCenter Version 8.6.1 to Work with Oracle BI Applications and DAC
• 4.6 Upgrading and Configuring DAC
  • 4.6.1 Installing the DAC Platform and Oracle BI Applications Metadata Repository Files
  • 4.6.2 Configuring the DAC Client and Server to Work with Oracle BI Applications and Informatica
  • 4.6.3 Upgrading the DAC Repository for Siebel Business Analytics
• 4.7 Overview of Upgrading the Data Warehouse Schema and Migrating Data for Non-Teradata Databases
• 4.8 Upgrading the Data Warehouse Schema to Version 7.9.0 for Non-Teradata Databases
• 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 for Non-Teradata Databases
• 4.11 Upgrading the Data Warehouse Schema to Version 7.9.4 and Migrating Data for Non-Teradata Databases
• 4.12 Upgrading the Data Warehouse Schema to Version 7.9.5 and Migrating Data for Non-Teradata Databases
• 4.13 Upgrading the Data Warehouse Schema to Version 7.9.5.1 for Non-Teradata Databases
• 4.14 Upgrading the Data Warehouse Schema from Version 7.9.5.1 to 7.9.6.1 and Migrating Data for Non-Teradata Databases
  • 4.14.1 Upgrading the Data Warehouse Schema from Version 7.9.5.1 to 7.9.6.1
  • 4.14.2 Migrating Data into the Upgraded Data Warehouse
  • 4.14.3 Verifying the Data Migrated Successfully
  • 4.14.4 Resetting Refresh Dates
• 4.15 Upgrading the Data Warehouse Schema from Version 7.9.6 to 7.9.6.1 and Migrating Data for Non-Teradata Databases
  • 4.15.1 Upgrading the Data Warehouse Schema to Version 7.9.6.1
  • 4.15.2 Migrating Data into the Upgraded Data Warehouse
  • 4.15.3 Verifying the Data Migrated Successfully
• 4.16 Upgrading the Data Warehouse Schema from Version 7.9.6.1 to 7.9.6.2 and Migrating Data for Non-Teradata Databases
  • 4.16.1 Upgrading the Data Warehouse Schema to Version 7.9.6.2
  • 4.16.2 Migrating Data into the Upgraded Data Warehouse
  • 4.16.3 Verifying the Data Migrated Successfully
• 4.17 Upgrading the Data Warehouse Schema and Migrating Data for Teradata Databases
  • 4.17.1 Upgrading Oracle BI Applications from Version 7.9.0 to 7.9.6.2
  • 4.17.2 Upgrading Oracle BI Applications from Version 7.9.4 to 7.9.6.2
  • 4.17.3 Upgrading Oracle BI Applications from Version 7.9.5 to 7.9.6.2
  • 4.17.4 Upgrading Oracle BI Applications from Version 7.9.5.1 to 7.9.6.2
  • 4.17.5 Upgrading Oracle BI Applications from Version 7.9.6.1 to 7.9.6.2
• 4.18 Upgrading the Siebel Analytics Repository
  • 4.18.1 Preparing for the Oracle BI Repository Upgrade
  • 4.18.2 Equalizing the Oracle BI Repositories
  • 4.18.3 Comparing the Siebel Analytics and Oracle BI Repositories
  • 4.18.4 Merging the Siebel Analytics and Oracle BI Repositories
  • 4.18.5 Regression Testing the Oracle BI Repository Merge
• 4.19 Upgrading the Oracle BI Presentation Catalog
  • 4.19.1 Trimming the Input Presentation Catalog
  • 4.19.2 Upgrading the Oracle BI Presentation Catalog to a Newer Version
  • 4.19.3 Testing the Results of the Presentation Catalog Upgrade

5 Upgrading Oracle BI Applications 7.9.x for Siebel Source Systems

• 5.1 Upgrading Oracle BI Infrastructure
• 5.2 Upgrading Oracle BI Applications
• 5.3 Upgrading to Informatica PowerCenter Version 8.6.1 and Hotfix 11
• 5.4 Upgrading the Informatica Repository
• 5.5 Configuring Informatica PowerCenter Version 8.6.1 to Work with Oracle BI Applications and DAC
• 5.6 Upgrading and Configuring DAC
  • 5.6.1 Installing the DAC Platform and Oracle BI Applications Metadata Repository Files
  • 5.6.2 Configuring the DAC Client and Server to Work with Oracle BI Applications and Informatica
  • 5.6.3 Upgrading the DAC Repository
• 5.7 Importing New Schema Definitions into the Siebel Transactional Database
  • 5.7.1 Verifying the Siebel Transactional Database Upgrade
• 5.8 Upgrading the Data Warehouse Schema and Migrating Data for Non-Teradata Databases
  • 5.8.1 Upgrading the Data Warehouse Schema from Version 7.9.0 to 7.9.4 and Migrating Data
  • 5.8.2 Upgrading the Data Warehouse Schema from Version 7.9.4 to 7.9.5 and Migrating Data
  • 5.8.3 Upgrading the Data Warehouse Schema from Version 7.9.5 to 7.9.5.1 and Migrating Data
  • 5.8.4 Upgrading the Data Warehouse Schema from Version 7.9.5.1 to 7.9.6.1 and Migrating Data
    • 5.8.4.1 Upgrading the Data Warehouse Schema to Version 7.9.6.1
    • 5.8.4.2 Migrating Data into the Upgraded Data Warehouse
    • 5.8.4.3 Verifying the Data Migrated Successfully
    • 5.8.4.4 Resetting Refresh Dates
  • 5.8.5 Upgrading the Data Warehouse Schema from Version 7.9.6 to 7.9.6.1 and Migrating Data
    • 5.8.5.1 Upgrading the Data Warehouse Schema to Version 7.9.6.1
    • 5.8.5.2 Migrating Data into the Upgraded Data Warehouse
    • 5.8.5.3 Verifying the Data Migrated Successfully
  • 5.8.6 Upgrading the Data Warehouse Schema from Version 7.9.6.1 to 7.9.6.2 and Migrating Data
    • 5.8.6.1 Upgrading the Data Warehouse Schema to Version 7.9.6.2
    • 5.8.6.2 Migrating Data into the Upgraded Data Warehouse
    • 5.8.6.3 Verifying the Data Migrated Successfully
• 5.9 Upgrading the Data Warehouse Schema and Migrating Data for Teradata Databases
  • 5.9.1 Upgrading Oracle BI Applications from Version 7.9.0 to 7.9.6.2
  • 5.9.2 Upgrading Oracle BI Applications from Version 7.9.4 to 7.9.6.2
  • 5.9.3 Upgrading Oracle BI Applications from Version 7.9.5 to 7.9.6.2
  • 5.9.4 Upgrading Oracle BI Applications from Version 7.9.5.1 to 7.9.6.2
  • 5.9.5 Upgrading Oracle BI Applications from Version 7.9.6.1 to 7.9.6.2
• 5.10 Upgrading the Oracle BI Repository
  • 5.10.1 Preparing for the Oracle BI Repository Upgrade
  • 5.10.2 Equalizing the Oracle BI Repositories
  • 5.10.3 Comparing the Oracle BI Repositories
  • 5.10.4 Merging the Oracle BI Repositories
  • 5.10.5 Regression Testing the Oracle BI Repository Merge
• 5.11 Upgrading the Oracle BI Presentation Catalog
  • 5.11.1 Trimming the Input Presentation Catalog
  • 5.11.2 Upgrading the Oracle BI Presentation Catalog to a Newer Version
  • 5.11.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 Oracle Source Systems

• 6.1 Upgrading Oracle BI Infrastructure
• 6.2 Upgrading Oracle BI Applications
• 6.3 Upgrading to Informatica PowerCenter Version 8.6.1 and Hotfix 11
• 6.4 Upgrading the Informatica Repository
• 6.5 Configuring Informatica PowerCenter Version 8.6.1 to Work with Oracle BI Applications and DAC
• 6.6 Upgrading and Configuring DAC
  • 6.6.1 Installing the DAC Platform and Oracle BI Applications Metadata Repository Files
  • 6.6.2 Configuring the DAC Client and Server to Work with Oracle BI Applications and Informatica
  • 6.6.3 Upgrading the DAC Repository
• 6.7 Upgrading the Data Warehouse Schema and Migrating Data for Non-Teradata Databases
  • 6.7.1 Performing Data Warehouse Schema Upgrade Steps Common to All Previous Releases
  • 6.7.2 Upgrading the Data Warehouse Schema from Version 7.9.x to 7.9.3 and Migrating Data
  • 6.7.3 Upgrading the Data Warehouse Schema from Version 7.9.3 to 7.9.4 and Migrating Data
  • 6.7.4 Upgrading the Data Warehouse Schema from Version 7.9.4 to 7.9.5. and Migrating Data
  • 6.7.5 Upgrading the Data Warehouse Schema from Version 7.9.5 to 7.9.5.1 and Migrating Data
  • 6.7.6 Upgrading the Data Warehouse Schema from Version 7.9.5.1 to 7.9.6.1 and Migrating Data
    • 6.7.6.1 Upgrading the Data Warehouse Schema to Version 7.9.6.1
    • 6.7.6.2 Migrating Data into the Upgraded Data Warehouse
    • 6.7.6.3 Verifying the Data Migrated Successfully
    • 6.7.6.4 Resetting Refresh Dates
  • 6.7.7 Upgrading the Data Warehouse Schema from Version 7.9.6 to 7.9.6.1 and Migrating Data
    • 6.7.7.1 Upgrading the Data Warehouse Schema to Version 7.9.6.1
    • 6.7.7.2 Migrating Data into the Upgraded Data Warehouse
    • 6.7.7.3 Verifying the Data Migrated Successfully
  • 6.7.8 Upgrading the Data Warehouse Schema from Version 7.9.6.1 to 7.9.6.2 and Migrating Data
    • 6.7.8.1 Upgrading the Data Warehouse Schema to Version 7.9.6.2
    • 6.7.8.2 Migrating Data into the Upgraded Data Warehouse
    • 6.7.8.3 Verifying the Data Migrated Successfully
• 6.8 Upgrading the Data Warehouse Schema and Migrating Data for Teradata Databases
  • 6.8.1 Upgrading Oracle BI Applications from Version 7.9.0 to 7.9.6.2
  • 6.8.2 Upgrading Oracle BI Applications from Version 7.9.3 to 7.9.6.2
  • 6.8.3 Upgrading Oracle BI Applications from Version 7.9.4 to 7.9.6.2
  • 6.8.4 Upgrading Oracle BI Applications from Version 7.9.5 to 7.9.6.2
  • 6.8.5 Upgrading Oracle BI Applications from Version 7.9.5.1 to 7.9.6.2
  • 6.8.6 Upgrading Oracle BI Applications from Version 7.9.6.1 to 7.9.6.2
• 6.9 Upgrading the Oracle BI Repository
  • 6.9.1 Preparing for the Oracle BI Repository Upgrade
  • 6.9.2 Equalizing the Oracle BI Repositories
  • 6.9.3 Comparing the Oracle BI Repositories
  • 6.9.4 Merging the Oracle BI Repositories
  • 6.9.5 Regression Testing the Oracle BI Repository Merge
• 6.10 Upgrading the Oracle BI Presentation Catalog
  • 6.10.1 Trimming the Input Presentation Catalog
  • 6.10.2 Upgrading the Oracle BI Presentation Catalog to a Newer Version
  • 6.10.3 Testing the Results of the Presentation Catalog Upgrade

Part III Upgrading When Your Source System is PeopleSoft

7 Upgrading Oracle BI Applications for PeopleSoft Source Systems

• 7.1 Upgrading Oracle BI Infrastructure
• 7.2 Upgrading Oracle BI Applications
• 7.3 Upgrading to Informatica PowerCenter Version 8.6.1 and Hotfix 11
• 7.4 Upgrading the Informatica Repository
• 7.5 Configuring Informatica PowerCenter Version 8.6.1 to Work with Oracle BI Applications and DAC
• 7.6 Upgrading and Configuring DAC
  • 7.6.1 Installing the DAC Platform and Oracle BI Applications Metadata Repository Files
  • 7.6.2 Configuring the DAC Client and Server to Work with Oracle BI Applications and Informatica
  • 7.6.3 Upgrading the DAC Repository
• 7.7 Upgrading the Data Warehouse Schema and Migrating Data for Non-Teradata Databases
  • 7.7.1 Performing Data Warehouse Schema Upgrade Steps Common to All Previous Releases
  • 7.7.2 Upgrading the Data Warehouse Schema from Version 7.9.3 to 7.9.4 and Migrating Data
  • 7.7.3 Upgrading the Data Warehouse Schema from Version 7.9.4 to 7.9.5 and Migrating Data
  • 7.7.4 Upgrading the Data Warehouse Schema from Version 7.9.5 to 7.9.5.1 and Migrating Data
  • 7.7.5 Upgrading the Data Warehouse Schema from Version 7.9.5.1 to 7.9.6.1 and Migrating Data
    • 7.7.5.1 Upgrading the Data Warehouse Schema to Version 7.9.6.1
    • 7.7.5.2 Migrating Data into the Upgraded Data Warehouse
    • 7.7.5.3 Verifying the Data Migrated Successfully
    • 7.7.5.4 Resetting Refresh Dates
  • 7.7.6 Upgrading the Data Warehouse Schema from Version 7.9.6 to 7.9.6.1 and Migrating Data
    • 7.7.6.1 Upgrading the Data Warehouse Schema to Version 7.9.6.1
    • 7.7.6.2 Migrating Data into the Upgraded Data Warehouse
    • 7.7.6.3 Verifying the Data Migrated Successfully
  • 7.7.7 Upgrading the Data Warehouse Schema from Version 7.9.6.1 to 7.9.6.2 and Migrating Data
    • 7.7.7.1 Upgrading the Data Warehouse Schema to Version 7.9.6.2
    • 7.7.7.2 Migrating Data into the Upgraded Data Warehouse
    • 7.7.7.3 Verifying the Data Migrated Successfully
• 7.8 Upgrading the Data Warehouse Schema and Migrating Data for Teradata Databases
  • 7.8.1 Upgrading Oracle BI Applications from Version 7.9.3 to 7.9.6.2
  • 7.8.2 Upgrading Oracle BI Applications from Version 7.9.4 to 7.9.6.2
  • 7.8.3 Upgrading Oracle BI Applications from Version 7.9.5 to 7.9.6.2
  • 7.8.4 Upgrading Oracle BI Applications from Version 7.9.5.1 to 7.9.6.2
  • 7.8.5 Upgrading Oracle BI Applications from Version 7.9.6.1 to 7.9.6.2
• 7.9 Upgrading the Oracle BI Repository
  • 7.9.1 Preparing for the Oracle BI Repository Upgrade
  • 7.9.2 Equalizing the Oracle BI Repositories
  • 7.9.3 Comparing the Oracle BI Repositories
  • 7.9.4 Merging the Oracle BI Repositories
  • 7.9.5 Regression Testing the Oracle BI Repository Merge
• 7.10 Upgrading the Oracle BI Presentation Catalog
  • 7.10.1 Trimming the Input Presentation Catalog
  • 7.10.2 Upgrading the Oracle BI Presentation Catalog to a Newer Version
  • 7.10.3 Testing the Results of the Presentation Catalog Upgrade
• 7.11 Upgrading the Oracle BI Repository
  • 7.11.1 Preparing for the Oracle BI Repository Upgrade
  • 7.11.2 Equalizing the Oracle BI Repositories
  • 7.11.3 Comparing the Oracle BI Repositories
  • 7.11.4 Merging the Oracle BI Repositories
  • 7.11.5 Regression Testing the Oracle BI Repository Merge
• 7.12 Upgrading the Oracle BI Presentation Catalog
  • 7.12.1 Trimming the Input Presentation Catalog
  • 7.12.2 Upgrading the Oracle BI Presentation Catalog to a Newer Version
  • 7.12.3 Testing the Results of the Presentation Catalog Upgrade

Part IV Upgrading When Your Source System is JD Edwards

8 Upgrading Oracle BI Applications for JD Edwards Source Systems

• 8.1 Upgrading Oracle BI Infrastructure
• 8.2 Upgrading Oracle BI Applications
• 8.3 Upgrading to Informatica PowerCenter Version 8.6.1 and Hotfix 11
• 8.4 Upgrading the Informatica Repository
• 8.5 Configuring Informatica PowerCenter Version 8.6.1 to Work with Oracle BI Applications and DAC
• 8.6 Upgrading and Configuring DAC
  • 8.6.1 Installing the DAC Platform and Oracle BI Applications Metadata Repository Files
  • 8.6.2 Configuring the DAC Client and Server to Work with Oracle BI Applications and Informatica
  • 8.6.3 Upgrading the DAC Repository
• 8.7 Upgrading the Data Warehouse Schema and Migrating Data for Non-Teradata Databases
  • 8.7.1 Upgrading the Data Warehouse Schema from Version 7.9.6 to 7.9.6.1 and Migrating Data
    • 8.7.1.1 Upgrading the Data Warehouse Schema from Version 7.9.6 to 7.9.6.1
    • 8.7.1.2 Migrating Data into the Upgraded Data Warehouse
    • 8.7.1.3 Verifying the Data Migrated Successfully
  • 8.7.2 Upgrading the Data Warehouse Schema from Version 7.9.6.1 to 7.9.6.2 and Migrating Data for Non-Teradata Databases
    • 8.7.2.1 Upgrading the Data Warehouse Schema to Version 7.9.6.2
    • 8.7.2.2 Migrating Data into the Upgraded Data Warehouse
    • 8.7.2.3 Verifying the Data Migrated Successfully
    • 8.7.2.4 Resetting Refresh Dates
• 8.8 Upgrading the Data Warehouse Schema to Version 7.9.6.2 and Migrating Data for Teradata Databases
• 8.9 Upgrading the Oracle BI Repository
  • 8.9.1 Preparing for the Oracle BI Repository Upgrade
  • 8.9.2 Equalizing the Oracle BI Repositories
  • 8.9.3 Comparing the Oracle BI Repositories
  • 8.9.4 Merging the Oracle BI Repositories
  • 8.9.5 Regression Testing the Oracle BI Repository Merge
• 8.10 Upgrading the Oracle BI Presentation Catalog
  • 8.10.1 Trimming the Input Presentation Catalog
  • 8.10.2 Upgrading the Oracle BI Presentation Catalog to a Newer Version
  • 8.10.3 Testing the Results of the Presentation Catalog Upgrade

Part V Appendices

A Configuring Informatica Parameter Files

• A.1 Setting Parameters in 793_UPG_PARAMS.txt
• A.2 Setting Parameters in 794_UPG_PARAMS.txt
• A.3 Setting Parameters in 795_UPG_PARAMS.txt
• A.4 Setting Parameters in 7951_UPG_PARAMS.txt
• A.5 Setting Parameters in 796_UPG_PARAMS.txt for All Source Systems
• A.6 Setting Additional Parameters in 796_UPG_PARAMS.txt for Oracle EBS 11i Source Systems
• A.7 Setting Additional Parameters in 796_UPG_PARAMS.txt for Siebel Source Systems
• A.8 Setting Parameters in 7961_UPG_PARAMS.txt
• A.9 Setting Parameters in 7962_UPG_PARAMS.txt
• A.10 Setting Additional Parameters in 7962_UPG_PARAMS.txt for PeopleSoft Source Systems

B Configuring Application-Specific Parameters and Mappings

• B.1 Configuring Parameters and Mappings in 796_UPG_PARAMS.txt for Oracle Financial Analytics
  • B.1.1 Configuring Parameters for Value Set Hierarchies and FSG Hierarchies
  • B.1.2 Configuring Parameters for GL Data Extraction
    • B.1.2.1 Configuring GL Data Extraction Parameters for Oracle EBS 11i Sources
    • B.1.2.2 Configuring GL Data Extraction Parameters for Oracle EBS R12 Sources
  • B.1.3 Configuring the COGS Fact Mapping for Oracle EBS R12
  • B.1.4 Configuring the $$Hint1 Parameter for Oracle Databases
• B.2 Configuring Parameters in 796_UPG_PARAMS.txt for Oracle Project Analytics
• B.3 Configuring Parameters in 796_UPG_PARAMS.txt for Oracle Supply Chain and Order Management Analytics
  • B.3.1 Configuring the TIME_GRAIN Parameter for Sales Order Lines Aggregate Fact and Invoice Lines Aggregate Fact Tables
  • B.3.2 Configuring the $$PERIOD Parameter for the Customer Status History Fact Table
• B.4 Configuring Parameters and Mappings in 7962_UPG_PARAMS.txt for Oracle Financial Analytics
  • B.4.1 Configuring Parameters for Oracle Financial Analytics
    • B.4.1.1 Configuring Parameters for GL Data Extraction
  • B.4.2 Configuring the COGS Fact Mapping for Oracle EBS R12

C Generating and Running Scripts to Drop and Create Indexes

• C.1 Generating Scripts to Drop and Create Indexes
• C.2 Running the Script to Drop All Indexes
• C.3 Running the Scripts to Create ETL and Query Indexes

D Creating Indexes for Oracle Financial Analytics

• D.1 Indexes for SIL_PositionDimension_UPD7962 Mapping
• D.2 Indexes for SIL_PositionDimensionHierarchy_UPD7962 Mapping

E Database-Specific Parameter Settings for the reset_infa_seq_gen.bat File

• E.1 Running the reset_infa_seq_gen.bat File on the Base Informatica Repository
  • E.1.1 Entering Values for the reset_infa_seq_gen.bat File on the Base Informatica Repository
  • E.1.2 Obtaining ROW_WID from W_ORG_D
• E.2 Running the reset_infa_seq_gen.bat File on the Upgrade Informatica Repository

F Using the DDLimp Utility

• F.1 Using the DDLimp Utility to Run CTL Files
• F.2 Additional DDLimp Commands

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

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

Index