(Note: Make sure that you have a read access to a log
files.)
Below is the link for log file locations.
If you are unable to see the log file or if we find any error
message saying that, No Log found as below.
Normally, we set our query loglevel in RPD. We can set the query loglevel in Answers too.
To Set the query loglevel in Analysis you perform the following steps.
1)
Close this error window as well as cursors.
2)
Just go to the Advanced tab of the particular report.
3)
Scroll Down to see the option Prefix.
4)
Write here SET VARIABLE LOGLEVEL= 7;
(Note: you can set your loglevel
from 1 to 7 in my case, I am looking for physical query so setting loglevel as
7.)
5) Click Apply SQL.
6) Now click on Results tab
to rerun the report.
7) Now go Settings >
Administration > Manage Sessions.
8) Click on View Log to view
the query. Now you are able to see the query and according to your loglevel.
9) Below is the link for loglevel description.
No comments:
Post a Comment