Caching in Cognos 10.2.1 when DQM is enabled

[mithumm@gmail.com]

Dear All,

Recently we migrated to Cognos 10.2.1 with DQM enabled. So how take the benefit of cache for the report performance.

I will schedule and run the report after the data load, so that when user runs the report later on,  report will take the data from cache instead of hitting database, so performance will be faster.

but my question is how to write the cache?

For example if I have report with Product Line and Product type prompt(Mandatory), how I can load the data to cache with all the combinations, so that if user runs report for any combination it should retrieve data from cache instead of database.

Thanks in Advance, waiting for your responses,

Regards,

Mithun

[mrcool]

If your reporting source is DMR published in DQM or OLAP then the caching works. Caching is not effective on relational reports even when DQM is enabled.
You have to create detail reports which has all the attributes that your reports use and schedule them to prime the cache. When your users run the actual reports they run from cache instead of sending the query to database.
Hope this helps.