Aggregates

[Former Member]

Hello all,

could you please let me know the advantages and disadvantages of aggregates and also when we should not go for aggregates.

Regards

ST

[Former Member]

Hi,

Can you try now:

Regards

Dinesh

[Former Member]

Hi ST,

Refer this thread for for info:

https://www.sdn.sap.com/sdn/collaboration.sdn?contenttype=url&content=https%3A//forums.sdn.sap.com/t...

You can also look at the forum for more info.

Bye

Dinesh

[Former Member]

Hi Dinesh,

I am getting list of top users when I click this link!

Regards

-ST

[Former Member]

Hi ST,

An aggregate is a materialized, aggregated view of the data in an InfoCube. In an aggregate, the dataset of an InfoCube is saved redundantly and persistently in a consolidated form into the database.

Advantages: It speeds up the query performance because the query when executed first looks at the aggregate for data. If the data is not found it is then that the data from cube is fetched.

Disadvantage:We need to maintain the aggregates each time a data load is done. The aggregate occupies space on the database.

To go or not to go for aggregates primarily depends on the query performance. If the query performance is good and the response time is goodthen the aggregates are not needed.

For more info refer:

http://help.sap.com/saphelp_nw04/helpdata/EN/7d/eb683cc5e8ca68e10000000a114084/frameset.htm

Bye

Dinesh