Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are consolidations?

876


What are objects?

992


Is microstrategy desktop available in other languages?

990


What is transformation metric in microstrategy?

990


Can a record be inserted and updated in database using microstartegy?

914


Explain adhoc reports?

915


Explain rw document?

1076


What is the difference between absolute filtering and standard filtering?

1016


What is a joint child?

929


Describe implicit attribute?

986


What specific features and functionality do I get with olap services?

931


Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?

988


Can microstrategy desktop access operational data systems?

1042


How can the user determine the object id of an object?

915


If your client wanted to customize the null value, how would you do that?

956