Dashboard prompts not seeding BI Server cache — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Dashboard prompts not seeding BI Server cache

Question
1
Views
0
Comments
jackohug
jackohug Rank 2 - Community Beginner
edited Aug 13, 2024 3:40PM in Oracle Analytics Cloud and Server

TLDR

Our dashboard prompts aren't seeding the BI Server cache, yet running the same logical SQL (as generated by the dashboard prompt) as an Analysis does seed the cache.

Background

We have a clustered OBI environment running 11.1.1.7.150714 with caching enabled.

According to the Usage Tracking, about 30% of requests on each node come from cache, but when we look at what isn't hitting cache a remarkable amount of them are dashboard prompts. When we look at the NQQuery.log entry generated when a dashboard prompt is expanded to list the values a query is run against the database but the result set is not cached.

Taking the logical SQL out of the log and using that to create and run a new Analysis does cause a cache entry to be created, and any further usage of the prompt makes use of this cache entry. So, I know the caching is definitely enabled and working against the physical objects in the RPD.

Any guesses as to what's going on or what might me misconfigured?