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,
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.
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.
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
No. The file must be renamed to disable the cache if using this method.
MF.