Aafia K

• Sep 16th, 2015

 

Several approaches can be used independently or mixed together.
a) Create a cube to improve performance
b) Pre-cache the report i.e. schedule the report
c) Ensure database level optimizations are happening like date based partition elimination and index usage
d) others....

Soumya Sharma

• May 24th, 2018

 

1. Avoid custom groups as they create multiple passes.
2. Use caching instead of live data.
3. Can use "partitioning" in case of very large table.
4. When multiple reports in a document are using same attributes and metrics there is performance degradation.Instead we can create a template having common objects and then can use this template as "report as template".
5. Use of caching or I cubes, specially if the reports are non prompted.