Refresh of Data after DB modifications

[Sunchaser]

Dear all,
We are experiencing the following behavior in Cognos 8.4 FP2 windows platform:
after altering data in a table Report Studio is pointing at,I see that when I run the report, the data is not changed.
We had it in the past already - it takes "some time" until the changes are taken into account
Strange: when looking at the tabular data in Cognos, the backend changes are taken into account but not within the report when it is run.
I am looking for any hint, exaplanation for this behavior.
Any solution even more appreciated
So far: I can only assume there is a cache somewhere Cognos is pointing at.
Are there any properties which can and should be changed within Report Studio and / or some properties within the Cognos Configuration to be changed?
Thanks a lot for your support - we have to rely on Cognos 100%
Best regards,

[MFGF]

Hi,

By default, your package will have report caching enabled.  This can be turned off in Framework Manager - Project -> Edit Governors, and un-check the 'Allow usage of local cache' option, then re-publish the package(s).

Hope that helps,

MF.

[Sunchaser]

Hi,

Thanks for your answer.
We finally solved using a technic described in documentation, "at server level", with the file: CQEConfig.xml and setting the value of the item "queryReuse" to 0.
This file is originally as ".sample" ( in "configuration" folder), so it must be renamed and put in the "bin" folder of Cognos, and then the Cognos service has to be restarted.

Regards,
vinc.

[Cognos8]

Hi ,

I have a query  on your reply . Intially your CQEconfig was disabled ( mean it was like CQEconfig.xml.sample )  at that time u were saying caching was enabled modified data not reflected. after modifying CQEconfig.xml.sample to CQEconfig.xml. with queryreuse = 0 caching is disabled.

my query here is  ...

I agree second point disable the cache. first point will also disable the cache???

1) If CQEconfig is set as CQEconfig.xml.sample
2) After enable the CQEconfig.xml modify queryreuse = 0

[MFGF]

No.  The file must be renamed to disable the cache if using this method.

MF.