charts - improving perormance

[nsd]

Hi

I have 3 charts (people count/bills #/Conversion Rate)  used with a two column repeater table to generate for two weeks and grouped via page-set for each location. It's extremely slow running because it's generating sqls for everything Cognos needs and requires master-detail relationships.

Is there a way I can tell  Cognos to put the result set somewhere and use that instead of generating and executing SQLs for each chart?

If I have to write custom SQL then please show me how I can pass parameters from prompt pages into SQL (to sql sever).

Is there a checklist to ensure master-detail requests runs fast?

Thanks.