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

Can you restart the conversion?

1477


Does it have delta facility?

1717


Without taking downtime how to fill logistics extractors (2lis types)

1208


What is Infoset Query?

589


Can you add programs in the scheduler?

546






Can you add data records in the user exit?

1542


What is the number of decimal places in scaling factor?

1562


What are the different types of infocube?

508


What is an infoobject and why it is used in sap bi?

555


Extraction in mm and SD and FI? What is the requirement and name them?

1674


What is the data target administration task?

530


What does rollup do?

575


What are the load process and processing?

510


What is CO-PA retraction?

1683


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

1965