Sub-totals make report slow

[sthabinash]

I have a report with multiple regular dimensions and subtotals (summarizes) at different levels. When I run the report without any sort of subtotals, the report runs in about 20-30 sec. But when I add the subtotals the reports takes about 2min to run :'( .

How can I minimize this additional time taken?

[CognosPaul]

DMR, OLAP, or relational? DQM or CQM? How many levels of nesting in your report?

[sthabinash]

Its DMR report with DQM. It contains 5 level of nesting and each nesting level being regular dimension

[CognosPaul]

Are you subtotaling each level of nesting? What method are you using to subtotal?

Make sure it's: total(currentMeasure within set [Data item]) instead of within detail

If that doesn't work, try nesting a data item into itself instead of the subtotal.