MSTR Performance Tuning

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

Questions by anandvishnu2010   answers by anandvishnu2010

Showing Answers 1 - 6 of 6 Answers

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

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions