How to enable or disable the cache in OBIEE 11g?

FOR TURNING OFF SERVER CACHE IN OBIEE 11G
The following configuration setting of NQSConfig.INI file, is managed by Oracle Business Intelligence Enterprise Manager.

[Cache]
ENABLE = YES

If you change this entry directly in NQSConfig.INI file then it will revert to the original value whenever you restart the BI server.
The possible solution is given below:


1. Login into the enterprise manger by entering the below link:  http://<OBIEEAdminServerName>:<AdminServerPort>/em
2. Expand Business Intelligence folder
3. Select the coreapplication link
4. Select Capacity Management tab
5. Select Performance tab below capacity management tab ->
6. Click 'Lock and Edit Configuration'
7. Deselect the 'Cache enabled' option
8. Click Apply
9. Click 'Activate Changes'
10. Restart the BI Service when prompted.
This would automatically change the Cache entry in NQSConfig.INI file.

 *Note: After clicked 'Activate Changes' come to the performance tab and make sure the 'Cache enabled' option is deselected.

See the direct link to the OBIEE Administration guide:

http://docs.oracle.com/cd/E28280_01/bi.1111/e10541/querycaching.htm#i1005378


Thanks,

Angad