A report is taking few seconds to run.The same report is taking very long time on the next day without doing any kind of changes in the report. What could be the reason? how do you tune the report.
Answer Posted / balav
First make sure you,
1. Check for the Backend loads being run on the time of report execution.That might also impact the report execution time.
2. But in future to avoid this long run, you can check the SQL global optimization setting of VLDB properties.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is an i-server?
what are logical views used for?
What is adaptive metric?
differentiate between two-tier, three-tier and four-tier connections.
Explain adhoc reports?
What does microstrategy desktop allow users to do?
Name the types of transformation?
Explain level extension?
How do users receive only information that they want?
What subtotaling features does microstrategy desktop contain?
What is pass through metrics in microstrategy?
Can a record be inserted and updated in database using microstartegy?
Explain heterogeneous mapping?
To save time, can many reports be run at the same time?
What is an object prompt?