Managing the cache is very critical in the BI Server. Although it brings many advantages, if it's not managed successfully end users may access old results from the cache.
- We need to purge the cache whenever the data warehouse is refreshed or updated. We can achieve this by defining the Cache Persistence Time value. This setting is on the General tab of the Physical table. If you set it as one day, then the lifetime of this table in the cache will be a maximum of one day.
- The second method is more popular. You'll need to create a job that will execute the script as follows:
When you run this script, ...