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

What is the difference between ods and info-cubes?

1034


When coding the ABAP transfer rule, what are the important variables you make

2309


What is info provider documentation?

2529


How do you convert web objects from 2.x to 3.x?

2048


What is an infopackage?

974


What is translation key?

2001


What does the program RSMDCNVEXIT check?

2538


Compare info cubes with operational data store?

973


How does a navigational attribute differ from other attributes in terms of linking it with the infocube?

920


What is the format of LO data sources?

2072


What is delete table before extraction option?

1806


Is the user exit common for all data sources?

1889


What are the general services supported?

1892


What are the different type of infoset joins?

974


You have 3 cube for which you create multiprovider and a report. The data doesn't show up in the report. What went wrong?

885