OBIEE Knowledge Base: 2012

Monday, December 3, 2012

Deploying RPD and Catalog in BI 11g

In OBIEE 10g the current running rpd and catalog files are configured in two files called NQSConfig.ini and instanceconfig.xml respectively. So If we want to change the current running rpd and catalog in OBIEE 10g we are opening the file and we are changing the rpd name and catalog name into these files. But in OBIEE 11g these things are controlled by Enterprise Manager (EM).

Locations of Repository and Catalog in BI 11g:

We can get the rpd and catalog which we have developed from below folders.

RPD Location Path:

Drive:<BIHome>\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository

Catalog Location Path:

Drive:<BIHome>\instances\instance1\bifoundation\

OracleBIPresentationServicesComponent \coreapplication_obips1\catalog

Step1:

http://machinename:7001/em

e.g: http://localhost:7001/em

Step2:

Once we logged into EM, Go to Business Intelligence from left side pane and select 'core application'. Select repository from right side pane.

Go to 'Deployment' tab -> select 'Repository' tab -> click on 'Lock and Edit' option.

We are getting the below screen and the number shows

1. It tells the current running repository

2. This says the current running catalog

3. 'Lock and Edit Configuration' enables the Screen to change the repository

and catalog.

Step3:

Once we clicked 'Lock and Edit Configuration' we will get the confirmation message like below screen. Click 'Close' with the screen.

Step4:

So In the next screen we are having the options to select repository and catalog which we want to deploy. After you selected the rpd and catalog click apply and click Activate Changes. The screenshot is like below:

The number indicates in the images are:

1. The place to choose the repository

2. The place to change the catalog

3. 'Apply' button after modification

4. 'Activate Changes' to change the rpd and catalog

5. 'Release Configuration' Which revert the page to old state

Step5:

Choose the repository from the location and enter the repository password and change the catalog name which we need to change.

Note: Do not forget to click 'Apply' button to save the changes and after that Click 'Activate Changes'

Step6:

Once we clicked 'Activate Changes' with the above screen , Activation process will be started and it will show the below screen.

After process is over, It will show the confirmation window like below screen. Just click 'Close'

Step7:

Once the changes have been activated, it will ask for the 'Restart to apply recent changes'. Click 'Restart to apply changes'

Step8:

Once we Clicked 'Restart to apply recent changes' It will come to the below screen. Click 'Restart' to restart all the BI Services. Once the services is successfully restarted The repository and catalog is updated.

Now open Administration Tool and Presentation Services to check the changes.

Sunday, December 2, 2012

Download OBIEE 11g RPD/Webcat/Data

Download OBIEE 11g Samplesales

Hi All,

I am sharing the OBIEE 11g (in 11.1.1.6.0) upgraded samplesales application.
Weblogic Repository password is '*******'(putyour own user_id,PWD).
User Name: Administrator
User Password: Administrator
Login with presentation services using Administrator User Name to access the dashboard with full privileges (Edit, View, Analyze and etc.,).

This zip file contains three folders
1. Repository
2. Catalog
3. Data

After downloaded the file, unzip it and copy the repository, catalog and xml fiels files to corresponding repository, catalog and data path.

Copy the 'server' folder from downloaded zipfiles/Data folder and copy into the below path:
Drive<MiddlewareHome>\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obips1

Tuesday, November 27, 2012

OBIEE 11G Installation in Windows XP

In the OBIEE 11.1.1.6 Certification, I didn't see Windows 32-Bit as supporting Operating system. Still, I gave it a shot to see whether it will work or not.

It works!!!
Installation of OBIEE invloves 4 steps:
1) Installation of Loopback adopter
2) Installation of database
3) Installation of RCU (Repository Creation Utility)
4) Installation of OBIEE software
Installing a Loopback Adapter on Windows XP-32 Bit

My System configuration: Ram 8 GB and windows XP Installed on virtual machine

Open the Windows Control Panel.

1. If you are in Category view switch to Classic view

2. Double-click Add Hardware to start the Add Hardware wizard

3. In the Welcome window, click next

4. Follow the screen shots one by one

In the Properties dialog box, click Use the following IP address and do the following:

a. IP Address: Enter a non-routable IP for the loopback adapter. For instance:

i. 10.10.10.10

ii. 192.168.x.x (x is any value between 0 and 255)

b. Subnet mask: Enter 255.255.255.0.

c. Leave all other fields empty.

Click OK

Close Network Connections.

Restart the computer.

Add a line to the SYSTEM_DRIVE:\WINDOWS\system32\drivers\etc\hosts file with the following format, right after the localhost line:

IP_address hostname.domainname hostname

 where:

IP_address is the non-routable IP address
hostname is the name of the computer.
domainname is the name of the domain.
Note : Domain name is optional. In the following screen shot. I just used my Computer Name.

Check the network configuration:

Open System in the Control Panel, and select the Computer Name tab. In Full computer name, make sure you see the host name and the domain name, for example, sales.us.mycompany.com.
Click Change. In Computer name, you should see the hostname, and in Full computer name, you should see the host name and domain name. Using the previous example, the host name would be sales and the domain would be us.mycompany.com.
Click More. In Primary DNS suffix of this computer, you should see the domain name, for example, us.mycompany.com