What is an aggregate?

Answer Posted / mohan

when my query hits same characterstics and keyfigures daily to reduce the query time i made an aggregate with that particular info objects..

Adv is improve the query performance.
disadv is it takes extra space for same data.so if your customer accepts then you create aggregates or else if it satisfy Thumb rules.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give an example of the content key figure OTOTALSTCK (quantity total stock)?

1733


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

508


Explain table partition?

520


Which datastore object is used?

530


List the steps to configure sd and mm for bw.

504






How would you change the default template?

1546


What is the t-code for query monitor?

558


What are the steps to create classes?

1634


Do you have any idea how to improve the performance of the bw?

542


what is direct schedule and what is meta chain

1741


What exactly do you know about business warehouse statistics?

490


Can you tell something about the data ware-house hierarchy?

509


What are the Oracle specific tuning should be done?

1326


What is an exception cell?

1387


Describe transfer rules?

1736