Temporarily Set Logging level in OBIEE 11g – Answers/Analytics

Temporarily Set Logging level in OBIEE 11g – Answers/Analytics

In general logging level in OBIEE production environment turned-off (Level 0) for users, but sometimes backend query required to analyze the query. Usually Level 2 logging for analyzing the query.

One way to analyze the query is set logging level temporarily turned-on. With this you can get OBIEE server logging only for the particular report to be analyzed.

To implement it, Go to In analysis editor (Oracle BI Answers) go to Advanced tab -> Prefix field:
 
SET VARIABLE LOGLEVEL= n;

Example: SET VARIABLE LOGLEVEL=5;

Note: semi-colon (;) at the end