Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousand of experts, get answers to your questions and share knowledge with peers.
I have one query regarding the OBIEE Back End query, If we do not set up log level, how can we get the OBIEE Back end Query ?
Do we get the logs generated in nqquery.log file, even when the log level is not setup ?
No, but you can go to the "Advanced" tab of any analysis, go to the "Prefix" attribute and set the session variable to turn on / increase log level for that analysis:
SET VARIABLE LOGLEVEL = 2;
You'll need log level 2 at a minimum to get the physical SQL.