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.
The BI Server's cache is going to be enabled from Fusion Middleware Enterprise Manager Control. You'll see the Performance property page under the Capacity Management tab. Then click on the Lock And Edit Configuration link to modify the values.
After selecting the Cache Enabled checkbox, you'll need to click on the Activate Changes link.
Changes are going to be activated and the Restart to apply recent changes link will appear. Click on that...