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

Can any 1 plz tell me How to identify the missing delta's to run the repair full request,and vat are the extractors used in lo cockpit,if i use filter on condition which 1 will execute first?,

2402


What internally happens when bw objects like info object, info cube or ods are created and activated?

1066


When to virtual providers based on dtp?

963


what is the include program name?

2128


How do you enter data in real-time infocubes?

913


R/3 extraction failed - recovery procedure? R/3 extraction is running from past 2 years. Suddenly it failed since 5 days and again today it is running fine. But how i do get data loaded to cube for failed loads? What are the procedures that can be followed?

2718


What are the advantages of new LO extraction?

2306


Can you convert an infopackage group into a process chain?

1103


What are the options to calculate result as ? summation?

2004


What are the expressions allowed?

1899


How do start routine and return table synchronize with each other?

892


What are the differences between v1, v2, v3 jobs in extraction.

1057


When are tables created in bw?

1018


iam looking for some scenarion on reporting concepts like - replacement path,customer exits, all types of variables. plese send me some important links and materials. so it will be helpful for me. thanks in advance

1918


What is the function of the ‘reconstruction’ tab in an info cube?

1015