So we have tested the JDBC connection and its successful.Note : (Look at the snap "Create a new JDBC Data Source" - In the database name I have given the full name orcl.us.deloitte.com. Earlier I had given orcl only but the JDBC connection failed so you may try giving full name )

Click Finish.Activate the changes as shown below.

Changes have been activated.

Now login to Enterprise Manager and go to Deploy option as shown in the snapshot below.

Follow the onscreen instructions and steps as shown below.Select the .ear file in the path shown below.

Click on the pencil-shaped button and select mds-bicomposer and press OK.

Partition name : bicomposer - Next.

Deploy.

We will have BiComposer in Application Deployments. Right click and go to System MBean Browser as shown below.

Search for oracle.adf.share.connections and expand it till you get bi-default. Edit the username and password as shown below. Apply changes.

Now we have to restart the BI services. Clear the browser cache and remove temporary internet files.Login to OBIEE 11g analytics. Reload the metadata files. Refresh the browser.Now go to Weblogic-My Account- Make the Accessibility mode ON.

Now go to New - Analysis and select any of the subject areas - for ex - Testing subject area and a new page will open.

This is BI Composer. In the next article we will see how we can make use of this BI Composer to do the analysis.Note : After you are done with your work with BI Composer and go back to Analytics and turn off the Accessibility mode otherwise next time when you login to analytics you will see limited option being present on the home page ( Administration link would have gone so be careful with that. )Thank you and good luck.