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 / praveen

For performance tuning
1)it is done with the help of VLDB properties
2)check the intermediate sql passes and try to reduce the passes
3)apply filter conditions where ever required.
4)No cross join to be happened

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Your application mode has crashed. A.) How would you run your i-server? B.) How would you get the instance back?

852


Explain object variable error?

921


What are the different types of metrics available in microstrategy?

905


What are the types of facts in microstrategy?

967


Explain level extension?

960


Difference between project merge and object manager?

950


What subtotaling features does microstrategy desktop contain?

925


At which levels you can set the vldb properties? Which level has the highest pecedence?

895


What do you mean by dimensional modeling and relational modeling?

830


Explain fact structure?

928


Explain microstrategy logical primary keys?

913


Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?

820


Explain snowflake schema?

967


Explain oject manager?

951


Is there a difference between view filter and report filter?

869