[OBIEE Issue] XMLP Server Cache Control

1.   Login to BI Framework with the user account which has the XMLP_ADMIN privileges on BI Publisher. Click Admin Tab from this page.

2.  Click Server Configuration on Admin Page.

3.     If you have never set up the Caching for publisher, by default,it should be all blank for this section. Input the numbers for each text field as expected.

4.     Restart OPMN

Open a terminal and type the following commands.

 $cd <OAS_Home>/opmn/bin

      $./opmnctl stopall

      $./opmnctl startall


[OBIEE Issue] Roll back Selection Security to be Enable

Recently, I was asked about a question that how to roll back the Selection Security to be Enable again.

It looks like on the Dashboard Properties page, you could change the Selection Security from Enable as shown by the graph above to the two new icons below which offer more flexibility of setting up the selection permission.

 The question is how to roll it back. It seems there is no way to roll it back to Enable on the same configuration page.


In order to roll back the change, you need to go to the catalog  Manager and navigate to Shared -> Shared folder name (eg: BI Framework) -> _Portal

Go under _portal folder and find the dashboard folder that the change was made. You would see there is one extra folder called _selections and  one extra attribute file _selections.atr

Delete these two items and restart BI Server. You would see the Enable link is restored back!

[OBIEE Issue] Whole Cache Purging Scripts

Be sure to set your Oracle BI home in the ‘.profile’, as the base installed directory of OBIEE, on the OBIEE Server. The following script would reference it as ORACLEBI

I will create a temporary “purge-log”  folder under Oracle BI Home that would store the log information of the cache purge.

1.You need to put the following lines into a .sql file. I call it purgecache.sql and put this file under purge-log folder temporarily.

// The below script should be run at the terminal to purge the OBIEE Cache.
// The following command should run from $ORACLEBI/server/Bin64
// nqcmd -d AnalyticsWeb64 -u Administrator -p -s /purge-log/purgebicache.sql
Call SAPurgeAllCache()

2.The script for purging all BI Server cache is shown below and I name it as cachepurge.sh.

# Custom Script for Purging OBIEE Server Cache
# Usage ./cachepurge.sh <OBI_Administrator_Password>
# Oracle BI Home is the Root Directory where OBIEE is installed
# and this parameter should be set in the profile
echo OracleBI Home Directory is $ORACLEBI
cd $ORACLEBI/setup
echo current directory is `pwd`
. common.sh
. sa-init64.sh
#echo 2
cd $ORACLEBI/server/Bin64
echo current directory is `pwd`
# script to run nqcmd
date >> $SAROOTDIR/purge-log/cacheoutput.log
echo ——– >> $SAROOTDIR/purge-log/cacheoutput.log
echo ‘OBIEE Whole Cache Purging’ >> $SAROOTDIR/purge-log/cacheoutput.log
echo ——– >> $SAROOTDIR/purge-log/cacheoutput.log
nqcmd -d AnalyticsWeb64 -u Administrator -p $1 -s $SAROOTDIR/purge-log/purgebicache.sql >> $SAROOTDIR/purge-log/cacheoutput.log
echo ‘script completed’

cd c1

4.You could run the script anywhere once you set up your Oracle BI home. Suppose I put the script under purge-log folder as well.The format to run the Cache Purging scripts is

$cd $ORACLEBI/purge-log
./filename.sh OBI_Administrator_password
Eg: To clear the OBIEE Cache as a whole, run the following command assuming ‘Administrator’ as the password
./cachepurge.sh Administrator

[OBIEE Issue]Download links not compatible with IE7

Issue Description:

If you setup a download link for each report like below in IE6, it works fine when you download the data like below: OBIEE could transform mhtml data format to the desired the data format ( in this case it is an excel file).

However in IE7, without extra settings, you would encounter with a compatibility problem that stops the OBIEE from transforming the mhtml format to other formats. Then the issues would show like below:

Continue reading