Skip to main content

Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Installation

You can start your  OBIEE 11g installation after completing the prerequisites list.


In the unzipped install files go to Disk 1 and run the setup.exe file (for Windows). This launches the Oracle Universal Installer.
There are 12 steps in the installation process. And we’ll go through the most important ones in the following:


  1. Step 2 – choose installation type. For a test instance you can go on and choose the first option. 


  1. Step 3 – the installer verifies if your system meets the prerequisites to proceed. 


  1. Step 4 – you have to enter a location for the installation, but be careful and do not enter a location containing spaces. 


  1. Step5 – enter username and password. You will need these identification details to start and use OBIEE. 


  1. Step 6 – choose the desired components. 

  1. Step 7 – enter database details. Here you have the details corresponding to the database installed in the prerequisites section. And you also have to enter schema username and password used in the RCU installer for OBIEE schemas. 

  1. Step 9 – You may choose to save the details. 

  1. Step 10 – Installation and configuration steps take a little much longer, as these are the purpose of the installer.
  2. Have a little patience and once finished you can start using OBIEE 11g.
    You have bellow the access details for different applications:
    Oracle Business Intelligence
    http://host:9704/analytics
    WebLogic Console
    http://host:7001/console
    Enterprise Manager
    http://host:7001/em
    Oracle BI Publisher
    http://host:9704/xmlpserver
    Real-Time Decisions
    http://host:9704/ui
  3.  
  4. Start installation using setup.exe (Windows) or setup.sh (Linux)
  5. Next screen is for information only - OBIEE requires at least 2GB hard disk space and 200 MB temp disc space
  6.  In this screen you define location of OBIEE top level directory,
    ORACLE_BI_HOME and ORACLE_BI_DATA_HOME
    - You also select installation type
    i) Basic
    ii) Advance

Select components - In this screen you select components you wish to install with OBIEE server

 Next screen displays all components you are going to install

 Specify JDK Location and Administrator (OC4JADMIN) account password on this screen
 In this screen you provide windows user detail and option to start BI as windows services (Manual or Automatic)

Select Language, Click on Next and complete the Installation process.


Restart the system.

Finally start services (using services.msc) if not already done and access OBIEE from browser
Default Web port BI services is 9704 and default username/password is Administrator/Administrator
To Access Analytics (BI Analytics ) http : // server name:9704/analytics (Administrator/Administrator)

To Access Publisher (BI Publisher aka XML publisher )
http :// servername:9704/xmlpserver (Administrator/Administrator)






Thanks!!




Popular posts from this blog

Planning Admin Extension

Planning 11.1.2.3 – Smart View metadata management One of the new features in planning 11.1.2.3 is the ability to manage dimensional metadata through Smart View  • The new Hyperion Planning Admin Extension for Smart View allows Oracle Hyperion Planning administrator users to import and work with metadata in Smart View. • With this extension, Planning administrators can use Oracle Hyperion Smart View for Office applications to perform these tasks: 1. Add, edit and import existing Oracle Hyperion Planning dimensions and members, including moving members and designating members as shared in Smart View 2. Create and refresh cubes • The extension can be downloaded from the Tools menu in workspace. • This will download a file called “ PlanningSVExtension.msi ” which is 1.4mb in size and can be easily installed by running the msi . Once you Install Planning Admin Extension A Smart View Set up Wizard opens up for the extension installation. Click on Next :

Shared Connection and Private Connection

You connect to data sources through shared or private connections. Shared Connections •Shared connections are stored in a central location and are available to multiple users through the Smart View Panel. You cannot add, edit, or rename shared connections, but you can save them as private connections, which you can edit and rename. Private Connections •Private connections are those that you create by saving a shared connection to your local computer or by entering a URL to a provider that is not configured for shared connections. When you create a private connection, it becomes the active connection. Shared Connections : 1. From the Smart View ribbon, click  Panel . 2. From Smart View Home or from the menu displayed when you click the arrow next to Home button, do one of the following: • Click a connection name under  Recently U sed . You can click    to pin items to this list. • Select  Shared Connections  to open the Shared Connections panel, where you s

Import Security : Planning

There will be a huge number of requests to grant or remove security access for users. For one or two changes, it is simple task, click on member and then assign access and grant permission. It becomes tiresome when we need to make changes for large number of members. It involves considerable amount of time. Automating the security changes saves considerable amount of time. The ImportSecurity utility in planning loads access permissions for users or groups from a text file into Planning. Importing access permissions using Import security utility overwrites existing access assignments only for imported members, users, or groups. All other existing access permissions remain intact. The SL_CLEARALL parameter clears all existing access permissions. ImportSecurity utility is located at /Hyperion/Oracle/Middleware/user_projects/epmsystem1/Planning/planning1 on Planning server as shown in the following picture: Steps for importing access permissions: STEP1 :Create a text