[OBIEE 11g] Cache Purging

OBIEE 11g Cache Purging

      1.  ODBC CONNECTION

Create a System DSN for the OBIEE 11g core application as follows.

      2.  Using Analytics Web details

Check for the above details in the instance config.xml. This is the default DSN for the installed OBIEE 11g instance on the local system and distributed environment also.

      3.   In Unix

OBIEE DSN is specified as follows

[AnalyticsWeb]

Driver=<OBIEE Home>/bifoundation/server/bin/libnqsodbc.so

Description=Oracle BI Server

Repository=

Catalog=

UID=

PWD=

ForwardOnlyCursor=

SelectPhysical=

IsClusteredDSN = Yes

Regional = Yes

PrimaryCCSPort = 9706

SSL = No

PrimaryCCS = sssu

This is found in the file odbc.ini in setup folder which will have the odbc socket information for OBIEE 11g (created while installation) in the Location

<BIHome>\bifoundation\OracleBIApplication\coreapplication\setup\odbc.ini

     4.  RPD

Create a connection pool pointing the created DSN as follows.

 

USER INTERFACE

Create a Direct database request Call SAPurgeAllCache() with the connection pool information in this case prgall.

Save the Request under a folder in shared folder

DashBoard

Create a dashboard and include the report ddr in it.

In the report options, display the report as a link so that you can run it as and when you want.

The report looks something like this. We can replace the text with our custom messages also.

View the session log

Run the report.

Find it run in the session log (UI).

The cache in rpd will be cleared.

Hence cache purged using a report.