Automation of Dashboard Refresh in OBIEE 11G

If we want the dashboard to be refreshed for every 'n' minutes then below HTML will be helpful, where you have to give (n x 60) seconds.

Insert the below html in the dashboard text layout and check the HTML markup checkbox.

<META HTTP-EQUIV = "REFRESH" CONTENT = "60">
<META HTTP-EQUIV="CACHE-CONTROL" CONTENT="NO-CACHE">

Don't forget to enable the "Contains HTML Markup"

So in this way the page which is being displayed in the browser can be refreshed automatically without manual intervention.

K@run@

RPD Merging in OBIEE 11G

Merging two RPDs:-

PROCESS 1:-

Consider the two RPD that are to be merged as

RPD1-Consisting of all the previous version Modelling (Existing deployed in Prod)

RPD2-Consisting of modified modules that are to be merged to the RPD1

RPD3- Consider a dummy RPD which is blank as.

Now below are the steps to merge the RPDs via Blank RPD method.

àOpen RPD1 and go to file menu > merge

àIn the merging options Select Master RPD as Blank Rpd i.e RPD3

àModified RPD as the RPD2 which has the changes that are to be merged.

àCurrent RPD will be the RPD1.

Click next and in the conflicts select Current for those whose descriptions is as ‘Add to current’ and select modified for the those whose description is as  ‘Delete from current’.

Thus the merged RPD will be saved at the location mentioned in the previous step.

PROCESS 2:-

è Open the blank RPD first.

è In merge options give the master repository as Production RPD and modified repository as Dev RPD.

And follow the above steps of process 1. 

K@run@

EM/console taking long time to open

This Happens because of too many logs created for Adminserver and BI server.

Solution:-

It can be restricted by disabling the log level parameters
Logon to console. Go to Environment -> Servers -> Adminserver (admin) -> Debug -> Expand Weblogic -> security
check any of the paramters are enabled. Disable them by clicking on Lock and edit under change center and Activate the new changes

K@run@

Setting loglevel for a user/report/system OBIEE 11G

For a particular report
Edit report --> go to advanced tab --> Enter the below tag in Prefix section --> Apply SQL and save the report
SET VARIABLE LOGLEVEL=n; (where n=1,2,3,4,5)
SET VARIABLE LOGLEVEL=2,DISABLE_CACHE_HIT=1;

Here disable_cache_hit is to make sure that the report query to hit the database butnot the cache.

For whole system
Open RPD in online/offline. Go to tools --> Options --> Repository
Set the value for System logging level and save the rpd


For a particular user
Open RPD in online/offline. Go to manage --> Identity --> double click on a user
Set the value for Logging level and save the rpd

K@run@

How to check the disk Space in linux for OBIEE 11g

How to check the disk Space in linux for OBIEE 11g:-

Enter the command “df -h” in the putty prompt and check for your directory similar to the below example.

Size Used Avail Use%

99G   74G   21G  79% /app/oracle------------ (Check the free space of the OBIEE and ODI installed directory).

If the space is consumed too much then try to free the space by deleting the unnecessary logs like saw.log, nqquery.log,nqserver.log from instance directory and other server logs from UserProjects 

directory based on the time stamp of the log file. 

K@run@

Down grading the RPD OBIEE 11g

Down grading the RPD:-

In BI command Prompt(OBIEE Client) use the following command

nqgenoldverrpd -P Admin123 -I C:\RPD_old\FAPRD20140314_BI0002_May09.rpd -O C:\RPD_NEW \FAPRD20140314_BI0002_May09_latest.rpd -V 325 The above example is used to degrade the version of the RPD and remember we can't upgrade the RPD as there is no functionality that was provided with the OBIEE Client.

K@run@

Taking Backup of OBIEE RPD and Catalog in the Server

Taking Backup of OBIEE  RPD and Catalog in the Server:-

àConnect to Putty and Winscp of the environment that you choose to take backup.

àCopy the source path of the RPD and the catalog and the backup folder path as well in the winscp.

Now in the putty enter the command

“Scp –r "path of the RPD/repositoryname.rpd" "username for putty login"@hostname:"path of the backup folder"”

When entered it asks for the password, and then backup is done.

Follow similar steps for catalog backup as well by giving the catalog path till OBIEE_catalog example the directory sampleapplite..

EXAMPLE:- 

scp -r app/oracle/obidev/instances/instances1/bifoundation11g/oracleservercomponent/repository/sampleapplite.rpd oracle@localhost:app/oracle/backup

K@run@