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@