I’ve been asked this a few times recently so thought I’d write a quick post. There’s three places you can set whether or not caching occurs in PPSM:
1) On an individual report or scorecard object
2) On the data source itself
3) As a setting on the PPSM server
Don’t forget to take into account the performance hit that you may cause by changing this setting
The PPSM scaling document – http://technet.microsoft.com/en-us/library/bb660539.aspx
And don’t forget as well that if you’re using ‘per user’ security you won’t get the benefits of caching over app pool security
Then of course you’ve got to consider the whole Sharepoint side of things…
