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 are consolidations?
What are objects?
Is microstrategy desktop available in other languages?
What is transformation metric in microstrategy?
Can a record be inserted and updated in database using microstartegy?
Explain adhoc reports?
Explain rw document?
What is the difference between absolute filtering and standard filtering?
What is a joint child?
Describe implicit attribute?
What specific features and functionality do I get with olap services?
Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?
Can microstrategy desktop access operational data systems?
How can the user determine the object id of an object?
If your client wanted to customize the null value, how would you do that?