Here i am back again with some stuff. Generally, when we run some reports the results get cached and we need to clear the cache for the report each and everytime when we run that report. This seems to be a tedious task when the RPD is in Online mode and we need to clear the cache their.
So, here is a technique to prevent the report from hitting the cache.
When we 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.
Kindly keep me posted with all your learnings and questions in BI, so that we can make this forum a more valuable place for learning BI.
Posts
