CACHE MANAGEMENT IN OBIEE PLATFORM
CACHE MANAGEMENT : - Cache is a Physical Memory which stores in Hard-Disk. We Have allocated a some disk space in NQSConfig file. where it stores the recent executed data. When we run the report in OBIEE for first time, it will get cached if the cache is enabled. Then when we run the report for next time, the report will be coming from the cache, and physical query for the report won’t be generated. If any change happened to data in underlying database after the first report run, the changes won’t get reflected in the report as the report is coming from cache. We could enable / disable the cache at an application level, table level or at the report level. ADVANTAGES OF CACHE :- Eliminates unnecessary database processing because pre computed results are stored in a local cache. Improves query performance by fulfilling a query from the cache as opposed to searching through the database. Conserves network resources by avoiding a connection to the datab