I have a report with a long query and so takes a while to come up.
Thats why I am trying to Cache it.
I created a Cache refresh plan of every two hours.
But don't know what I should add in Processing Options , The default is Do not Cache , but how can I use that when I have scheduled a plan.
Its a bit confusing, Can anyone guide?
OR is there a better way in caching?