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.