Enabling  Query Logs in OBIEE 11g

Post date: 12-Mar-2014 09:45:40

1. The user level logs can still be enabled by opening repository in online mode 

Navigate to  Manage -> Identity -> 

Set Online User Filter

Enter the user name search and then set the log level on user tab of results

2. one can enable Repository level logging for all users 

Tools-->Options-->Repository-->

System log level by default will be 0, we can then  increase to 2 or 3 accordingly and save it.

3. Enabling Logs by Report level

Go to Advanced tab of report request

    In Prefix Section add below lines

SET VARIABLE LOGLEVEL=2,DISABLE_CACHE_HIT=1;

4. Enabling loglevel by Session Variable.

Create system defined session variable LOGLEVEL.

Initialize it with query SQL query like in init block

select 2 from dual/ <any db table>