Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint
Chapter 11: Delivering the Goods: Report Delivery > Cache Refresh Options
Cache Refresh Options
There are limitations to each of the two processing options just discussed: caching and report snapshots. Caching does not create a cached copy of a report until the report is actually executed by a user. If a report has a number of parameters, then a cached copy of the report suitable to satisfy requests for a given combination of parameters is not created until a user first executes the report with that combination of parameters.
Report snapshots allow for a “preexecuted” version of a report to be created in advance, but that preexecuted version can only be created for the default parameters assigned to that report. Given these limitations, it is clear we need a more flexible form of caching. Fortunately, Reporting Services has cache refresh options to fill this need.