Tuesday, July 5, 2011

OBIEE11 How to use the log

If you come from a 10g background you might be missing the NQquery.log. Don’t worry it’s still there. In 11.1.1.5 you will find it in <<OBIEE_HOME>>\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1

image

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

image

- Set it for a individual user:

image

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:

image

Scroll down to the prefix part:

image

and enter:

SET VARIABLE LOGLEVEL=2;

Don’t forget the semicolon!

Open the NQquery.log in a text editor (fi Notepad++)

image

Run your report and reload the log in the text editor:

image

Scroll down to the bottom to check your sql:

image

Till Next Time

5 comments:

L said...

Just a small Correction. You mention, you do not see the users in the Admin tool. You can. In the Admin tool, Under manager > Identity, when you see the Identity window, you can select Action menu, and search for Users by using '*' as a wild Character to search, this will display all users. And from this list, just like in old 10g tools, you can select each user, assign a log level.

Keep up the good work.
L.

John Minkjan said...

L

Are you using 11.1.1.5? I can't find it there.

Regards John

L said...

Yes, I'm using 11.1.1.5, I included screenshots on this link, since I can't upload pics to the blog.
Hope it helps.

http://www.megaupload.com/?d=UBUDJ2WC

L.

John Minkjan said...

@L,

Found it! thanks for the info!

regards
John

Anonymous said...

the megaupload link seems to be obsolete...can u post the images John

Regards