Installing and Configuring Oracle BI Applications 11.1.1.7.1

In this example, we will install Oracle BI Applications 11.1.1.7.1 into a fresh Microsoft Windows 7 environment that has access to an Oracle 11g R2 (11.2.0.3+) database to hold the various repository schema and the BI Applications data warehouse.

Installation Prerequisites

For full details of the platform and software pre-requisites for Oracle Business Intelligence Applications 11.1.1.7.1, see the System Requirements and Supported Platforms for Oracle Business Intelligence Applications Release 11.1.1.7.x document on OTN, currently located at http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

For the purposes of this article, you will need access the following system requirements:

·         8 GB RAM

·         300 GB HDD

Note that the examples in this article assume that you have given this environment the host name Sagar-PC, so if you can change the host-name to this, it will make the examples easier for you to follow.

Note: Make you IP Address static:
Configure the Windows environment to use the Microsoft Loopback / Network adapter to set your IP static, and edit the "hosts" file to resolve the machine name to the loop-back adapter's IP address by following these steps.

Refer the following fig. to configure your IP.
1. Go to the path, C:\Windows\System32\drivers\etc where the host file is located. Edit this hosts file  as below.

(If you got the error saying, Please check if this file is opened in another program.
Change the file permissions. Allow read, write, execute access to the your you are currently logged in.)

2. Finally, test that these new network settings work as expected by selecting Start > Command Prompt, then typing ping [machine name], so that the output looks like this:

Downloading Oracle BI Applications 11.1.1.7.1 Software.
We're now ready to install the software for your Oracle BI Applications 11.1.1.7.1 development environment. Before you start, make sure you have downloaded the following items from the Oracle Technology Network website, in this example all for the Windows Server 64-bit platform:

• Oracle 11gR2 (11.2.0.3+) database

• Oracle Fusion Middleware Repository Creation Utility 11.1.1.7
http://download.oracle.com/otn/nt/middleware/11g/111170/ofm_rcu_win_11.1.1.7.0_64_disk1_1of1.zip

• Oracle Business Intelligence 11.1.1.7
http://download.oracle.com/otn/nt/bi/111170/bi_windows_x86_111170_64_disk1_1of2.zip
http://download.oracle.com/otn/nt/bi/111170/bi_windows_x86_111170_64_disk1_2of2.zip
http://download.oracle.com/otn/nt/bi/111170/bi_windows_x86_111170_64_disk2_1of2.zip
http://download.oracle.com/otn/nt/bi/111170/bi_windows_x86_111170_64_disk2_2of2.zip

• Oracle Business Intelligence Applications Repository Creation Utility 11.1.1.7.1
http://download.oracle.com/otn/nt/bi/111171/Bus_Analytics_Apps_Suite_RCU_Win64.zip

• Oracle Business Intelligence Applications Disk 1
http://download.oracle.com/otn/nt/bi/111171/Bus_Analytics_Apps_Suite_Installer_11.1.1.7.1.zip

• Oracle Fusion Middleware Platform Patches for Oracle Business Intelligence Applications
http://download.oracle.com/otn/nt/bi/111171/BI_Apps_11.1.1.7.1_generic_part_1of2.zip
http://download.oracle.com/otn/nt/bi/111171/BI_Apps_11.1.1.7.1_generic_part_2of2.zip
http://download.oracle.com/otn/nt/bi/111171/BI_Apss_11.1.1.7.1_win64.zip

• Oracle Data Integrator 11gR1 (11.1.1.7.0) http://download.oracle.com/otn/nt/middleware/11g/111170/ofm_odi_generic_11.1.1.7.0_disk1_1of2.zip
http://download.oracle.com/otn/nt/middleware/11g/111170/ofm_odi_generic_11.1.1.7.0_disk1_2of2.zip

Also, part of the installation process will require you to upgrade Oracle WebLogic Server from version 10.3.5 to 10.3.6, and to do this you will need to download the upgrade installer for WebLogic Server 10.3.6 from My Oracle Support, by loading download patch no. 13529623 and following article 1421307.1, to give you a file called wls1036_upgrade_generic.jar.

Once you have downloaded all of these installer and patch files, create a directory called E:\OBIA_Installers in your Windows environment and copy all of them to this new directory, so that the contents it look similar to the directory listing below (note that file names and sizes may change as Oracle release updated versions of the installers and patches).

Finally, you will also need to download the 7-zip archive utility, to use during the patching process for Oracle Business Intelligence applications, which you can download for free from http://7-zip.org/.  Make sure that, your are downloading setup for your Windows x64 bit box, it's mandatory that you install 64 bit version of 7 Zip utility.

Now that you have downloaded the software and patch files, we can start the actual installation process. In the following steps, we're assuming that you are already familiar with the installation process for Oracle Business Intelligence 11g, and the setup of the various repository schema using Oracle Fusion Middleware Repository Creation Utility 11g, and therefore we will only provide the key settings that you need to select when installing these products. For those products that are likely to be new to you with Oracle Business Intelligence 11.1.1.7, we will provide step-by-step instructions for their installation and configuration.

1. Installing Oracle Database 11.2.0.3+ with the following settings:

• System Class : Server Class
• Grid Installation Options : Single instance database installation
• Select Install Type : Advanced Install
• Select Database Edition : Enterprise Edition
• Select Configuration Type : Data Warehousing
• Specify Configuration Options : Character Sets > Use Unicode (AL32UTF8)
• Specify Configuration Options : Security > Uncheck Assert all new security settings
• Specify Schema Passwords : Use the same password for all accounts ("Welcome1")

Note that in this initial, 11.1.1.7.1 release of Oracle BI Applications with Oracle Data Integrator 11g support, only source systems running on Oracle Database are supported, and Oracle Fusion Applications are not yet supported as a source. In addition, only Oracle Database is supported as a target, with these restrictions likely to be lifted in a future release.

2. Repository Creation Utility for OBIEE 11.1.1.7.0:

Start by unzipping the Oracle Fusion Middleware Repository Creation Utility installer, and starte the Repository Creation Utility (RCU) installer, like this:

• unzip ofm_rcu_win_11.1.1.7.0_64_disk1_1of1
• go to Installers\OBIEE_11.1.1.7.0\RCU\rcuHome\BIN path
• double click on rcu.bat file.

Then choose the following options when running the RCU:

• Create a new repository
• Database Type: Oracle Database
• Host Name: Sagar-PC
• Port: 1521
• Service Name: orcl
• Username: Sys
• Password: Welcome1
• Role: SYSDBA
• Repository schema prefix: DEV_
• At the Select Components screen, select Oracle Business Intelligence so that the Business Intelligence Platform, and the Metadata Services options are pre-selected for you, as per the following fig.
  
  
  

• Do not select Oracle Data Integrator as a second Oracle BI Applications 11.1.1.7.1-specific Repository Creation Utility will do that for you later on.

• When prompted at the end of the process, select Use same passwords for all schema and use "Welcome1" as the password.

3. Install Oracle Business Intelligence 11g 11.1.1.7.1

Next, unzip the Oracle Business Intelligence 11g 11.1.1.7 installer files and start the installer, like this:

bi_windows_x86_111170_64_disk1_1of2

bi_windows_x86_111170_64_disk1_2of2

bi_windows_x86_111170_64_disk2_1of2

bi_windows_x86_111170_64_disk2_2of2

Go to Installers\OBIEE_11.1.1.7.0\bishiphome\Disk1

Double click on setup.exe file.

Then, install Oracle Business Intelligence using the following main options, leaving other installation choices at their default value:

• Installation Type: Enterprise Install
  
  
  
  
  
  
  
• Create New BI System. Give credentials as, weblogic/Welcome1
  
  
  
  
• Middleware Home: c:\Middleware
  
  
  
  
• Choose all products for installation, including Essbase.
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  

4. Install Oracle Data Integrator 11.1.1.7.0

Now you should install Oracle Data Integrator 11g, making sure that you DO NOT choose the option to configure repositories, as a later stage in the configuration process will do this for you.

ofm_odi_generic_11.1.1.7.0_disk1_1of2

ofm_odi_generic_11.1.1.7.0_disk1_2of2

• Open command prompt,
• Go to Installers\ODI_11.1.1.7.0\Disk1
• setup.exe -jreLoc C:\Java\jdk1.6.0_45

• On the Select Installation Type page, tick the Developer Installation check-box and both of its options, and the Java EE installation check-box and both of its options. 
• Then, at the Specify Installation Location screen, select the same Middleware home that you used for Oracle Business Intelligence (for example, C:\Middleware). 
• Finally, as mentioned previously, at the Repository Configuration page select Skip Repository Configuration.

5. Repository Creation Utility for OBIA 11.1.1.7.1:

The next step in this installation process is to use an additional, special version of the Repository Creation Utility to create the additional repository and other schema used by Oracle BI Applications 11.1.1.7.1.

Start by unzipping and then running the Oracle BI Applications Repository Creation Utility installer, like this:

• unzip Bus_Analytics_Apps_Suite_RCU_Win64
• go to installers\RCU\rcuHome\BIN path
• double click on rcu.bat file.

Then choose the following options when running the RCU:

• Database Type: Oracle Database
• Host Name: Sagar-PC
• Port: 1521
• Service name: orcl
• Username: Sys
• Password: Welcome1
• Role: SYSDBA

At the Select Components page as shown in Figure 4, check the Oracle Business Intelligence Applications checkbox and its options, and use the following (default) repository schema names:

Oracle Business Analytics Warehouse : DEV_DW

Oracle Business Intelligence Applications Components : DEV_BIACOMP

Oracle Data Integration Master and Work Repositories : DEV_BIA_ODIREPO

The Map Tablespaces screen displays the default and temporary tablespaces for the schema. On this screen, do the following:

1. Leave the default values for Default Tablespace and Temp Tablespace for each schema.
2. Set the temporary tablespace size for the data warehouse tablespaces according to the values in the table below:

• Click Manage Tablespaces.
• In the left-side navigation panel, select the appropriate tablespace name.
• In the main window, select the tablespace name under the data file heading.
• Click the Edit icon to display the data file dialog.
• In the Edit data file dialog, set the temporary tablespace size according to the table below:

• Click OK to exit the Edit Datafile dialog. 
• Then, click Next in the Map Tablespaces screen, and click OK in the message dialog to create the tablespaces for the schemas.
• When prompted to set passwords for these schema, use the option to use the same password for all schema, setting it to "Welcome1".
• At the Custom Variables page shown in fig below, enter the same value below for the three database export file locations:
  C:\installers\biappsrcu\rcu\integration\biapps\schema
• Once you have entered these details, creation of the relevant tablespaces and schema along with importing of the schema' database objects, usually takes around fifteen minutes or so. Once complete, you are now ready to install the Oracle Business Intelligence Applications software.

5. Install Oracle Business Intelligence Applications 11g 11.1.1.7.0

To unzip the installer files for Oracle Business Intelligence Applications and then run the installer, run the following from the Windows Command Prompt:

unzip Bus_Analytics_Apps_Suite_Installer_11.1.1.7.1

• Open comman prompt,
• Go to Installers\obia\Disk1
• setup.exe -jreLoc C:\Java\jdk1.6.0_45
• At the Specify Installation Location dialog, select the existing middleware home (C:\Middleware), and change the Oracle Home Directory value from the default Oracle_BI2 back to the existing one used by the previous Oracle Business Intelligence install, Oracle_BI1.
  
• Once done, press Install to start the installation process.

6. Apply patches

The previous step installed the Oracle Business Intelligence Applications software, and now you need to apply various patches to it and the other components you installed earlier on. Oracle have supplied a script that uses the 7-zip archive utility you downloaded earlier on to apply the patches, and this script uses a parameter file that allows you to specify where the patch files are located. 

Before you start the patching process though, shut down all of your BI-related products by selecting Start > All Programs > Oracle Business Intelligence > Stop BI Services, and use the Windows Services applet to stop the Node Manager and Oracle Process Manager services, if they are running.

(Note: I personally suggest, restart your system to completely shut down BI process and then stop the Node Manager and Oracle Process Manager services)

• MS Windows is having so many issues with file permissions, and this step will write a log to the file located in C:\Program Files\Oracle\Inventory\logs. 
• For that, please give read-write-execute permission to Inventory folder.
• Set both environmental variables (User variable and System variable) and Restart your system. 
  ORACLE_HOME= C:\Middleware\Oracle_BI1
  (You will delete both of this variables after this patching process.)
• Create one temporary folder having read-write permission. Patching process will use this folder to save extracted files.

Then, with the same text editor application, open the APPLY_PATCHES.pl file in the same directory and modify the following lines within the download_patch routine, from the default:

$DOWNLOAD_EXE = "\"C:${DIRSEP}Program Files${DIRSEP}WinZip${DIRSEP}wzunzip.exe\" -ybc -d";

$cmd = "$DOWNLOAD_EXE $_[0] $PATCHES_HOME";

So that it now reads:

$DOWNLOAD_EXE = "\"C:${DIRSEP}Program Files${DIRSEP}7-Zip${DIRSEP}7z.exe\"";

$cmd = "$DOWNLOAD_EXE x $_[0] -o$PATCHES_HOME";

Then, from the Windows Command prompt type in the following to run the patch installer script:

• Open command prompt,
• Go to cd C:\Middleware\Oracle_BI1\perl\bin 
• perl.exe C:\Middleware\Oracle_BI1\biapps\tools \bin\APPLY_PATCHES.pl C:\Middleware\Oracle_BI1\biapps\tools\bin\apply_patches_import.txt

Once the script completes, check the resulting output which should look similar to this:

----------START OF PATCHING REPORT------------------

* BIAPPSSHIPHOME Patching Report ..........

Patch Succeded: fsclite_rel7mlr2_16424872.zip

Patch Succeded: BISHIPHOME_11_1_1_7_0_GENERIC_130409_1210_16492220.zip

Patch Succeded: atglite_rel7mlr5A_database_16239380.zip

Patch Succeded: atglite_rel7mlr5_16480022.zip

Patch Succeded: fsmlitedb_rel7mlr2_16424869.zip

Patch Succeded: fsmlite_rel7mlr2_16424870.zip

Patch Succeded: BISERVER_11_1_1_7_0_WINDOWS_X64_130326_2045_4_16583998.zip

Patch Succeded: BIFNDN_11_1_1_7_0_WINDOWS_X64_130322_1000_5_16462147.zip

* Oracle Common Patching Report ..........

Patch Succeded: p16433147_111170_Generic.zip

Patch Succeded: p16080773_111170_Generic.zip

Patch Succeded: Webservices_Patch-3-PS6RC3_bug-16487786.zip

Patch Succeded: p16433036_111170_Generic.zip

Patch Succeded: JDEVADF_REL7MLR10-RT_16525527.zip

Patch Succeded: WebCenter_BP1REL7RC3_16311963.zip

Patch Succeded: fmw_diagnostics_14757820_2.zip

Patch Succeded: SOACOMMON_REL7B8_16438735.zip

* SOA Patching Report ..........

 Not applying SOA Patches since SOA Home (SOA_HOME) value is not specified

* ODI Patching Report ..........

Patch Succeded: p16629917_111170_Generic.zip

* Weblogic Patching Report ..........

----------END OF PATCHING REPORT------------------

Note that, no Weblogic patches will be applied in this step, as they only apply to WebLogic Server 10.3.6 (to which you will upgrade later on in this process) and Oracle no longer require these patches to be applied.

• Delete the environmental variables  for ORACLE_HOME created before this step.
• Restart your system.

7. configApps.bat process

The penultimate step in the installation process is to use the Configuration Utility to extend the Oracle BI Domain to include the new Oracle BI Applications Java components, and add an additional WebLogic Server managed server for the Oracle Data Integrator Java components. Before you do this though, make sure that the Node Manager and Oracle Process Manager services are started, and you have restarted your Oracle Business Intelligence installation using Start > All Programs > Oracle Business Intelligence > Start BI Services.

To start the Configuration Utility, type in the following commands at the Windows command prompt:

• cd c:\Middleware\Oracle_BI1\bin
• configApps.bat

When the Configuration Utility starts:

At the Extend BI Domain page enter the following values:

• Hostname: [pre-completed for you]
• Port: 7001
• User Name: weblogic
• User Password: Welcome1

At the Configure Components page, check the BI Application Components check-box, and press Next, as shown.

At the RPD Encryption Password page, enter Admin123 as the password. 

At the BI Applications Administration User page, type in the following values, to create an administration user called "biadmin" that you will use later on in the second-half of this article.

At the MDS Schema page, enter the following values

At the BI Applications Components Repository Schema page, enter the following values:

At the Business Analytics Warehouse Schema page, enter these values:

At the BI Applications ODI Repository Schema page:

Once values for these settings have been provided, the configuration process will start, as shown in Figure below. Allow this process to complete and check that all steps have completed successfully before proceeding further.

Stop your BI Services and simply restart your system.

8. Upgrade Weblogic from 10.3.5 to 10.3.6

As Oracle Business Intelligence 11.1.1.7 comes with version 10.3.5 of Oracle WebLogic Server, you will now have to upgrade it to version 10.3.6 using the upgrade installer you obtained previously from My Oracle Support.

Before you do this though, start by shutting-down WebLogic Server and the various Oracle Business Intelligence system components by selecting Start > All Programs > Oracle Business Intelligence > Stop BI Services from the Windows Start menu, entering the WebLogic administration username and password you specified earlier (weblogic/Welcome1) when requested. Then, using the Windows Services utility, stop the Oracle WebLogic NodeManager (c_Middleware_wlserver_10.3) service.

Unzip the upgrade installer patch file and start the installer like this:

• open command prompt,
• cd C:\Java\jdk1.6.0_45
• java -jar installers\wls1036_upgrade_generic.jar
• Middleware Home Directory: Use an existing Middleware Home (c:\Middleware)
• Products and Components: Select everything

Then, press Next until the upgrade starts. Ensure it completes successfully, and un-tick the "run quickstart" check-box before exiting the upgrade installer.

Restart your system.

9. Post Installation Steps:

Start your BI services. Open your EM at http://Sagar-PC:7001/em and check whether all the services are up and running.

A number of post-installation steps now have to be performed, starting by configuring Oracle Data Integrator to use Fusion Middleware rather than standalone security.

To perform this security configuration, run the following commands from the Windows command prompt:

• cd c:\Middleware\Oracle_BI1\common\bin
• wlst.cmd c:\Middleware\Oracle_BI1\bifoundation\install\createJPSArtifactsODI.py embedded --ADMIN_USER_NAME weblogic --DOMAIN_HOSTNAME Sagar-PC --DOMAIN_PORT 7001 --DOMAIN_HOME_PATH c:\Middleware\user_projects\domains\bifoundation_domain

When prompted, enter welcome1 as the password for the WebLogic Server administration user.

Then, issue the following command-line commands to copy across the wallet files created by the above steps to where Oracle Data Integrator is installed:

• copy c:\Middleware\user_projects\domains\bifoundation_domain\odi-client-config\embedded\cwallet.sso c:\Middleware\Oracle_ODI1\oracledi\client\odi\bin\

• copy c:\Middleware\user_projects\domains\bifoundation_domain\odi-client-config\embedded\jps-config-jse.xml c:\Middleware\Oracle_ODI1\oracledi\client\odi\bin\

Then, using a text editor edit the c:\Middleware\Oracle_ODI1\oracledi\client\odi\bin\odi.conf document and replace the line:

AddVMOption -Doracle.security.jps.config=./jps-config.xml

with the text:

AddVMOption -Doracle.security.jps.config=./jps-config-jse.xml

So that the new wallet file is used when authenticating from Oracle Data Integrator Studio.

Then, install the Load Plan Generator plug-in for Oracle Data Integrator by unzipping the plugin archive file, and then copying the plugin files to the Oracle Data Integrator Studio client installation.

• unzip C:\Middleware\Oracle_BI1\clients\biappsclients\odi

• copy lpggui.jar :\Middleware\Oracle_ODI1\oracledi\client\ide\extensions

• xcopy c:\Middleware\Oracle_BI1\clients\biappsclients\odi\* c:\Middleware\Oracle_ODI1\oracledi\client\ide\extensions /s /i /e

• del c:\Middleware\Oracle_ODI1\oracledi\client\ide\extensions\OBIA_LPG_Plugin.zip

• del c:\Middleware\Oracle_ODI1\oracledi\client\ide\extensions\Readme.txt

Almost there.!! There are just a few more patches to apply, and a new version of the Oracle BI Administrator application to install into your Windows environment.

Begin by stopping your Oracle Business Intelligence installation, by selecting Start > All programs > Oracle Business Intelligence > Stop BI Services

Then run the following SQL script to update the Oracle ATG repository data:

• c:\Middleware\instances\instance1\bin>sqlplus
  dev_biacomp/Welcome1
  @C:\Middleware\Oracle_BI1\sdf\DW\ATGPF\sql\fndtbs_11170_upg.sql

I'm skipping the installation steps for updated version of the Oracle BI Administration tool as this is not mandatory.

The installation process also imported some files that the data loading process later on will require. To place these files in the correct location, again from the command prompt enter the following commands:

• Mkdir c:\Middleware\Oracle_ODI1\oracledi\etl
• xcopy c:\Middleware\Oracle_BI1\biapps\etl c:\Middleware\Oracle_ODI1\oracledi\etl /s /i /e

10. Test your installation

• Delete temp, %temp%, prefetch data from your windows directories.
• Restart your system.
• Start BI services.
• Check whether all the services are started successfully except odi_server1.

Finally, to try out Oracle Data Integrator Studio and set up a login connection, select Start > All Programs > Oracle > Oracle Data Integrator > ODI Studio. 

• Click on the Connect to Repository link, 
• When the Oracle Data Integrator log in dialog is shown, press the "+" (New) button to bring up the Repository Connection Information dialog. 
• Enter the following details to create the connection:
  

Once you've created this connection and used it to log into Oracle Data Integrator Studio successfully, click on the BI Apps Project > Mappings folder, and then you'll see the pre-built data loading routines that you use to load the Oracle Business Analytics Data Warehouse, as shown in Figure 8. Congratulations! You have now performed the install part of the process.

References:

http://www.oracle.com/technetwork/articles/bi/mcginley-bi-apps-1993643.html

http://docs.oracle.com/cd/E38317_01/doc.11117/e35981/install.htm#

Note: I just followed the links mentioned above and added some few new step.

OBIEE 11g (11.1.1.7.0) Step By Step Installation on Windows x86_64

In the previous post I have posted the steps RCU installation. We can take this as a continuation of that post. Please follow all the prerequisites before going to Install BI 11g system.

Note that the examples in this article assume that you have given this environment the host name Sagar-PC, so if you can change the host-name to this, it will make the examples easier for you to follow.

Note: Make you IP Address static:
Configure the Windows environment to use the Microsoft Loopback / Network adapter to set your IP static, and edit the "hosts" file to resolve the machine name to the loop-back adapter's IP address by following these steps.

If you don't know how to install and configure Microsoft Loopback adapter, refer this link.
Installing Microsoft Loopback Adapter on Windows 7 machine

After this step, simply restart your system to reflect your changes. (Mandatory)

Download the OBIEE 11g (11.1.1.7.0) from Oracle eDelivery or from the below link:

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1923016.html

If you have not done already, please download BI 11g installation files. Please make sure all the zipped files have downloaded correctly and unzipped into a single folder. Make sure that, no spaces are there in the folder path where setup files are located. For this practice, the path is "E:\OBIEE-11.1.1.7.0\OBIEE\bishiphome".

From unzipped folder for OBIEE installer, go to Disk1 and start the installation by double clicking on setup.exe to launch Oracle Universal Installer. OBIEE 11g is also just like other Oracle products, uses standardized Universal Installer.

Oracle Universal Installer will be launched and It will come to the first step screen.

Step 1. Oracle Universal Installer will start the OBIEE 11g setup screen. Click 'Next' with the below screen.

Step 2. In this step we have to select Software Updates option. If We are having oracle support id then we can select second option or if you are having update files in any directory we can go with third option. I have selected 'Skip Software Updates' and clicked 'Next'.

Step 3. We will use Enterprise Installation type so that we can take the full advantage of  OBIEE 11g components and the Installer will install and configure all the required components with default settings. Make sure to select 'Enterprise Install' and click 'Next' to continue.

Step 4. 'Next' to continue the installation once the prerequisite is checked wit this screen.

Step 5. In this step, we are creating 'New BI System'. Select second option if you want the scale out the existing BI System.
User Name: weblogic
User Password: Password123
Conf Password: Password123
Give the above credentials in the boxes of below screen and click 'Next' to continue the installation.

Step 6. Create an empty folder in any of the driver where you want to install the BI System and select that folder with the below screen to create BI System folder in it. Here, just provide location for 'Oracle Middleware Home Location', it will automatically create various folders within the provided location.

Just click 'Yes' to the following warning.

Step 7. Select the appropriate components from the available options. (If you are planning to install 'Oracle Business Intelligence Applications' (OBIA) also, then you must select the following four options.)

Step 8.  In this step we have to give the details of RCU schemas. Select appropriate database type and give all other details to go to next screen. I have installed RCU in Oracle Database.
So the detail is like below:

          Database Type: Oracle Database
          Connection string: localhost:1521:orcl
          BIPLATFORM Schema: DEV_BIPLATFORM
          BIPLATFORM Password: password
               
               (* This is the password you have set while installing RCU.
                    Make sure, your database is open and started.)
                 
Give the above mentioned details with the below screen and Click 'Next'.

Step 9.  This step is same like above step but we have to give MDS Schema details.

           Database Type: Oracle Database
           Connection string: localhost:1521:orcl
           BIPLATFORM Schema: DEV_MDS
           BIPLATFORM Password: password

Give the above mentioned details with the below screen and Click 'Next'.

Note: If you had selected the options for 'Use same Passwords for all schemas' while creating RCU, then it will automatically import all this information for the DEV_MDS schema.

Step 10. If you are installing BI in your machine first time and do not have any BI system before this, then Select first option 'Auto Port configuration' and Click 'Next'

But if you are having any other OBIEE versions running on same machine, then, to avoid the port number conflict select second option 'Specify Ports using Configuration file'.

Here, I have installed with the default port numbers.

Step 11. In this step It will ask for an email address for security updates.

Deselected check box from My oracle support, so It will give small screen which will ask for confirmation.
Click Yes.

Step 12. This step will give the overview of BI system which is going to create. If you want, Click 'Save' Button and save the details in a text file and store it for future purpose. After that click 'Install'.

Step 13. This step will copy and Install all the necessary files from source folder into BI folder.

After the successful 100% installation progress with the above step, It will come to this step automatically for configuration of all those components.

Step 14. Click 'Next' with this step after the configuration is 100% complete.

Step 15. After the successful completion of above step we are coming to final step of OBIEE 11g installation. Click 'Finish'.

With the above step the installation of  OBIEE 11g is  completed.
Go to Start -> All Programs -> Oracle BI Intelligence -> Start BI Services.

Open any browser and type: 'http://machine_name:9704/analytics' to play with Oracle Answers and Dashboard.

Enter the credentials as what we installed at the time of installations.

In this practice, Username: weblogic
                        Password: Password123

Now we are ready to play with BI 11g system.

Success factors of implementation..

Before implementing a BI solution, it is worth taking different factors into consideration before proceeding. According to Kimball et al., these are the three critical areas that you need to assess within your organization before getting ready to do a BI project:

1. The level of commitment and sponsorship of the project from senior management
2. The level of business need for creating a BI implementation.
3. The amount and quality of business data available. 

Business sponsorship:

The commitment and sponsorship of senior management is according to Kimball, the most important criteria for assessment. This is because having strong management backing helps overcome shortcomings elsewhere in the project. However, as Kimball state: “even the most elegantly designed DW/BI system cannot overcome a lack of business [management] sponsorship”.

It is important that management personnel who participate in the project have a vision and an idea of the benefits and drawbacks of implementing a BI system.

Business needs:

Because of the close relationship with senior management, another critical thing that must be assessed before the project begins is whether or not there is a business need and whether there is a clear business benefit by doing the implementation. The needs and benefits of the implementation are sometimes driven by competition and the need to gain an advantage in the market.

Companies that implement BI are often large, multinational organizations with diverse subsidiaries. A well-designed BI solution provides a consolidated view of key business data not available anywhere else in the organization, giving management visibility and control over measures that otherwise would not exist. 

Amount and quality of available data:

Without good data, it does not matter how good the management sponsorship or business-driven motivation is. Without proper data, or with too little quality data, any BI implementation fails. Before implementation it is a good idea to do data profiling. This analysis identifies the “content, consistency and structure of the data. This should be done as early as possible in the process and if the analysis shows that data is lacking, put the project on the shelf temporarily while the IT department figures out how to properly collect data.

These essential steps of business intelligence includes but not limited to:

1. Go through business data sources in order to collect needed data.
2. Convert business data to information and present appropriately.
3. Query and analyze data.
4. Act on those data collected.

User aspect:

When gathering the requirements from the business users, the local IT department should also be consulted in order to determine to which degree it is possible to fulfill the business's needs based on the available data. 

Taking on a user-centered approach throughout the design and development stage may further increase the chance of rapid user adoption of the BI system.

BI chances of success can be improved by involving senior management to help make BI a part of the organizational culture, and by providing the users with necessary tools, training, and support.

Training encourages more people to use the BI application.

BI Portals:

A Business Intelligence portal (BI portal) is the primary access interface for Data Warehouse (DW) and Business Intelligence (BI) applications. The BI portal is the users first impression of the DW/BI system. It is typically a browser application, from which the user has access to all the individual services of the DW/BI system, reports and other analytical functionality. 

The BI portal must be implemented in such a way that it is easy for the users of the DW/BI application to call on the functionality of the application.

The BI portal needs to be easy to use and understand, and if possible have a similar look and feel as other applications or web content of the organization the DW/BI application it is designed for consistency.

The following is a list of desirable features for web portals in general and BI portals in particular:

Usable: User should easily find what they need in the BI tool.

Content Rich: The portal is not just a report printing tool, it should contain more functionality such as advice, help, support information and documentation.

Clean: The portal should be designed so it is easily understandable and not over complex as to confuse the users.

Current: The portal should be updated regularly.

Interactive: The portal should be implemented in a way that makes it easy for the user to use its functionality and encourage them to use the portal. Scalability and customization give the user the means to fit the portal to each user.

Value Oriented: It is important that the user has the feeling that the DW/BI application is a valuable resource that is worth working on..