OBIEE: Enable Log-Level from Report / Analysis

To get OBIEE generated SQL in an environment where LOG is disabled, you can enter below statement in Advanced tab of the report/analysis and click Apply.

SET VARIABLE LOG_LEVEL = 2;

Now you will be able to view Log from Administration > Manage Sessions.

Hope this helped!