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
Explain true primary keys?
What do you mean by xml cache?
Can I deploy a single bi application in multiple languages?
What is percent-to-total shortcut metric in microstrategy?
What are level metrics? Why are they needed?
Your i-sever crashed. What will you do?
How do you achieve schema object version control?
How is security handled?
Can schema objects be copied across projects with microstrategy object manager?
Explain the difference between rolap and molap?
What is a logical size of a table and what does it depend on?
What is microstrategy desktop?
What is a compound attribute in microstrategy?
Your application mode has crashed. How would you get the instance back?
What specific features and functionality do I get with olap services?