Hi experts
Our client reported a problem with one of our reports. After testing it seems when the date range becomes too big, the report just can't process the information.
I've done countless searches on ways to improve performance both in BO and in database. Array fetch size in universe etc, indexing, aggregation
However, I don't understand this 'point of critical mass' where the report stops running and I can't find any related posts.
I'd love a top 10 things to do to improve performance!
Any advice welcomed.
Regards
Eddie