Is it good to apply aggreagates on low amount of data

[Former Member]

Hi,

I have 9 lakhs records in Cube.It is not so much amount of data.

Will it useful to apply aggregates on infocube.

Thanks & Regards,

Arpit

[sander_vanwilligen · Accepted solution]

Hi Arpit,

Although an aggregate can be useful, I would advice to first check if other aspects of InfoCube modeling are OK. I think of the following:

• Check the Dimensions: not too small but certainly not too big (< 10% of fact table);
• Check if Partitioning on a Time Characteristic is possible (e.g. 0FISCPER).

Especially when using Partitioning you have to compress the InfoCube regularly. Do not wait too long with that (only the last requests can be uncompressed).

Hopefully these actions will increase the performance. If not, then try using an aggregate. You can find more information and modeling tips in SAP Help and on SCN, e.g. .

Best regards,

Sander

[former_member202718]

Hi Arpit,

It depends on your Query Performance...Execute the Query in RSRT+Debug mode and check where the Query is taking time...then accordingly follow the thumb rule to create aggregates..

If there is no issue in query performance then no need to create AGG.

rgds

SVU

[Former Member]

Hi,

Report execution time is reasonable which reports are created on that cube then there is no need to create the aggregates. if more time is taking for report execution then you go for creation of aggregates.

Thanks & Regards,

Srinu.Rapolu