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 batch?
what is a security filter?
Explain object variable error?
What are prompted filters?
Explain access control?
How to use value prompt and drag it on to report editor
Does microstrategy intelligence server run on windows®, unix®, or linux®?
How are microstrategy reports performance tuned?
What is non-aggregate metric?
suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?
Compare microstrategy and tableau.
What do you mean by dimensional modeling and relational modeling? Which one do you use in dw? Why?