OBIEE - All the caches

Data - Cache in OBIEE.

Obiee have two main caches mechanisms :

• The query cache (Bi Server cache) which is a data set cache
• The presentation server cache (Presentation Server Cache) which is an ODBC data set cache

The BI server can also cache :

• QUERY_PLAN
• DRILLDOWN_INFO
• DRILLDOWN_QUERY
• session variable via a INIT_BLOCK

See the Server Section Parameters in the Configuration File

• Security information: What parameters should be set to make the privilege changes reflect in OBI Analytics, in a short span of time?

If you use the row-wise initialization, the result of the query can be cached in the main memory cache of OBIEE server.