Interested to Buy Any Domain ? << Click Here >> for more details...
How to do performance tuning on reports.
- 3 Answers
- 14626 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 |
Imagine this, you are required to reset the password for all users at a time. How would you do that?
What is an i-server? What are the different modes to run it?
What are level metrics? Why are they needed?
Your application mode has crashed. How would you get the instance back?
Write different kinds of objects in microstrategy?
What is microstrategy desktop?
Can microstrategy desktop access sap data?
What do you mean by mstr? What are the different types of mstr objects?
Is it possible to see the data in dataset?
What are prompted filters?
How to use value prompt and drag it on to report editor
What are the benefits of using microstrategy intelligence server?
Teradata 
