Middleware Upgrade Assistant, you need to
ensure that the TNSNAMES file within the
[middleware_home]\Oracle_BI1\network\
admin directory on your new server includes
entries that correspond with the database
connect strings referenced in the upgraded
repository. For now, though, let’s first use the
Oracle Business Intelligence Administration
Tool to view the upgraded repository.
From your Microsoft Windows Start
1.
menu, select Start -> Programs ->
Oracle Business Intelligence -> BI
Administration.
When the Oracle Business Intelligence
2.
Administration Tool opens, select File ->
Open -> Online and enter the following
details when prompted:
Repository Password: <the repository
password you entered earlier>
User: <your Oracle WebLogic Server
administration username>
Password: <your Oracle WebLogic
Server administration password>
Figure 3: An Oracle Business Intelligence pivot table
update the variable initializer to reflect
the path detailed above, without the
additional (new) directories. For example
With the information entered, click Open
to open the repository online. You will then
see your upgraded business intelligence
repository within the Oracle Business
Intelligence Administration Tool.
'C:\Middleware\instances\
instance1\bifoundation\
OracleBIServerComponent\
coreapplication_obis1'
tion username and password, and then select
Dashboards -> Sample Sales -> 02 History
and Benching. You will see one of the Sample
Sales dashboards running within an Oracle
Business Intelligence Enterprise Edition 11 g
environment, as shown in Figure 2.
%MIDDLEWARE_HOME\instances\
instance1\bifoundation\
OracleBIServerComponent\
coreapplication_obis1\server\
Sample
Then, using the Oracle Business
Intelligence Administration Tool, select
Manage -> Variables and locate the
BIEE_HOME static repository vari-
able. Double-click it to show the Static
Repository Variable properties page, and
Select File -> Save to save your repository,
and run the consistency checker.
AFTER THE UPGRADE
Although the Oracle Fusion Middleware
Upgrade Assistant upgrades your metadata,
any configuration changes you applied to
your Oracle Business Intelligence Enterprise
Edition 10g environment that you want to
reapply to your Oracle Business Intelligence
Enterprise Edition 11 g environment will need
to be applied manually with Oracle Enterprise
Manager Fusion Middleware Control. For
example, you may want to enable or disable
query caching or add more instances of Oracle
Business Intelligence Server or other system
components to scale up or scale out your
installation. Also, some configuration changes
require you to manually edit the Oracle
Business Intelligence Server NQSConfig. INI
and Oracle Business Intelligence Presentation
Server InstanceConfig. XML configuration files. Check Oracle Fusion Middleware
Upgrade Guide for Oracle Business Intelligence
11g Release 1 ( 11. 1. 1) for those business intelligence components that are not upgraded
by the Oracle Fusion Middleware Upgrade
Assistant, including CSS and other user inter-
