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
suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?
Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?
What is the command manager?
What are the different types of metrics available in microstrategy?
Explain adhoc reports?
Explain security role?
What is metadata in microstrategy?
what are the different types of tests done on a microstrategy report?
How is security handled?
What is purpose of having conditionality in metrics in microstrategy?
what are passthrough functions?
How does microstrategy object manager determine if two objects in different projects are the same?
Explain the Roles in mstr?
Explain the various types of filters available.
Can we access multiple operational databases from within a single microstrategy project?