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@