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?
DMR, OLAP, or relational? DQM or CQM? How many levels of nesting in your report?
Its DMR report with DQM. It contains 5 level of nesting and each nesting level being regular dimension
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.