This will be a 4 part series:

Part I: http://knowledge.ciber.nl/weblog/?p=254

Part II: http://knowledge.ciber.nl/weblog/?p=255

Part III: http://knowledge.ciber.nl/weblog/?p=256

Part IV: http://knowledge.ciber.nl/weblog/?p=257 

Navigate to D:\MW_OBI11G\user_projects\domains\bifoundation_domain\servers\bi_server1\security, check if there is a file called: boot.properties

If not, make it using a text editor and enter :

username=weblogic

password=Password

Do the same for D:\MW_OBI11G\user_projects\domains\bifoundation_domain\servers\AdminServer\security

Reboot your BI-server.

Let’s make a couple off handy start and stop .bat files:

01 Start Weblogic.bat:

@echo off

cls

d:

D:\MW_OBI11G\user_projects\domains\bifoundation_domain\bin\startWebLogic.cmd

Run the script, wait to you see the IPADRESSES:

02 Start Opmn.bat:

cls

 

d:

D:\MW_OBI11G\instances\instance2\bin\opmnctl startall

03 Start Bi-server.bat:

@echo off

 

cls

d:

 

D:\MW_OBI11G\user_projects\domains\bifoundation_domain\bin\startManagedWebLogic.cmd bi_server1

pause

Run the script:

Wait to you see the IP-adresses.

Let’s check if everything went OK:

login to the enterprise manager using the weblogic account:

http://localhost:7001/em

This looks OK, let’s go to the Console:

http://localhost:7001/console/

Click on servers:

Now for the grant finale, check OBIEE:

http://localhost:9704/analytics

Select the Quickstart Dashboard:

Click around and have Fun!

I like to stop the server using scripts to prevent it from going into a recovery mode on the next start:

96 stop bi-server.bat:

@echo off

cls

 

d:

D:\MW_OBI11G\user_projects\domains\bifoundation_domain\bin\stopManagedWebLogic.cmd bi_server1

97 Stop OPNM.bat:

@echo off

cls

 

d:

D:\MW_OBI11G\instances\instance1\bin\opmnctl stopall

98 stop weblogic.bat

@echo off

cls

 

d:

D:\MW_OBI11G\user_projects\domains\bifoundation_domain\bin\stopWebLogic.cmd

Till Next Time

This is part III of a four part series:

Part I: http://knowledge.ciber.nl/weblog/?p=254

Part II: http://knowledge.ciber.nl/weblog/?p=255

Part III: http://knowledge.ciber.nl/weblog/?p=256

Part IV: http://knowledge.ciber.nl/weblog/?p=257

Let’s start the main installer from: D:\OBIEE11G1130\Install\bishiphome\Disk1

Press Next

Select Simple Install

Press next

Enter your Middleware Home Path

Enter a password for the weblogic user, make a big mental note of the password.

If you get an

press unblock

Enter the credentials

Enter (optional) your personal Oracle Support credentials

Press install, have a drink, this might take a while.

Check the BI Configuration box and let it run, have an other drink.

There is a big chance the last step failed, don’t worry, we will fix that later.

Save the summary file, it has handy information for later use.

In the next part we will finish the configuration

Till Next Time

This is part II of a four part series:

Part I: http://knowledge.ciber.nl/weblog/?p=254

Part II: http://knowledge.ciber.nl/weblog/?p=255

Part III: http://knowledge.ciber.nl/weblog/?p=256

Part IV: http://knowledge.ciber.nl/weblog/?p=257

Let’s create the repository using the RCU:

(Some of the screen is Dutch, but all the button are in the same place)

Select Create

Enter your database credentials. Be sure it has SYSDBA privileges.

Press Ok

Enter a prefix and check the BI components.

An other check, press OK

Enter the schema passwords (Make a big mental Note).

Map the tablespaces.

press OK

Press OK

You are almost done, press Create

Press close, you are done.

Let’s start the OBIEE and FM setup from D:\OBIEE11G1130\Install\bishiphome\Disk1

Till Next Time

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://knowledge.ciber.nl/weblog/?p=254

Part II: http://knowledge.ciber.nl/weblog/?p=255

Part III: http://knowledge.ciber.nl/weblog/?p=256

Part IV: http://knowledge.ciber.nl/weblog/?p=257

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

In part 1 we ended with:

Read more

First of all Kudos to Hitesh for laying the ground work: http://hiteshbiblog.blogspot.com/2010/04/obiee-showing-data-on-calendar.html

Read more

This Article is only a guideline to an OBIEE naming convention for the repository. The most important aspect of a naming convention is that you use it consistently. The used naming convention should be readable for any future development.

Read more

This Article is only a guideline to an OBIEE naming convention for the repository. The most important aspect of a naming convention is that you use it consistently. The used naming convention should be readable for any future development.

Read more

This Article is only a guideline to an OBIEE naming convention for the repository. The most important aspect of a naming convention is that you use it consistently. The used naming convention should be readable for any future development.

Read more

Most repositories have a natural tendency to grow in the time they are “alive”. For the Physical and Business layer OBIEE has the option of using display folders:

Which is a nice way to organise your stuff and most of all to have it look more “professional”

These folder only contain shortcuts to the “base” material.

So let’s start organizing our stuff

Till Next Time