OBIEE/BIP Forumer wrote:I just tested this in my local (Both 10g and 11g) and it worked fine for me. This is what I used in the prefix section:
The scenario is:
When I open a report and set the prefix to 'SET VARIABLE LOGLEVEL=2,DISABLE_CACHE_HIT=1;' then I save it. Then I close that specific report then open that report again. The 'SET VARIABLE LOGLEVEL=2,DISABLE_CACHE_HIT=1;' is not saved in the report in the prefix section in Advanced tab.
Is there a way to save the SET VARIABLE LOGLEVEL=2,DISABLE_CACHE_HIT=1; in a report to get the Query log?
OBIEE/BIP Forumer wrote:That is strange. Can you try adding the code to the XML instead of adding it to the prefix section and click on SET XML and save the report?
Thanks for your answer, but I the Variable I set in the Prefix section is not saved even if I saved the report with the Variable.
Below is the steps I do:
1. I open Report XYZ
2. Click to Advanced tab then I enter 'SET VARIABLE LOGLEVEL=2,DISABLE_CACHE_HIT=1;' or ' SET VARIABLE DISABLE_CACHE_HIT=1, LOGLEVEL=2;' in the prefix section
3. I saved the report
4. Open Report ABC then
5. I re-open again Report XYZ hoping that my prefix variable is saved
6. I go to the ADvancec tab for Report XYZ, but I didnt see the variable I just saved