How to do performance tuning on reports.

Answer Posted / sunil

For performance tuning there some areas where you need to look and work accordingly.

like
1) is there sufficient space so that MSTR can create temporary tables.
2)proper filtering condition.
3)proper joining between required tables.
4) VLDB property
5)optimization (manual, logical and global)

its better if go go in the same order....

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a implicit attribute in microstrategy?

1171


At which levels you can set the vldb properties? Which level has the highest pecedence?

544


Explain oject manager?

589


Does microstrategy intelligence server run on windows®, unix®, or linux®?

558


Explain rw document?

688






What are the different types of metrics available in microstrategy?

553


Explain the Roles in mstr?

552


Explain snowflake schema?

589


what specific features and functionality do you get with olap services?

559


How does microstrategy object manager integrate with the microstrategy product suite security model?

564


What is a security filter in microstrategy?

574


Explain security filter?

618


What is level metrics in microstrategy?

589


What is fact degradation?

578


What is the effect of dls on microstrategy?

534