Cache statistics can be gathered by using Cache Manager. It's a tool that is part of the BI Administration Tool. These statistics will help us to understand the queries that are satisfied from the cache. If most of the time the queries are not being retrieved from the cache, it means that we're not managing the cache successfully.
Open the BI Administration Tool in online mode. Cache Manager is not activated if you open the repository in offline mode. Click on the Cache menu item from the Manage menu list.
Cache Manager is going to be opened. You'll see the cached objects and queries in this window.
We'll have to click on Show Info from the Action menu list. This will open the cache statistics.
Now you'll see the Cache information window and all the statistics regarding cache.