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 security filter?
Explain about Microstrategy Report execution process?
What is a logical size of a table and what does it depend on?
Explain oject manager?
What is a implicit attribute in microstrategy?
Explain rw document?
How do we resolve attribute roles in microstrategy?
What leads to a cross-join or how does a cross-join occur?
Can a record be inserted and updated in database using microstartegy?
What are different types of metrics in microstrategy?
What is fact extension?
How to do performance tuning on reports.