Thursday, November 23, 2006

Cognos8: New data does not appear even when the query is rerun

This is due to internal caching which is a default setting in Cognos 8.
Caching options can be set in three places:

1. Properties of the query in Report Studio.
2. Properties of the model in Framework Manager (under edit Governors)
3. Global cache set which is set as follows:
a) Go to the \Cognos\C8\configuration directory.
b) Make a copy of the CQEConfig.xml.sample file.
c) Rename the above file to CQEConfig.xml.
d) Open the file for editing.
e) About half way through the file there is an entry name called queryReuse. Change the value to 0.
f) Restart the Cognos8 Service

No comments: