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

The logical query block fail to hits or seed the cache in subrequest level

Received Response
1
Views
1
Comments
user1175364
user1175364 Rank 2 - Community Beginner
edited Aug 13, 2024 5:59PM in Oracle Analytics Cloud and Server

Hi All,

I am trying to seed the cache for few reports through Ibots and all the reports are getting cached but when other users trying to hit the reports its not taking from cache.

I checked the NQ_Query log and it says:

The logical query block fail to hits or seed the cache in subrequest level due to   [[

filter on post join filters .

Any help is appreciated.

Regards

Answers

  • Joel Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

    I would suggest that you remove all filters from the logical query that you’re trying to seed. This will ensure that all requests are covered for all possible filters for all users.