Skip Headers
Oracle® Fusion Middleware Upgrade Guide for Oracle Business Intelligence
11g Release 1 (11.1.1)

Part Number E16452-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

3 Oracle Business Intelligence for 10g Users

The following sections introduce some key concepts of the Oracle Business Intelligence environment for 10g users.

3.1 Components of the Oracle Business Intelligence

Oracle Business Intelligence includes the following components:

You can install one, two, or all three of these products, using Oracle Business Intelligence Installer. Oracle Business Intelligence Installer creates all the runtime components and the infrastructure for the products you choose to install. After running Oracle Business Intelligence Installer, the installed products share the same Oracle Fusion Middleware infrastructure in a single WebLogic domain.

"Differences between Oracle Business Intelligence 10g and 11g Releases" in the Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence

3.2 Oracle Business Intelligence 11g Installation Types

Oracle Business Intelligence supports the following types of installation:

When installing Oracle BI for upgrade, select Enterprise Installation. The Enterprise Installation type enables you to install Oracle Business Intelligence components for a new 11g enterprise deployment to which you upgrade your 10g data.

What gets installed?

The Enterprise installation type does one of the following, depending on which option you choose during the installation:

Select New installation to install a new Oracle BI 11g deployment for upgrade.

What gets configured?

For a New installation, Oracle Business Intelligence Installer configures the Oracle Business Intelligence components that you select and associates them with the Middleware, Oracle, and WebLogic Server homes that you specify.

3.3 Oracle Business Intelligence 11g Logical Architecture

Figure 3-1 provides the logical architecture for Oracle Business Intelligence after installation.

Figure 3-1 Oracle Business Intelligence Logical Architecture

Description of Figure 3-1 follows
Description of "Figure 3-1 Oracle Business Intelligence Logical Architecture"

3.4 Oracle Business Intelligence and Oracle WebLogic Server

The most significant difference between Oracle Business Intelligence 10g and 11g, is the deployment to Oracle WebLogic Server, and the integration of Oracle Business Intelligence with Oracle Fusion Middleware.

For more information about Oracle Fusion Middleware Components, see Chapter 1, "Introduction to Oracle Fusion Middleware" in the Oracle Fusion Middleware Administrator's Guide.

Oracle WebLogic Server Middleware Home

Oracle Business Intelligence requires a Middleware home with Oracle WebLogic Server on your system. If your system does not already have Oracle WebLogic Server, you can install it in a new Middleware Home directory.

A Middleware home is a container for the Oracle WebLogic Server home, and, optionally, one Oracle Common home and one or more Oracle homes, with a directory structure like this:


The BI Oracle home contains the binary and library files necessary for Oracle BI. BI_ORACLE_HOME represents the BI Oracle home in path names.

The BI Oracle home can be associated with multiple Oracle WebLogic Server domains. The Oracle Common home contains the binary and library files required for Oracle Enterprise Manager 11g Fusion Middleware Control and Java Required Files (JRF).

A Middleware home can reside on a local file system or on a remote shared disk that is accessible through a network file system.

For more information about the structure and contents of a Middleware home, see "Understanding Oracle Fusion Middleware Concepts" in Oracle Fusion Middleware Administrator's Guide.

3.5 Oracle Business Intelligence Directory Structure

A typical Oracle Business Intelligence installation consists of a Fusion Middleware home and the following subdirectories:

Figure 3-2 shows the directory structure of a typical Oracle Fusion Middleware installation on a single host, using all of the default values.

Figure 3-2 Typical Oracle Business Intelligence Directory Structure

Description of Figure 3-2 follows
Description of "Figure 3-2 Typical Oracle Business Intelligence Directory Structure"

3.5.1 Changes to Oracle Business Intelligence Directory Structure

Table 3-1 describes the changes in directory structure from Oracle BI 10g to 11g.

Table 3-1 Oracle BI content changes

Directory or Files 10g Location 11g Location



DBFeatures.INI NQSConfig.INI






NQQuery.log NQSAdminTool.log NQServer.log



Oracle BI Server repository directory:

  • SampleAppLite.rpd

  • paint.rpd




  • order.xml

  • Product.xml

  • samplesales.udml



Usage Tracking:

  • SQL_Server_Time

  • UsageTracking.rpd




Other Schemas (for example):

  • Oracle_alter_nq_acct.sql

  • SAACCT.DB2.sql


  • SAACCT.Oracle.sql

Note: Use the Repository Creation Utility to install the Oracle BI Schema



  • credentialstore.xml

  • instanceconfig.xml (for Presentation Services)

  • userpref_currencies.xml



  • javahost

  • sawlog0.log






instanceconfig.xml (for Oracle BI Scheduler)



  • odbc.ini




3.6 What Gets Upgraded?

This section describes the components that are upgraded by Upgrade Assistant, as well as the security model upgrade path.

3.6.1 Administration Files and Scheduler Schema Upgrade Flow

Figure 3-3 illustrates the Administration files and Scheduler schema components that are upgraded by Upgrade Assistant.

Figure 3-3 10g to 11g Report Catalog Upgrade Flow

Description of Figure 3-3 follows
Description of "Figure 3-3 10g to 11g Report Catalog Upgrade Flow"

3.6.2 Report Catalog Upgrade Flow

Figure 3-4 illustrates the Report Catalog components upgraded by Upgrade Assistant.

Figure 3-4 Report Catalog Upgrade Flow

Description of Figure 3-4 follows
Description of "Figure 3-4 Report Catalog Upgrade Flow"

3.6.3 Security Model Mapping for Oracle BI Publisher Upgrade

The following table shows security model mapping for an Oracle BI Publisher upgrade.

Table 3-2 Oracle BI Publisher Security Model Flow

10g Security Model 11g Security Model

BI Publisher

BI Publisher

BI Server

BI Server





Siebel Security

Siebel Security

E-Business Suite Security

E-Business Suite Security

Shared Services Security

Default (Oracle Fusion Middleware)

3.7 Comparing the Oracle Business Intelligence 10g and 11g Security Models

The security policy for Oracle Business Intelligence 11g defines what individual users and users with certain application roles can access and do. In Oracle Business Intelligence 11g, the security policy definition is split across the following:

Oracle Business Intelligence10g and 11g security models differ in the following areas:

The following aspects of the Oracle Business Intelligence 10g security model remain in 11g:

For more information about Oracle Business Intelligence security, see the Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition.