Cognos Cache Prompts

[ordotan]

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

[ordotan]

Of cource I meant DQM instead of CQM  ;)

[ordotan]

Anyone ?

[CognosPaul]

Have you tried running a job to cache the prompts? I believe those cache options only in conjunction with a job.