Monday, August 30, 2010

OBIEE11g SampleApps

If you haven’t found them:

http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html

Till Next Time

Wednesday, August 18, 2010

OBIEE 11g The GA bet We have a winner

We have a winner Michael K, only 2 days of the official GA day of august the 13th. Well done! Please send me your details, so I can send you a goody bag.

see: http://obiee101.blogspot.com/p/obiee-11g-ga-bet.html

Till Next Time

OBIEE11g Deploying an new RPD.

Goto the weblogic EM console:

image

Expand 'Business Intelligence' node on the left and choose Coreapplication.

image

image

Now click on the Deployment tab on the right. Next, go to the Repository tab.

image

Click on 'Lock and Edit Configuration' to enable you to change the default settings.

image

Select the RPD you want to use:

image

Enter ther RPD passwords and press update:

image

Press Apply:

image

You might see a name change:

image

Click on Activate Changes:

image

image

Click on top of the page on link „Restart to apply recent changes‟. This only takes you to the page where you can restart services.

image

image 
Click on blue button „Restart‟ (or green button „Start‟) under the Manage System category, middle of screen,
image

Click yes on dialog box to confirm the move. Wait for message that confirms successful restart.

image

Have Fun:

image

Till Next Time

OBIEE11g BI Certification Matrix

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/bi-11gr1certmatrix-166168.html

(this is actually an XLS file despite the browser saving it as an HTML file)

Thanks to Turribeach

Till Next Time

OBIEE11g SampleApps Password.

For those of you who didn't do a RTFM, it's : Admin123
image

The User is your weblogic account.


Till Next Time

Monday, August 16, 2010

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

image

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

image



username=weblogic


password=Password






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


image


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:


 image


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:


image


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


image


image


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


http://localhost:7001/console/


image


image


Click on servers:


image


image


Now for the grant finale, check OBIEE:


http://localhost:9704/analytics


image 


Select the Quickstart Dashboard:


image


Click around and have Fun!


image


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

OBIEE11g Installation on 32 bits XP-pro III

This is part III 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

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

image

image

Press Next

image

Select Simple Install

image

Press next

image

Enter your Middleware Home Path

image

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

If you get an

image

press unblock

image

Enter the credentials

image

Enter (optional) your personal Oracle Support credentials

image

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

image

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

image

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

image

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

In the next part we will finish the configuration

Till Next Time

OBIEE11g Installation on 32 bits XP-pro II

This is part II 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

Let’s create the repository using the RCU:

image

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

image

Select Create

image

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

image

Press Ok

image

Enter a prefix and check the BI components.

image

An other check, press OK

image

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

image

Map the tablespaces.

image

press OK

image

Press OK

image

You are almost done, press Create

image

Press close, you are done.

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

Till Next Time