Enable / Disable Cache in OBIEE 11g

When we run the report in OBIEE for first time, it will get cached if the caching 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.

Application Level

To change the cache setting at application level, follow the below mentioned steps.

1.  Navigate to enterprise manager
2. Navigate to Business Intelligence --> Core Application
3. Navigate to Capacity Management --> Performance
4. Click on Lock & Edit Configuration and change the cache enabled flag.
5.  Restart the OBIEE Services

 

Table Level

We could cache settings at table level using OBIEE Admin Tool

1.  Navigate to the Physical layer of RPD and select the table for which the cache settings need to be changed.
2. Make changes in the RPD and deploy it.
3. Once the new RPD is deployed, restart the OBIEE Services
   

Report Level

To disable cache at the report level, follow the mentioned steps

1.  Navigate to the Advanced tab in Analysis
2. To disable Oracle BI Presentation Services Cache, select option shown below.
3. To disable cache at the BI Server Level, type in below mentioned command on the Prefix section
   SET VARIABLE DISABLE_CACHE_HIT = 1;
4. Click on Apply (Not Apply SQL. If you click on apply SQL, it will throw error)