Skip to Content
0
Former Member
Jul 07, 2011 at 09:25 AM

OLAP Cache for Query Performance

22 Views

Hi Experts,

I have below 2 Questions before we implement OLAP Cache for our Queries:

1) We have 15 imporatant queries - which do NOT have any variable/selection screen.

(question here is will it work for those kind of queries which dont have any selection screen/ variant ? ) --> client wants to prime the cache for few queries which dont have variable screen.

In this case, say if data is later filtered on any CHAR , will it take the data from Cache?

2) I have a query which initially will have few characteristics in the drill down when we first execute and users would be drilling down on many other characteristics after that. So if I want to fill OLAP cache for this query then what is the best way so that each drilldown in the query gets data from cache.

Thank you,

-Su