Interested to Buy Any Domain ? << Click Here >> for more details...
How to do performance tuning on reports.
- 3 Answers
- 14503 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 public objects?
what do you mean by passthrough functions?
how can you direct the sql generated to use a specifc table?
You have got the requirement from a client. Explain the technical approach you will take now.
What is microstrategy?
Your colleague installed microstrategy on solaris or unix without root access. Will he be able to start/ restart this server?
suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?
What is embedded metric?
Intelligent cube is a public object or schema object in microstrategy?
What do you mean by derived metrics?
you are required to disable webusers to use only one i-server. How would you do that?
What is the difference between microstrategy and cognos reporting tool?
Teradata 
