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...

How to do performance tuning on reports.

Answer Posted / sunil

For performance tuning there some areas where you need to look and work accordingly.

like
1) is there sufficient space so that MSTR can create temporary tables.
2)proper filtering condition.
3)proper joining between required tables.
4) VLDB property
5)optimization (manual, logical and global)

its better if go go in the same order....

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

936


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?

963


What is the command manager?

956


What are the different types of metrics available in microstrategy?

923


Explain adhoc reports?

886


Explain security role?

886


What is metadata in microstrategy?

1052


what are the different types of tests done on a microstrategy report?

862


How is security handled?

946


What is purpose of having conditionality in metrics in microstrategy?

934


what are passthrough functions?

904


How does microstrategy object manager determine if two objects in different projects are the same?

999


Explain the Roles in mstr?

932


Explain the various types of filters available.

943


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

1005