How to do performance tuning on reports.
Answers were Sorted based on User's Feedback
Answer / pritika
Performance tuning on reports is done by the help of VLDB
property in MSTR.
| Is This Answer Correct ? | 14 Yes | 1 No |
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 |
Answer / praveen
For performance tuning
1)it is done with the help of VLDB properties
2)check the intermediate sql passes and try to reduce the passes
3)apply filter conditions where ever required.
4)No cross join to be happened
| Is This Answer Correct ? | 4 Yes | 0 No |
What do you mean by dimensional modeling and relational modeling? Which one do you use in dw? Why?
In Microstrategy, how can you direct the sql generated to use a specifc table?
Explain the Roles in mstr?
What are the various ways of incorporating security in microstrategy?
Is it possible to use microstrategy object manager while other users are making changes in microstrategy agent?
Explain fact relation?
what specific features and functionality do you get with olap services?
What formatting can be applied to the information that is sent out by microstrategy narrowcast server?
What are the benefits of using microstrategy intelligence server?
What are the different types of mstr objects?
How conflicts occur and what are the ways to resolve them?
What is the command manager?