Hi, 1. its not a BI Publisher Report- its an OBI Analaysis Report. 2. "directly querying the DB " mean that report Query doesnt uses any cache, its querying the Presentation layer subject area tables. i have a simple problem that i could not able to get the data from one table- "OBI Analaysis Report" where i have checked…

its not using useing the cache

Hi, i have checked the log and found report is directly querying the DB and also checked the physical layer we are getting the data for the particluer view-"AGGR_FACT_DEP_ACT" and alos check relationship/ join with other table which also seames fine, i cound not able to understand what's going wroung with it. . is there…

Hi, Thanks for your response! Can you please tell me where to look for the logs and how i will know OBIEE is querying the DB or get results from the cache. Thanks, Bhasker