Use of ClearCache (XMLA) command in ROLAP partition without Proactive Caching

Just wanted to share my experience on the role of cache while browsing the cube.

I have attended one workshop on SSAS conducted by Mr. Amit Bansal in Mumbai. While doing the Hands-on-lab I came across a behavior of cache while browsing the ROLAP partition without proactive caching. We were testing the ROLAP partition by updating the data in the data warehouse to reflect the changes immediately in the cube. After updating the data in the data warehouse database and refreshing the cube, the updated values were not reflecting in the cube. The reason being the cube is reading the data from the cache. Also as proactive caching is not enabled, the cache is not getting updated automatically. At that time a question came to my mind whether the cache can be cleared manually using some command so that the updated data will reflect in the cube...