How to override the log level settings directly in Answers?
Level of query logging for users should be set in the Oracle BI Administration Tool in Security Manager, but we can override the session variable to turn on logging (or change to a higher level of logging) for a particular analysis.
This can be sometimes useful as in production environments logging level is usually set to 0 (no logging). Changing it to second logging level (LOGLEVEL=2) would fetch both the logical and physical SQL. Continue reading