Cache Variable in obiee 12c

Question

Hello,

We are using OBIEE 12c and I created an analytic report.  It has dashboard prompts.  I did not enter or set any variable in the prefix section in the advanced tab.  However, i found that it is set to SET VARIABLE DISABLE_CACHE_HIT=1;  The report is being copied to different folders and also to higher environments.  It is strange that the variable is not set in all the copies, I mean in all the copies of the folders or in other environments.  However, I am assuming it might be populating after it ran once or couple of times.  Any thoughts?

Thank you in advance.

manyam

Joel Acha · Answer

That sounds very strange as that has to be set somehow. Does anyone else have access to edit the analyses on these dashboards?