How to tune report in MSTR for better performance? What are General steps.

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...

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....

Answer Question  Select Best Answer