Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Overview: Migrating from Oracle Business Intelligence 11g to 12c

• 1.1 Understanding the 12c Migration Procedure
  • 1.1.1 Analyzing and Optimizing the Existing 11g System
  • 1.1.2 What is Migrated and How?
  • 1.1.3 Defining a Test Plan to Validate the Migration
  • 1.1.4 Testing the Migration on a Representative Subset of the Existing 11g System
  • 1.1.5 Performing the Migration

2 Migrating from Oracle BI 11g to 12c

• 2.1 Prerequisites
• 2.2 Generating the BI Migration Tool (bi-migration-tool.jar)
• 2.3 Creating the Export Bundle
• 2.4 Importing with the BI Migration Script (migration-tool.sh|cmd)
• 2.5 Validating the Oracle BI Deployments

3 Post-Migration Steps for Oracle BI EE

• 3.1 Migrating Catalog Groups
• 3.2 Migrating Configuration of Oracle BI EE
  • 3.2.1 Migrating Oracle BI WebLogic Security Configuration
  • 3.2.2 Migrating Oracle Enterprise Manager Fusion Middleware Control Security Configuration
  • 3.2.3 Migrating the Oracle Enterprise Manager Fusion Middleware Control Managed Business Intelligence Configurations
  • 3.2.4 Migrating the Enterprise Manager Fusion Middleware Control Managed Business Intelligence Log Configuration
  • 3.2.5 Migrating Oracle BI Server Configuration
  • 3.2.6 Migrating Oracle BI Presentation Server Configuration
• 3.3 Configuring the Database to Use DataDirect Drivers
• 3.4 Configuring Usage Tracking
• 3.5 Configuring the SQL Server
• 3.6 Adding Roles and Permissions
• 3.7 Configuring MySQL for Oracle BI
• 3.8 Checking the BI JavaHost Configuration
• 3.9 Enabling Clusters
• 3.10 Enabling Oracle Hardware Acceleration and Compatibility Mode
• 3.11 Setting Compatibility Framework for Oracle BI Server
• 3.12 Migrating the Fusion Middleware MapViewer Configuration
• 3.13 Unchecking "Required for Authentication" Option in DYNAMIC_OLAP_LOGIN Initialization Block
• 3.14 Copying Configuration Files

4 Post Migration Steps for Oracle BI Publisher

• 4.1 Migrating Scheduler Jobs and Job History
• 4.2 Removing the BISystemUser Policy from the JMSResource Security Configuration
  • 4.2.1 Manually Removing the BISystemUser Policy
  • 4.2.2 Removing the BISystemUser Policy using a WLST Script

5 Post Migration Steps for Essbase

A Known Differences: Oracle Business Intelligence 12c

• A.1 SCM: DSO and AR Balance Trend Are Displayed Differently in 12c
• A.2 View Display Error: Invalid Column Encountered in Orders Outstanding Report
• A.3 Visual Cues in BI Composer Appear Same in Regular and Accessibility Mode
• A.4 Enabling Embedded Content in Dashboards
• A.5 Trellis Views Display Without Grid Lines in 12c
• A.6 Domain Home and bipublisher Folder Path Different in 12c
• A.7 Oracle BI EE Content Changes for 12c
• A.8 Changes to Catalog Structure

B Exception Handling

• B.1 Configuration Failure with TRANSFORMBAREXCEPTION
  • B.1.1 Regenerating User GUIDs
  • B.1.2 Updating Oracle Business Intelligence Catalogs
• B.2 Multiple Y-Axis Highcharts Graph is not Displayed After Migration
• B.3 Setting the Evaluate Parameter in the NQSConfig.INI File
• B.4 Error: ava.lang.NoClassDefFoundError: Could not initialize class sun.awt.X11GraphicsEnvironment
• B.5 Verifying File Data Sources in Oracle BI Publisher
• B.6 [nQSError: 46168] Operation RawFile::checkSoftLimit failed
• B.7 Act As Configuration Failing in 12c
• B.8 Custom Link and SampleApp Oracle Technology Network Page Not Visible Post Migration
• B.9 Migrating 11g WebLogic Users to 12c