OBIEE 11G - Enable Log-Level from Advanced Tab

In the Criteria -> Advanced tab, Add below tag in the prefix and click Apply SQL.

SET VARIABLE LOG_LEVEL = 2;

Check the Log from Administration > Manage Sessions.