Need to Improve the Performace of a report

[satheeshgouda]

Report is taking longtime to display the data but its taking decent time to display the view tabular data.

In the report, we are calculating the buckets depending upon the date which is selected by user, i.e 0-15 days ageing, 15-30 days ageing, 31-45 days ageing etc.

For 0-15 days ageing bucket we have a formula and also 15-30 days ageing is depending upon the previous bucket, i.e 0-15 days ageing bucket, like this we have 16 to 17 buckets are there.

Is there any approach to improve the performance of the report? From ETL side, we can’t calculate the buckets because these buckets are dependent on the date selected by user in the report.

If any one of you have worked on similar issue, Please Share your knowledge, Please help as its very urgent.

[Suraj]

One of the places where report takes time is during runtime calculation.
sometimes just by changing the aggregation properties makes a huge difference.
Another way is to break the query down to multiple queries each getting certain filtered data and then join or union them together.