Set Log level and disable cache hit for single report in OBIEE 11g

Generally we do not have the Log Levels enabled in production environments because of the performance issues ,but when we are doing debugging we have the need for the query so we may have to enable log level for that particular report.

We could use the advanced tab to achieve this , just set the log level using the below line.

                  SET VARIABLE LOGLEVEL=5;

We may also have the need to disable cache hit. Use the below line for this

                 SET VARIABLE DISABLE_CACHE_HIT=1;
There will be time where we need to do both on same report ,then we can write as below

                 SET VARIABLE LOGLEVEL=5,DISABLE_CACHE_HIT=1;