Interested to Buy Any Domain ? << Click Here >> for more details...
How to do performance tuning on reports.
- 3 Answers
- 14495 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 |
I have 5 different country names and their currencies like India-Rupee, USA-Dollar etc. when I run the report, the report should display only either currencies or country names.How to run the report?
explain html document?
How would you increase the logical size of a table in microstrategy?
what do you mean by passthrough functions?
Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?
You have got the requirement from a client. Explain the technical approach you will take now.
What is an i-server? What are the different modes to run it?
How would you configure wh authentication?
The customer would like to know about his 15days transactions[like 1st day - 15th day]. how would you do this?
Can microstrategy desktop access sap data?
Does microstrategy intelligence server run on windows®, unix®, or linux®?
Difference between project merge and object manager?
Teradata 
