When we run reports the
results get cached(Physical query won't generated ) and we need to clear the
cache for the report each and every time when we run that report.
OBIEE Queries cache hit can
be simply disable by prefixing a clause setting a variable value in the logical
SQL of the query.
Go to the Advanced Tab in Answers for that particular report, Below XML section we
have the Prefix and the Postfix sections there. Just go to the Prefix section
and paste the below mentioned command:
SET VARIABLE
LOGLEVEL=2, DISABLE_CACHE_HIT=1;
The next time you will run the report it won't
hit the cache.
No comments:
Post a Comment