If you come from a 10g background you might be missing the NQquery.log. Don’t worry it’s still there. In 18.104.22.168 you will find it in <<OBIEE_HOME>>\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1
Along with the NQserver log.
Now how do I set the loglevel? Two options:
- Set it for everbody. (!A No No on production machine’s!)
In the Administration tool goto TOOLS > Options
- Set it for a individual user:
You can’t do it in the Administration tool, since the users are no longer there.
You have to do it in the report under investigation, go to the advanced tab of your report:
Scroll down to the prefix part:
SET VARIABLE LOGLEVEL=2;
Don’t forget the semicolon!
Open the NQquery.log in a text editor (fi Notepad++)
Run your report and reload the log in the text editor:
Scroll down to the bottom to check your sql:
Till Next Time