To configure these settings, open Advanced Settings. Caching can be enabled and configured on the View Cache tab as shown in the image below:

The View Cache has the following available options:
 

❑Enable Caching - Checking this will enable caching of views on the local system. Note that for views(s) to be added to the global cache, you must enable caching for each view desired by checking the Cache checkbox on the row of the view name.

❑Method - Specifies when the view will be added to the cache. Method has two possible options, one of which can be selected from the dropdown by clicking in the cell of the row/column

❑On Startup - View will start running in the background as soon as the web application starts. Once it finishes running, it will be added to the cache.

❑On Demand - View will start running in the background when it is requested the first time. Once it finishes running, it will be added to the cache.
 

❑Refresh - Specifies how the cached view will be refreshed. This has two possible options:

❑Duration - View will be refreshed at a specified interval. This interval is specified in the Refresh Frequency column

❑On Data Change - The application will check for cube data modifications at a specified interval (also specified in the Refresh Frequency column).  If data modification is detected, the view will refresh in the cache.
 

❑Storage - Specifies if the view will be cached in memory or on disk. This has two possible options, one of which can be selected from the dropdown by clicking in the cell of the row/column

❑In Memory - The selected view will be cached in memory

❑On Disk - The selected view will be cached on disk
 

❑Refresh Frequency - Time interval (in seconds) in which the application will refresh the view in the cache. If zero is specified, the view will never be refreshed.

❑Time To Live - Specifies the time duration, in seconds, that the view will remain in the cache.  If zero is specified, the view will remain in the cache indefinitely.