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 |
Is it possible to get a floating window in microstartegy web? If yes, how?
Is there a difference between view filter and report filter?
Can you create an event based schedule in microstrategy? How?
What is metadata in microstrategy?
If a microstrategy intelligence server node is removed from a cluster manually, will report caches be lost?
Explain the various types of filters available.
Explain fact constellation schema?
How does microstrategy object manager determine if two projects are related?
Is it possible to limit the number of reports run by a users at a time? How? What will happen if this limit is exceeded?
you are required to disable webusers to use only one i-server. How would you do that?
Which of the end-user items leverage olap services?
Name the types of transformation?