Archive for the ‘OBIEE Configuration & Administration’ Category

Integration on OBIEE with OID (Oracle Internet Directory)

To integrate the OID with obiee Fusion Middleware, need to do the following three steps

1. Configure Oracle Business Intelligence to use Oracle Internet
Directory as the Authentication Provider
2. Configure the User Name Attribute in the Identity Store
3. Configure a New Trusted User (BISystemUser)

So, in this post we will check how to configure the OBI to use OID as authentication Provider

1. Login to Oracle WebLogic, and click Lock & Edit

2. Select Security Realms from the left pane and click myrealm. The default Security Realm is named myrealm
3. Navigate over Provides-> Authentication

4.Click New to launch the Create a New Authentication Provider page.

Click OK to save the changes and display the authentication providers list updated with the new authentication provider.

5.Click MyOIDDirectory in the Name column to display the Settings page.

6.Display the Configuration\Common tab, and use the Control Flag list to select ‘SUFFICIENT’, then click Save.

7.Display the Provider Specific tab and provide the host ip and post of server. Also provide the credential: Password in connection area

8.Click Save.
9.At the main Settings for myrealm page, display the Providers tab, then display the Authentication sub-tab.

10.Click Reorder to display the Reorder Authentication Providers page.And make the OID provider all the way up

11.Click DefaultAuthenticator in the Name column to display the Settings for DefaultAuthenticator page and use the Control Flag drop down list to select ‘SUFFICIENT’, then click Save.

How to Change the JDBC connection of Metadata Repository in OBIEE 11g

1) logged in to Fusion Middleware http://Machine_name:port/em
Machine_name:- name of the machine / ip address
Port: – 7001 default port
2) navigate over weblogic Domain -> name of your domain ( By default it is bifoundation_domain), available in left pan
3) click on Weblogic domain as shown below

Admin menu

4) Select JDBC Data Source, the screen may appear as

JDBC Connection Screen

5) Select EPMSystemRegistry

EMPSystem Registry

Database URl: -
Jdbc:oracle:thin -> Default
Hostname: – name of host where metadata resides
1521:- Default Port
Orcl:- servicename
password: enter the metadata schema password

Provide the user value in property section

6) Do the same thing for bip_datasource and mds_owsm

bip_Datasource Screen

mds_owsm

7) To change the metadata connection for scheduler, navigate over Business Intelligence -> correapplication-> Deployment -> scheduler and click on lock and Edit

Lock & Edit

Close the popup

Closed popup

Change Scheduler connection
Change the connection

How to scale out another obiee system with existing domain

How to scale out another obiee system with existing domain
To do the scale out on new system, need to run the obiee installation with enterprise install option. Before Proceeding to scaling the deployment to other servers, Please follow the following steps
1.Create a shared directory for the Repository Publishing Directory. The Master BI Server must have read and write access to this directory. All other Oracle BI Servers must have read access.
2.Use the Repository tab of the Deployment page in Fusion Middleware Control to designate the shared location for the Oracle BI repository
Sahre RPD

Sharing the Oracle BI Presentation Catalog
1. Create a network share for the Oracle BI Presentation Catalog. All Presentation Services components in the cluster must have read and write access to this share.
2. Place the catalog on the network share.
3. Use the Repository tab of the Deployment page in Fusion Middleware Control to change the location of the Oracle BI Presentation Catalog to the shared location
Share Catalog

Setting Up the Global Cache
1. Create a shared directory for the global cache. All Oracle BI Servers must have read and write access to this directory.
2. Use the Performance tab of the Capacity Management page in Fusion Middleware Control to set the Global cache path and Global cache size options.
Sahre cache

Now Run the OBIEE installer on the second machine/Server
Fill the required fields with the below information
The host name and port number for the Administrator Server domain (Created using the Create New BI System option on Server 1)
The user name and password for logging to the Weblogic Administrator Server

Scale out BI System

The following table describes the fields on this page.

Scale Out BI Sytem Detail

Configure Ports

Configuring Port

Configure Security Update

Configure Security Update

Click Next and Click Install to Complete the Installation Process

Managing Scalability

Logged in to http://hostname:7001/em and navigate over Business Intelligence->creapplication->capacity Management->Scalability

Scaling components
Configure primary and secondary instance of the Cluster Control and Oracle BI Scheduler so that the primary and secondary instance of each component type are distributed across two different machines/Servers. Use the Availability tab of the Capacity Management page in Fusion Middleware Control to configure the primary and secondary instance of Cluster controller and BI schedules

Follow

Get every new post delivered to your Inbox.