The actual Executed SQL or SQL steps.

Question

Hey Guys,

So I have now been playing with OBIEE for over a month and things are starting to make more sense. Question that I still seemed to be fuzzy about is, where can I see the actual execution steps that OBIEE is actually doing. In other words I know that I can see the actual sql being send from the interface but that just looks like is selecting from the model. The question I really have is where is the actual sql that is being sent to the database. I can't seem to be able to find that under any log, but  I will admit there are so many logs I could have possibly  missed one.

Any help you guys can offer would be greatly appreciated.

Thanks!

[Deleted User] · Answer

nqquery.log (in 11g; bi-querylog or sth in 12c). You can also see it under Administration -> Manage Sessions. Your log level needs to be at 2 though (minimum - pumping it higher gives you more info).

Gianni Ceresa · Answer

Hi,

In the admin page where you see the sessions in the logs you are supposed to see the LSQL and then the physical SQL (as long as your query doesn't hit the cache). If you don't see it (and it's not the cache) then just increase your log level a bit.

It's all about the log level if you don't see the physical query ...