Parameters cache

In IBM Cognos Business Intelligence, if parameters caching is enabled, prompt pages run more quickly. As a result, overall server performance can improve. By default, parameters caching is disabled at the server level. To enable parameters caching for all reports, you can change the server setting. To override the server setting for a report, you can edit the XML attributes for a report specification.

Parameters caching is set at the server level with the advanced property RSVP.PARAMSCACHEDISABLED. The default value for the advanced property is true. You can enable parameters caching by changing the value for the advanced property to false. Once enabled, the setting takes effect when reports are updated and saved, and the parameter and prompt metadata is embedded in the report specification. Then, when the report is run, the metadata is retrieved from the cache instead of from the query engine.

Parameters caching can improve overall server performance, particularly when reports are run against complex models, and when reports have complex queries with many prompts and parameters.

To decide whether to enable parameters caching, assess the stability of the model. If the model is static, consider enabling parameters caching. If the model is in development or if data types change frequently, do not enable parameters caching.

If the server setting for parameters caching is not suitable for some reports, you can override the server setting by editing the XML attributes for a report specification. So, if parameters caching is enabled at the server level, you have the option of disabling it for a particular report, or enabling parameters caching for a particular report if the server-level property is disabled. For information on setting parameters caching for a report, see Setting parameters caching for reports.