OBIEE11g Installation on 32 bits XP-pro IV

This is part IV of a four 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

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

OBIEE Missing BI-Office add - in

Erik did a good one: http://bidwcz.blogspot.com/2008/12/chybjc-bi-office-add-in-me-se-to-stt-i.html But since most of you (including me :) ) don't speak or read Czech here is a translated summery:

If you a "missing" the  OBIEE office plug in after you did an install and think it should be there, try this:

In your MS Office application grotto Help> About MS Office> Disabled Items >

Press Disabled Items  and check if the OBIEE Office add in is the list.

Till Next Time

OBIEE for MicroSoft Office

When you try to log on to OBIEE for the first time from Excel, you are asked to define a connection:


The setup documentation and the default settings from OBIEE for MS-Office can put you in the wrong direction.

The port number is the port where your bioffice is running, default this is the same port as your BI-server (default) 9704.

Your connection could look like this: