Thursday, November 25, 2010

OBIEE11g - Stopping and Starting Services from Command Line

In the previous post I showed how to stop/start OBIEE 11g services using Fusion Middleware Control. This post shows how to achieve same using command line.

OBIEE 11g installer creates opmnctl.bat file for each instance. To manage services start command prompt and go to the bin folder of the instance \{MWH}\instances\instance1\bin

Run following command to check the status of all the services running under the instance.

opmnctl status

You can use ias-component name in the output to stop/start individual service.

For example, following command stops presentation service.

opmnctl stopproc ias-component=coreapplication_obips1

And following command starts presentation service

opmnctl startproc ias-component=coreapplication_obips1

Following commands can be used to stop/start all services in the instance.

opmnctl stopall
opmnctl startall

OBIEE11g - Stopping and Starting Services using Fusion Middleware Control

In OBIEE 10g all five services could be stopped and started from the windows services management console.

However, things have changed with OBIEE 11g because of the change in the architecture, specifically related to scalability. All the services are maintained through Oracle Process Manager and Notification (OPMN) server. Stopping/Starting this service will stop/start all BI services for that instance.

Most of the administration activities are performed using Fusion Middleware (FMW)
Control in OBIEE 11g. You can stop and start services from FMW Control too.

Logon to FMW Control using URL http://hostname:7001/em

Select coreapplication under Business Intelligence in the left tree in FMW Control. The "Overview" tab on the right will show number of services running (Generally 5, but may be different based on your scalability settings). You can Stop, Start or Restart all services using buttons provided.

To stop and start individual services, navigate to "Availability" tab under "Capacity Management" tab. You can stop/start all or selective services here.

Friday, November 12, 2010

OBIEE - Purge BI Server Cache from Analytic Web Manually

All of us knows how to purge BI Server cache manually from Analytic Administration Tool i.e. Go to Manage > Cache. Select cache entries, right click and purge.

But what if you are working on reports remotely using Analytic Web and need to clear the BI Server cache? Here's the trick.

Go to Settings > Administration

In the Administration dialog select "Issue SQL"

In the SQL Statement textbox in the "Issue SQL Directly" dialog, enter the following statement and click "Issue SQL" button.

Call SAPurgeAllCache();

Allow some time for BI server to clear the cache. The page will refresh with results message at the bottom saying operation is successful.

You can also use other cache purge functions based on your need.

Thursday, November 4, 2010

OBIEE11g - Table Prompts and Sections

Table/Pivot Table Prompts and Sections are very nice and handy features in the OBIEE11g. This post shows different ways to create it.

Here's a simple pivot table with Company, Year, Brand and few measures.

Edit pivot table view and drag the columns to the Prompt and Section area as shown below.

Back to result view. Company is now a dropdown prompt and Brand is section header

Alternate way: Right click column in result view. Select "Move" menu. Select either "To prompts" or "To sections".

Another alternate way: Hover the column and drag the small tab that appears over it to the empty area above the table.

Pivot Table Prompt area will appear automatically. Drop the column there.

Similarly drag and drop columns to Sections area.

To bring back columns to table, hover the Prompt or Section header. Small tab will appear on left. Drag and drop it to the table back.