Note
Execution caching is currently incompatible with the Scheduler Queue.
Important
This feature requires the installation and proper configuration of the Scheduler Service.
Execution Caching uses the Scheduler Service to cache the data at set refresh intervals. When caching is enabled for a report, a caching schedule is created that determines how often the data is refreshed. Scheduler Services need to be enabled for the user or users who will be setting the caches; however, users who only need to view the cached reports do not need to have scheduling enabled.
To enable execution caching, set General > Scheduler Settings > Enable Execution Cache in the Admin Console to True.
The userId and companyId parameters must exist and have default values assigned to them in order to be able to enable execution caching. These parameters are used to assign visibility permissions to cached data.
The following Admin Console settings that affect access to some schedule recurrence options will also affect the recurrence options available in the execution caching window:
The following Admin Console setting will affect the view level options that a user has when assigning permissions for an execution cache:
The cache data is stored in the scheduler temporary directory, however cache files will not be deleted by the scheduler’s routine cleanup.
To set up caching for an advanced report:
Caution
Role-based filters and column-based tenancy apply based on the user who creates the cache. Users who can view the cache will see data filtered by the creator’s role and tenancy, not the viewer.
From the
Check the Enable execution caching check box.
Note
Not every option may be available.
Choose how often the cache is updated:
Enter a time of day in the Schedule Time field, or use the picker to select a time.
Optional: To update the cache multiple times per day, select the Repeat Every check box and enter a time for how often it should repeat.
Optional: To repeat until a certain time of day, enter that time in the Until field, or use the picker to select a time.
Choose which days of the week the cache is updated. Select either:
To repeat every day or every number of days, click Every __ day(s) and enter a number of days for how often it should repeat.
To repeat every Mon, Tues, Wed, Thurs, and Fri, click Every weekday.
Click OK.
When execution caching is enabled for a report, the cache is not created immediately. To run the report, you can manually create the cache by clicking the Cache Status
Cache schedules are visible in the schedule manager, with the label (cache). Caches can be edited or deleted using the schedule manager or the advanced report designer.
Viewing a report cache in the schedule manager
Editing a cached report invalidates its cache. It cannot be run until the cache is updated. A missing or invalid cache is indicated by the message Cache is invalid, both in the report description and in the report tree menu.
Valid and invalid report cache indicators
It is recommended that you fully design a report first, so that you can manually verify the output, before enabling the cache.