Hello friends of Cognos,

we want to prevent data caching under any circumstances as the underlying database receives multiple data entries per minute or sometimes seconds.

There are three options to handle data caching in Cognos:

1. Frameworkmanager Model Setting "Allow use of local Cache".
2. In a Report using that Model we can select "Use local cache". (Documentation of 1 +2)
3. CQEconfig.xml as server setting (Documentation)


Does the third option 3. CQEconfig.xml overrule 1+2?

Is there a way to use caching by "default" in a Report and let the user decide to press a button "Load Fresh Data" to bypass any caches and ensure data is being fetched from database?

How do y'all handle caching in a situation like "ours"?

regards,
Ralf

------------------------------
Ralf Roeber
https://linkedin.com/in/ralf-roeber/
------------------------------
#CognosAnalyticswithWatson

Hi,

As described in documentation, option 3, overwrites 1 and 2. And 2 overwrites 1.

But, notice that is applied to CQM packages only. CQE is a configuration file to Compatible Query Mode.

If you want to handle cache with DQM, Datasets and Modules, you might handle this in Modules cache options.

In file xqe.config.xml, you will find cache configuration about flint server, but I did not find any documentation about that.

Cache usind DQM packages are effective using DMR. If not, you might test and see that - disabling cache in FM - your queries will always send to database.

If you want to create a no-cache report, you can create a page custom control that defines method:

Control.prototype.getParameters = function( oControlHost )
{
// WARNING: Do not remove this method.
// Pages that don't contain prompt controls are cached by the viewer. The existence of a getParameters
// is used as the indicator that the custom control is prompt-like and will prevent caching.
};


If you want to create a button to force a refresh in your report, the best way to do that is create a custom control that calls method "oControlHost.valueChanged();"

This method will tell Cognos that a prompt changed its value and report needs to be execute again, forcing a fetch.

------------------------------
JEAM COELHO
Cognos Solution Architect

LinkedIn: https://www.linkedin.com/in/jeamcoelho/
------------------------------