OBIEE enable logging at Presentation Level

Some times you might want to diagnose performance or data issues by setting a temporary loglevel for a query. You can enable query logging for a select statement by adding aprefix clause in the Advanced SQL Clauses section of the Advanced tab in Oracle BIPresentation Services.

For example, for the select statement:

SELECT year, product, sum(revenue) FROM time, products, facts; You can specify the logging level of 5 in the Prefix field as follows:

Set Variable LOGLEVEL=5;

For this query, the logging level of 5 is used regardless of the value of the underlying LOGLEVEL variable


  1. Thanks for sharing this useful info for OBIEE. Keep updating same way.
    Regards,Siddu online Training

  2. I would like to appreciate your work for good accuracy and got informative knowledge from here.........................Please contact us for Oracle Fusion HCM Training details in our Erptree Training Institute