Oracle Business Intelligence Enterprise Edition(OBIEE) 11g Installation


Below screenshots will guide you through step by step installation of OBIEE 11 g Fusion Middleware product .Before start the setup make sure Oracle 11g database installed and RCU setup completed.

Step 1: Download OBIEE 11g (11.1.1.3.0) version from below link of OTN .

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/business-intelligence11g-240521.html

Prerequisite has been installed as  : Oracle 11g DB R2 and RCU 11.1.13.3 .

Now extract the download copy into two different folders ….

Merge the two folders content into single directory “..\bi_windows_x86_111130_32_disk1_1of2\bishiphome” .

Step 2: For DHCP computer having no permanent IP Address you need to configure Microsoft default Loopback address .Follow the steps provided under section “Installing a Loopback Adapter on Windows 2003 or Windows XP”  from Nicolas Loopback Adapter Configuration .The glimpse of it as below:

Step 3: Execute the setup.exe .

Oracle Universal Installer (OUI) pre-requisite verification started .

Then the OFMW 11g Installer template initiated.

Step 4: Click Next on Welcome screen appeared below.

Step 5: Select the “Installation Type” as ‘Simple’ .This is most easiest and recommended for first try .All the parameters will be set by default.

N.B:- Enterprise installation is mostly required in Scalable system having the configuration required across multiple Weblogic domain or joining a existing domain to existing Weblogic Server .The “Software Only Install” requires the configuration done in different phase after the enterprise wide installation is over .

Step 6: Pre-requisites check has been done .

Step 7: Specify the installation location .

Step 8: Enter the ‘Weblogic’ Admin credentials . In my case the password is : ‘weblogic#1’ (without quotes to meet Oracle Password standard) .

Step 9: Configuring the components . In my case I select all .

Step 10: Specify the connection parameters ..

N.B:- Be aware of the joker type error message thrown here during my first installation as “INST-08029 Unable to connect to Database with given credentials.” It seems to be an Oracle BUG .See the issue in screenshot .



The reason of this error is the BIPLATFORM schema password .In RCU utility if you provide the password same as Schema name it would be creating trouble. Not sure whether it doesn’t accept the same password or it doesn’t accept the underscore(‘_’) character .I have not investigate further on it 😦

Anyway I get rid of it after dropping the RCU schema for BI and recreate the same with password as ‘rcu’ .This password has been provided here .

Step 11: Specify security update section .

Step 12: Finalise the installation .

The installation started …..

After installation done the configuration Process starts …

Step 13: The installation and configuration completed .Click Finish .

So finally OBIEE11g has been installed successfully with the below access details for different application :


Type: Simple Install
Installation Details
Middleware Home: E:\OraFMW11g
BI Oracle Home: E:\OraFMW11g\Oracle_BI1
WebLogic Server Home: E:\OraFMW11g\wlserver_10.3
BI Domain Home: E:\OraFMW11g\user_projects\domains\bifoundation_domain
BI Domain Name: bifoundation_domain
Instance Home: E:\OraFMW11g\instances\instance1
Instance Name: instance1
Configure Components
WebLogic Console
http://deba:7001/console
Oracle Enterprise Manager
http://deba:7001/em
Business Intelligence Enterprise Edition
http://deba:9704/analytics
Business Intelligence Publisher
http://deba:9704/xmlpserver
Real-Time Decisions
http://deba:9704/ui

Step 14: After the installation concludes , Weblogic Server and BI Server started , IE browser window opens automatically with the homepage of Oracle Business Intelligence instance .Logging in using the weblogic server User name and password given at Step 8 .

Voici … OBIEE11g installation has been completed successfully .

OBIEE 11g – A Gospel about Whirlpool in BI Space


Looking about Oracle’s magnanimity in BI area specially in promoting OBIEE in there business in such of magnitudal unanimity which will must going to be heartthrob for most of the companies after the next major release of OBIEE 11g . So far the information I can collate is that , there are hell lot of improvements from look and feel & user navigation perpective , lot of functional and behavioral improvements , tons of new features and enhancements will be on your way !

Be prepare for grabing this all…. ! Just wait…till no date has been finalised by Oracle as they release 10.1.3.4.1 on Apr2009 and target date for new release is 12 months after that .  So lets hope for the grandeur  !!! However they are promoting some beta version conference presentations to some clients .. really special one !

The preface can be briefly elucidate from couple of OBIEE screenshots that I managed to get from a Oracle presentation …

Answers + Key Features

OBIEE11g

OBIEE11g-2

•Hierarchy / Member Browsing

OBIEE11g-3

 

•Dimensional Columns in Pivot Tables

 

•Outline Total Drilling

 

•Custom Groups – Results

OBIEE11g-4

 

•Member Selection (Query Steps) & Calculated Items

OBIEE11g-6OBIEE11g-6

OBIEE11g-7

 

•Modular Workspace

In addition to that : “Essbase as Performance Accelerator for OBIEE and OBI Apps Available with OBIEE 11g” . A sound aggregation strategy can
transparently improve end-user query performance by many orders of magnitude .A Fully Integrated Scorecardingin BI EE 11g Leverage Key Platform Strengths ,Best In Class Functionality(Dimensional KPIs ,Strategy maps, Cause & Effect,
Strategy Trees, Watchlists) , Seamless Navigation to Rich BI Services (Interactive Tables, Crosstabs, Charts,Alerting, Notification, Workflow)

1) Great Look & Feel

2) New Oracle Graph rendering engine

3) Improved and Enhanced Report indexing or Report search facilities.

4) Searching meta data

5) Better work with Multi-dimensional data (like Essbase) .

And finally all in nutshell as below :

OBIEE11g-13 OBIEE11g-14