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

How many types of info sources are there? What are they?

2241


What is the purpose of geographical information in the sap bw?

992


What is a temporal join?

1101


If you are asked to change the way tables are displayed in web reporting how would you do this?

1878


What are the different type of infoset joins?

1023


what is direct schedule and what is meta chain

2703


How do you do EURO conversion at the database level?

2180


What are the load process and post processing?

2081


What is sap bw/bi? What is the purpose of sap bw/bi?

922


What are the report-relevant settings in the hierarchy maintenance?

1989


Can you tell something about the multi-provider in the sap and how it is useful for the users?

1009


what are the drawbacks of ods?

1104


How do you install business content AWB?

2303


Which transaction on R/3 shows the transactions with pending processes for update?

2021


What are the types of reports you can use in reporting agent?

2105