OBIEE11g Installation on 32 bits XP-pro I

OBIEE11g is out! Yeah, let’s try and install it on a windows 32 bit XP-pro box.

This will be a 4 part series:

Part I: http://obiee101.blogspot.com/2010/08/obiee11g-installation-on-32-bits-xp-pro.html

Part II: http://obiee101.blogspot.com/2010/08/obiee11g-installation-on-32-bits-xp-pro_16.html

Part III: http://obiee101.blogspot.com/2010/08/obiee11g-installation-on-32-bits-xp-pro_9802.html

Part IV: http://obiee101.blogspot.com/2010/08/obiee11g-installation-on-32-bits-xp-pro_8977.html

Ok, we have finally downloaded the 4,5 Gb:

(While you are waiting for the download to finish start reading the manuals: http://download.oracle.com/docs/cd/E14571_01/bi.htm)

Unzip them in a single folder:

Copy all the bishiphome subfolders to a single install folder:

Check if you have access to an db:

Check if you have a loopback adaptor installed, this provides at least one fixed ip-adress for your system:

Start the RCU (Repository Creation Utility) found in: D:\OBIEE11G1130\ofm_rcu_win32_11.1.1.3.3_disk1_1of1\rcuHome\BIN

Till Next Time

OBIEE11g Upgrade from 10g

Again start with an RTFM:
http://download.oracle.com/docs/cd/E14571_01/bi.1111/e16452/summary.htm#BGBHEFCF

Till Next Time

OBIEE11g documentation

While you wait for the download to finish, please do a RTFM:

http://download.oracle.com/docs/cd/E14571_01/bi.htm

Till Next Time

OBIEE11g Available for download

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html

 

Have fun!

Till Next Time

OBIEE Reverse the filter

Or how to define a between filter based on ONE presentation variable.

Let’s get our prompt and presentation variable:

variable is pVarYear

Let’s get a simple report:

Giving us:

Let’s add the between, first add your variable to a dummy column:

Add a filter to that column and set it on between:

Add two sql expression with your year column and add the diferences:

Remove your dummy column and check the results:

 

Or simple convert a filter to sql an directly edit it:

Till Next Time

OBIEE OBI-SE the forgotten forum?

If you are into answering OTN questions, have a look at the OBI-SE forum every now and then: http://forums.oracle.com/forums/forum.jspa?forumID=404

please don’t let me be the only one:

  ;-)

Till Next Time