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 |
Does microstrategy intelligence server run on windows®, unix®, or linux®?
What is percent-to-total shortcut metric in microstrategy?
what is the difference b/w the public object&schema object
How does microstrategy object manager determine if two objects in different projects are the same?
While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?
What is non-aggregate metric?
Name the types of transformation?
How does microstrategy object manager determine if two projects are related?
Explain fact degradation?
What is static prompt in microstrategy?
what are the different authentication modes available in microstrategy?
Does microstrategy web support clustering via cisco local router or any other third-party clustering software?