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