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.



A report is taking few seconds to run.The same report is taking very long time on the next day witho..

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

Post New Answer

More Micro Strategy Interview Questions

What is a logical size of a table and what does it depend on?

0 Answers  


What is microstrategy desktop?

0 Answers  


How would you configure wh authentication? Explain.

0 Answers  


Can we access multiple operational databases from within a single microstrategy project?

0 Answers  


How to use value prompt and drag it on to report editor

3 Answers   Infosys,






How does microstrategy object manager determine if two projects are related?

0 Answers  


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.

6 Answers   Target, TCS,


What is the Minimum Qualification to learn the micro strategy course.??

1 Answers   Minacs,


suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?

0 Answers  


What according to you are the roles and responsibilities of a microstrategy developer?.

0 Answers  


What are intelligent cubes?

0 Answers  


Your application mode has crashed. How would you run your i-server?

0 Answers  


Categories