Monday 22 November 2010

OBIEE 11g Publisher Boilerplates

Changing BI Publisher Default Templates

Ever wondered how to change the Shared Templates section when you create a new BI Publisher report ?

image

I did.

In fact, these are stored under in the report /Shared Folders/Components/Boilerplates.xdo

image

Click Edit to edit the boilerplate. Then Add New Layout.

Make layout changes as necessary, and save as a new Layout.

image 

Create your layout as necessary, and save it as a new Layout.

Now, when you click on New->Report, select a Data Model, and your layout should be present.

image

Click on the New Layout, the online layout editor will open, based upon the boilerplate.

Done.

Sunday 14 November 2010

Load Balanced OBIEE 10g Clustered Installation

In this post, I’ll install a four node OBIEE 10g cluster integrated with Oracle Application Server (for BI Publisher) IIS, and SSO.

There will be two “web nodes” which will host IIS, OAS, and the web plugins. These machines will be node01 and node02. There will be two “app nodes” which will host all the other OBIEE components.

I will setup the installation with the default sample sales application.

Download Oracle Software

First download

biee_windows_x86_101341.zip

soa_windows_x86_101310_disk1.zip

(32-bit)

Install Oracle Software

We will be integrating OBIEE10g with OAS 10g. Download and unzip Oracle Application Server 10.1.3.1:

soa_windows_x86_101310_disk1.zip

Run setup.exe

Choose Installation Directory, and Advanced Install Next

Then, J2EE Server and Web Server Next

image

I simply ignored DHCP error message.

Then, Automatic Port Config, Next

Then

image

AS Instance Name: iAS

Password: oc4jadmin

Tick configure …

Next

Ignore Cluster Topology Configuration, Next

Summary, then Install

 

 

 

The Install.

Setup Vmware Image

Ensure that the vmware image has plenty of disk space set up. (I am using Windows 2003 SP2 32-Bit) Also ensure that 1 Gb of ram is ready for use and that you can access host system folders. Setup bridged or NAT networking. (I use bridged)

SNAGHTML3d98fc4

Fire up the VM.

Log on as Administrator. Change the computer name to something identifiable – eg: OBIEE10gNode01

image

Reboot.