Hi Gianni, I think I know how to turn off this "manual refresh". In the Advanced page > Analysis XML > there is this checkbox for "Bypass Oracle BI Presentation Servies Cache". All I did was check that, save and rerun the report. I no longer need to refresh each section one by one. All the refresh is done with a F5…

Since the data did not get refreshed after the page reloaded, I went into each "section" of the page in which my page was built upon 4 sections together. Each section has a "Edit - Refresh - Print - Export - Add to Briefing Book - " link at the very end. I clicked the Refresh link from there and voila, the data refreshed…

Hi Gianni, Thanks for the detail explanation. I was able to add this SQL and also disabled the cache in the physical layer in the RDP. However, my analysis is still not showing the latest results. I checked the database and there were new data. I checked the cache in the RDP and no cache was built up I refreshed the page,…

Hi Gianni and Christian, Thank you for your pointers. It seems like my analysis was querying on the cache. I am at the Cache Manager inside the opened Online Repository. I could see 5 cache entries, but how to do I turn that off? Is this where I should be looking for? Also, Christian, Where do I set the variable…

Hi, Thank you for helping out. I have a database that has new data coming in constantly throughout the day. I am connecting to it so that I could run hourly reports. I guess I need to get the latest row count to give me the latest data. Or if I was missing something? Thanks