Generally, when we run a report then the result get cached and we need to clear the cache for the report each and everytime.
So, here is a technique to prevent the report from hitting the cache.
Go to the Advanced Tab in Answers for that particular report, 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 wont hit the cache.
So, here is a technique to prevent the report from hitting the cache.
Go to the Advanced Tab in Answers for that particular report, 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 wont hit the cache.
No comments:
Post a Comment