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 the difference between holap and molap?
how can you direct the sql generated to use a specifc table?
What is dynamic aggregation in microstrategy?
What security is provided with microstrategy desktop?
Can you create an event based schedule in microstrategy? How?
Explain two-tier connection?
Your account is locked and your administrator has forgotten the password. What would you do?
What do you mean by trimming sql in microstrategy?
How would you configure wh authentication? Explain.
What are logical views used for in microstrategy?
The customer would like to know about his 15days transactions[like 1st day - 15th day]. how would you do this?
What is the command manager?