Skip Navigation
Cache reports and dashboards at scheduled times
Answer ID 8997   |   Last Review Date 11/18/2018

How do I use Report Caching?


Analytics, Report Caching Scheduling feature
Oracle B2C Service, Sites
November 2016 and newer


How do I cache the results of a frequently run report to reduce server load, and reduce the processing and loading time for a report?


There are two different types of report caching. The first is automatic, and has to do with the underlying data of which your database is constructed. That's not what this is. See Answer 1917: Cached data used in reports for details on that.

Report Caching is a feature available on sites November 2016 and newer.

A report typically gathers the data it will display at the time it is opened, run, or refreshed. A Cached report does not collate and process at these times. Rather, cached reports only update their information at the interval specified in the caching schedule.

To set a Cache Schedule, while editing the report, in the Home tab, in the properties section, click the Caching icon:

Click Caching button from Properties section of the ribbon

Ensure the "Enable report caching" box is selected:

Enable the checkbox to Enable results caching

Set the caching schedule as desired.

For additional information, refer to the 'Cache reports and dashboards at scheduled times' section in online documentation for the version your site is currently running. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.