OBIEE 12.2.1.4.0 - Can we Cache queries for some analyses only, instead of turning it on Globally

3822729

Helllo Experts,

We have OBIEE 12.2.1.4.0 installed on Linux. A vast majority of our system contains Dashboards using one or many analyses on each of the dashboard pages. We are trying to explore options to improve the performance of the dashboards in terms of response times. Is it possible to configure query caching for a handful of heavy duty analyses, instead of having the cache ON globally ? Can we just seed the query cache only for a select few analyses ?  Can you please advise or suggest , if possible , how to do it ?

Thank You.

Rakesh 

Joel

You can use an agent to seed the query of a specific analysis in cache:

https://docs.oracle.com/middleware/1221/biee/BIESG/querycaching.htm#BIESG290

3822729

Thanks Joel. Appreciate your help.

i have follow-up question - Can I seed the query cache while having the ENABLED flag set to NO ? If it is YES, then the space allocation will be used by all queries, which we are trying to avoid as we only want to cache those huge analyses where we can see tangible performance gains. Please advise.