The queries that are executed against the data warehouses causes large amount of database processing. Every time we access an analysis, the query is going to be generated by the BI Server and it's executed against the database. In order to improve the performance, we should balance the workload by enabling the cache on the BI Server. So when the query is executed for the first time, the result set is going to be cached on the BI Server. The result set is going to be generated from the cache in the subsequent executions.