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

why u go for aggregate? tell me one example?

Answer Posted / vinod

to improve performence aggregates r used the main use of
aggregates are

1) when infoobject data is used repeatedley
2) when master data do not change much
3) to improve the performance in reporting
4) aggregates acts like indexes
demerites :-

1) denormilisation of data in cube and aggregates

if u cube contains infoobject object country we can create
fixed aggregate on country


Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe the new BW 3.x authorizations?

1984


How do you enter data in real-time infocubes?

859


What is the calculated key figure?

881


What is customization.

1042


What are the tools to monitor overall query performance.

925


What makes it more advanced than sap business warehouse (sap bw) 7.5?

893


What is start routines.

910


What is the importance of 0requid?

1041


which patch u used presently? How can I know which patch that one?

1426


What are different types on virtual providers?

947


What is update routines.

907


how would you re-assign to proper component?

2338


What are the conversion routines for units and currencies in the update rule?

893


Where do you store your custom images (like logos)?

2388


How would you know if a segment/segment level entry has been summarized?

1771