cancel
Showing results for 
Search instead for 
Did you mean: 

Aggregates

Former Member
0 Kudos
229

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

Can you try now:

Regards

Dinesh

Former Member
0 Kudos

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
0 Kudos

Hi Dinesh,

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

Regards

-ST

Former Member
0 Kudos

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