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 confirmed dimensions. When are they used?
Your application mode has crashed. How would you run your i-server?
Explain four-tier connection?
what specific features and functionality do you get with olap services?
Explain star schema?
What are the supported languages for microstrategy intelligence server?
metric filter and report have a another filter which is highest priority ? why?
What is a compound attribute in microstrategy?
Explain rw document?
what is a security filter?
What do you mean by bulk export report?
What according to you are the roles and responsibilities of a microstrategy developer?.