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 / 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 |
Explain batch?
Explain security filter?
Explain four-tier connection?
What is the difference between absolute filtering and standard filtering in microstrategy?
Explain the various types of filters available.
How do you optimize reports in microstartegy?
In Microstrategy, what are Logical Views used for?
6 Answers InfoCepts, Marlabs, Tech Mahindra,
What is a logical size of a table and what does it depend on?
What subtotaling features does microstrategy desktop contain?
how can you direct the sql generated to use a specifc table?
What is level metrics in microstrategy?
Explain transformations?