Post reply

Cube processing

  • September 4, 2012 at 11:23 pm

    #280806

    Hi All,

    i have 10 cubes in my solution, individual cube sizes are 21GB, 50GB, 19GB so on..

    when am trying to process the cubes it is taking 4 hours, can u please tell me the way to reduce it.

    i have 3 years of data in my cubes.

    please tell me the best way to reduce it.

    thanks in advance

    Niharika

  • September 5, 2012 at 3:39 am

    #1533694

    Which processing mode do you use?

    Do you have partitions? Do you need to refresh data that is 3 years old? I would think you'd need only to process the last months perhaps.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • September 6, 2012 at 5:23 am

    #1534393

    If you are using Standard edition, you can't use partitions. If you are using Enterprise edition, I would suggest breaking out your data into partitions. You can refresh the most recent partitions only.

  • September 6, 2012 at 4:39 pm

    #1534792

    Try incremental updates

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply