Skip to Content
avatar image
Former Member

Is it good to apply aggreagates on low amount of data

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 01, 2015 at 09:16 AM

    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. SAP BW Query Performance Tuning with Aggregates.

    Best regards,

    Sander

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 01, 2015 at 06:28 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 01, 2015 at 06:35 AM

    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

    Add comment
    10|10000 characters needed characters exceeded