Interested to Buy Any Domain ? << Click Here >> for more details...
How to do performance tuning on reports.
- 3 Answers
- 14412 Views
- I also Faced
- E-Mail Answers
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 are the types of facts in microstrategy?
Define different types of attributes in microstrategy desktop?
What are report filters and view filters?
How do we resolve attribute roles in microstrategy?
I want to learn Microstrategy Tool...Can you help me to find best coaching center for Microstategy..please send details to maheswari.umaece@gmail.com Thanks and Regards, Uma
Can intelligence server integrate with my existing data structure?
Compare dataset and fileset?
Explain the difference between holap and molap?
what is the difference between microstrategy and cognos?
Do you know how to prioritize the excecution of a report?
Explain the difference between rolap and molap?
What is the order of precedence of vldb properties?
Teradata 
