Interested to Buy Any Domain ? << Click Here >> for more details...
How to do performance tuning on reports.
- 3 Answers
- 14295 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 |
Explain fact relation?
Explain the difference between holap and rolap?
Explain two-tier connection?
what are the roles & responsibilities of microstrategy developer?
Explain attribute role?
Hi can any one explain me what is Major Difference between Dashboard and Document Please assist me.
Explain the various types of filters available.
How can the user determine the object id of an object?
Intelligent cube is a public object or schema object in microstrategy?
What are the benefits of using microstrategy intelligence server?
Can the administrator easily maintain and manage microstrategy intelligence server?
What are prompted filters? Have you ever used them? Where?
Teradata 
