On the cache tab, the Dataset results can be cached in memory (RAM) on the Nathean Analytics server. This allows views built on the Dataset to be displayed extremely quickly in Visualiser and can reduce the load on the source system. It is recommended that any Dataset which will be used for the creation of Dashboard Views should be cached.
The Nathean Schedule Service will cache a result set of each combination of parameters that have been defined within the system for the Dataset (the default values defined in the Dataset Parameters tab, the values saved on any Views of that Dataset and any User or IP parameters configured on the Dataset) so care should be taken when configuring the Timeout Period and any Cache Start abd End times to avoid over-loading source systems.
The result of the Dataset query run with the Default values defined within the Dataset can be configured to be stored in a Nathean Data Mart where it can be queried with SQL from another Dataset.