[OBIEE 11g] BI Composer Installation & Setup

BI Composer Installation & Setup

BI Composer is a simple-to-use wizard that allows you to quickly and easily create,edit, or view analyses without the complexities of the "Analysis editor".  

BI Composer tool reminds of "Query Studio" of Cognos 8 Suites. This is mainly designed for Adhoc analysis where end users wants to develop queries/analysis on-the-fly.

Main Components of BI Composer are :

■ On the Top, Buttons for each step in the wizard. 

■ On the left are the Catalog tab and the Subject Areas tab.

■ To the right of the tabs is the panel area, where the components for each step are displayed.

■ To the far right are the Back, Next, Finish, and Cancel buttons.

  

We will cover all the steps in next blog, "Working with BI Composer". Lets focus on the installation/configuration first.

There are two basis steps required for the installation.

1. Extend the Oracle WebLogic Server domain to include the BI Composer application and the BI Composer run-time implementation shared libraries

2. Configuring the instanceconfig.xml file on the installed computer and on any scaled-out computers

Steps :-

A. Stop/Shutdown the server. (Including weblogic/OPMN)

B. Start the Oracle Fusion Middleware Configuration Wizard from Command/Unix located at

cd MW_HOME\wlserver_10.3\common\bin\config.exe

This will open up a new window for extending weblogic domain.

C. Select the Extend an existing WebLogic domain radio button

D. Select a WebLogic Domain Directory and Click Next.

MWHOME/user_projects/domains/bifoundation_domain

 

E. In the Select Extension Source page select the Extend my domain using an existing extension template radio button.



F. Click Browse and then select the oracle.bicomposer_template_11.1.1.jar file in the following location: 

MWHOME/BI_HOME/common/templates/applications/oracle.bicomposer_tem plate_11.1.1.jar/

G.  Click Next -> Next -> Next -> Next -> Next. You don't need to specify/check any options from the list of Data sources/Test/Optional Configurations.

H. Click Done when Process is completed. 

I. Add BI Composer Element in InstanceConfig.xml.

<ServerInstance>

.......

<BIComposer>

<Enabled>true</Enabled>

</BIComposer>

.......
</ServerInstance>

J. Start the server ( Admin/Managed/OPMN).

K. BI Composer is now available in Oracle Business Intelligence.
  
L. Login to OBIEE Application. Go to My Account and click on Wizard(limited functionality) under Analysis Editor option. 

M. Now Edit the Analysis/Create a New Analysis, which will open BI Composer screen for quick analysis.