OBIEE: September 2012

OBIEE 11.1.1.6.4 is available

The Business Intelligence Enterprise Edition 11.1.1.6.4 patchset has been released and is available to download from My Oracle Support.

The Oracle Business Intelligence 11.1.1.6.4 patchset is comprised of the following patches:

patch 14538078 Patch 11.1.1.6.4 (1 of 7) Oracle Business Intelligence Installer
patch 14538128 Patch 11.1.1.6.4 (2 of 7) Oracle Real Time Decisions
patch 14285344 Patch 11.1.1.6.4 (3 of 7) Oracle Business Intelligence Publisher
patch 14538164 Patch 11.1.1.6.4 (4 of 7) Oracle Business Intelligence ADF Components
patch 14415773 Patch 11.1.1.6.4 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
patch 14405222 Patch 11.1.1.6.4 (6 of 7) Oracle Business Intelligence
patch 14409674 Patch 11.1.1.6.4 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer

Follow the same process as described in the article :
http://obiee1000.blogspot.com/2012/09/upgrade-obiee-111160-to-111162-patchwork.html

BI Composer - Graph Converted to Pivot View

I am connecting to BI Composer.

Turn ON the accessibility mode. Select the analysis and any of the subject areas. BI Composer Page will open.

Open the Testing Subject Area and Select 2 columns ( 1 dimension column say Year and 1 measure for example Amount Sold )

Go next - I would like to select Graph view and would prefer Bar Recommended view.

Let us preview the results.

Where is the Graph ? Where is it ? It has got converted into Pivot view.
And look at the title - It says "Graph Converted Pivot Table"

How can i see the Bar graph ?

Just open the main page of your analytics that might have been minimized and TURN OFF the accessibility mode and refresh the Page. Remove cache/Cookies.

Now go back to BI Composer page and cancel the request and from the left hand corner - click on Create.
Select the same subject area and create one request.

Now select the Graph view and check if the graph/chart is getting displayed on the BI Composer page.
Play preview.

Yaa !! Graph view is now graphical.

Thank you.

Wish you good luck.

Configuring BIComposer

This article explains the configuration of Bi Composer.
Environment : OBIEE 11g -Windows 7-32bits -Oracle database 11g.
Here we begin.

Stop the BI Services.

Go to Weblogic Configuration wizard. The path is shown below.

Just follow the steps as shown in the series of snaps below.

Now Start the BI Services and Open the Console application as shown below.

Press Lock & Edit button. Go to bifoundation_domain - Services - Data Sources as shown below.
Follow the instructions as shown in the snaps below.

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.

Go to ADFConnections - Operations tab - Click on Save button and Invoke.

Add an entry in the instanceconfig file

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.

Upgrade OBIEE 11.1.1.6.0 to 11.1.1.6.2 - Patchwork

Hi friends
I recently upgraded OBIEE from 11.1.1.6.0 to 11.1.1.6.2. (Windows 7 - 32bits). I will share all my experience throughout this patch process.Here we start -

Download the below patches from the Oracle Support portal.

14223977 Patch 11.1.1.6.2 BP1 (1 of 7) Oracle Business Intelligence Installer
14226980 Patch 11.1.1.6.2 BP1 (2 of 7) Oracle Real Time Decisions
13960955 Patch 11.1.1.6.2 BP1 (3 of 7) Oracle Business Intelligence Publisher
14226993 Patch 11.1.1.6.2 BP1 (4 of 7) Oracle Business Intelligence ADF Components
14228505 Patch 11.1.1.6.2 BP1 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
13867143 Patch 11.1.1.6.2 BP1 (6 of 7) Oracle Business Intelligence
14142868 Patch 11.1.1.6.2 BP1 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer
13952743 : JDeveloper Patch

Create a folder OBI_Upgrade on the desktop and put all the above patch files,
unzip all the patch files in that folder.You will find each folder being created for every patch file you unzipped.

Now move all the folders (14223977,14226980,13960955,14226993,14228505,13867143,14142868,13952743)
from OBI_Upgrade to C:\OBIEE11g\Oracle_BI1

Go to START->ALL PROGRAMS->ORACLE BUSINESS INTELLIGENCE->STOP BI SERVICES.

Go to C:\OBIEE11g\Oracle_BI1\bifoundation\web\catalogmanager\configuration and Remove the following Catalog Manager cache directories (if they exist):
* org.eclipse.osgi
* org.eclipse.equinox.app

Open the command prompt and set the variables.

set ORACLE_HOME=C:\OBIEE11g\Oracle_BI1
set PATH=%ORACLE_HOME%\bin;%PATH%
set JAVA_HOME=%ORACLE_HOME%\jdk
set PATH=%JAVA_HOME%\bin;%PATH%
set PATH=%ORACLE_HOME%\OPatch;%PATH%

Now one by one I have to apply the patches (Except 13952743)
(14223977,14226980,13960955,14226993,14228505,13867143,14142868)

Let us see the process for one patch 14223977. Path would be till the folder 14223977

The patch process would begin and when prompted you just have to type Y. Once the patch process completes it would display a message'Opatch Succeeded'

After that you have to go one folder back and enter into the new patch folder and execute the apply patch command as shown below.

You will have to repeat this process until you complete 13960955,14226993,14228505,13867143,14142868 (Except 13952743)

(Note: One of patches shown here is not required - I don't remember here but once you come across that one - the screen will display a proper message so there is no problem as such. You just have to finish applying all the patches.)

Once you done with all those patches,one important patch you will have to apply and that is JDeveloper 13952743 patch. For that you again have to set the variables. This time ORACLE_HOME would be different. Have a look at the variable path and you will easily understand the difference. Just before that copy the BIPublisherDesktop32.exe and BIPublisherDesktop64.exe files from the
C:/OBIEE11g/clients/bipublisher/repository/Tools directory
to the
C:/OBIEE11g/ /user_projects/domains/bifoundation_domain/config/bipublisher/repository/Tools directory.

Let us focus on Jdeveloper 13952743 patch now.

On the command prompt set the variables.

set ORACLE_HOME=C:\OBIEE11g\oracle_common
set PATH=%ORACLE_HOME%\bin;%PATH%
set JAVA_HOME=%ORACLE_HOME%\jdk
set PATH=%JAVA_HOME%\bin;%PATH%
set PATH=%ORACLE_HOME%\OPatch;%PATH%

and go to the folder 13952743 and apply the patch command

As usual when prompted enter Y.
Once the process completes you just have to start BI services.
When the patch process completed I started the BI services but I encountered few errors.
[ PLEASE NOTE THAT YOU MAY NOT RECEIVE SUCH ERRORS. THIS WAS HAPPED IN MY CASE SO IT DOES NOT MEAN THAT BELOW STEP IS A PART OF THIS UPGRADE PROCESS]

The error lines have words like Java.class...MBean ....Exception....
I went to
C:\OBI11g\user_projects\domains\bifoundation_domain\config\fmwconfig\servers\
AdminServer\dms_config.xmlAnd

Changed this entry:

to:

And started the BI services - Errors were gone and the login page could open. I reloaded the metadata files and removed the browser cache and temporary files. The Admin page then showed the latest version.

Thank you .
Good Luck.