Hi,
I have a report with multiple query-based prompts, and I wanted to store its results in Cognos' cache to improve the response time. After some trails and errors I learned that I need to use DQL (instead of CQM) and then I do get the results from the cache.
However, after a couple minutes it seems like the cache is cleared, and then I get again SQLs in the DB.
My question : Where can I condifugre the cache to store data for longer time periods ?
(Using the Report's properties --> "Advanced options" --> "Refresh the report cache" --> "Cache duration" --> "X days" , didn't work.._)
Or
Of cource I meant DQM instead of CQM ;)
Anyone ?
Have you tried running a job to cache the prompts? I believe those cache options only in conjunction with a job.