I am having a strange problem with OLAP Cache. I have a web template with 4 queries, I cache the query results from Reporting Agent in the morning. For these queries the cache mode is set to Persistence mode as Flat file. The queries cache about 2MB data. When I run the web template the data read from cache and results displayed quickly. It works same way with everybody in the development group. When user runs the web template the data read from database and takes long time to display the result. My questions is Why the data is not read from cache/write in to cache when user run the report?
Does any body experienced this. Any help is greatly appreciated and rewarded.