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 fact constellation schema?
How would you configure wh authentication?
what is the difference between the report filter and report limit?
Explain security filter?
Can microstrategy desktop access operational data systems?
What is rank metrics in microstrategy?
what is a security filter?
How conflicts occur and what are the ways to resolve them?
What are prompted filters?
Explain microstrategy logical primary keys?
How is security handled?
what are the advantages of dataset compare to fileset?