Skip to Content
Former Member
Oct 11, 2006 at 05:59 PM

Have you seen this in OLAP Cache?


I am doing some testing on OLAP Cache usage and found this that the cache gets generated and is resued for a small data set like for 2 months but once I run the query in the back end lets say for a larger set 12 months or so, though it gets registered in the cache (with a lesser K Bytes), its not resued at all, any subsequent query run still hits the database. I am thinking this has to do with the Reporting agent setting in which we select "FILL OLAP CACHE IF POSSIBLE". this seems to work only for small sets of data. If I have to fill the OLAP Cache with large data sets, is there any table size or buffer size that I can increase? if anyone has encountered this scenario please let me know...