In OBIEE 11g turning off the cache can be tricky. By default the cache is on.
If not sure whether the cache is on, check NQSConfig.INI file (path instances/instance1/config/OracleBIServerComponent/coreapplication_obis1).
Line 39 - this shows the cache is enabled:
[CACHE]
ENABLE = YES; # This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager
As the commend says the setting is managed by the Enterprise Manager so it is best to change it there. Changing the value in the NQSConfig.INI will create confusion.
Log in in the Enterpise Manager, then Capacity Manager tab and Performance sub-tab. Click on Lock and Edit Configuration button.
Uncheck Cache enabled, click on the Apply button , then Activate Changes and restart.
It keeps the cache that it has collected so far. So I go and manually delete the cache files before the restart. The cache files are stored here OBIEE_Location/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/cache.
If not sure whether the cache is on, check NQSConfig.INI file (path instances/instance1/config/OracleBIServerComponent/coreapplication_obis1).
Line 39 - this shows the cache is enabled:
[CACHE]
ENABLE = YES; # This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager
As the commend says the setting is managed by the Enterprise Manager so it is best to change it there. Changing the value in the NQSConfig.INI will create confusion.
Log in in the Enterpise Manager, then Capacity Manager tab and Performance sub-tab. Click on Lock and Edit Configuration button.
Uncheck Cache enabled, click on the Apply button , then Activate Changes and restart.
It keeps the cache that it has collected so far. So I go and manually delete the cache files before the restart. The cache files are stored here OBIEE_Location/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/cache.