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 |
What is a logical size of a table and what does it depend on?
What is microstrategy desktop?
How would you configure wh authentication? Explain.
Can we access multiple operational databases from within a single microstrategy project?
How to use value prompt and drag it on to report editor
How does microstrategy object manager determine if two projects are related?
I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can i do it and drag it onto report editor.
What is the Minimum Qualification to learn the micro strategy course.??
suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?
What according to you are the roles and responsibilities of a microstrategy developer?.
What are intelligent cubes?
Your application mode has crashed. How would you run your i-server?