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

How do I use Report Caching?

Environment:

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

Issue:

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?

Resolution:

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 Service Cloud manuals and documentation online, refer to the Documentation for Oracle Service Cloud Products.


Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.