Post reply

SSAS cube

  • January 24, 2018 at 4:29 pm

    #342985

    Hi,

    We have a Analysis Services cube that we process in Full on a weekly basis and have noticed recently that it takes a lot longer to process than it did before.
    We haven’t changed the structure of the cube.

    Can you please suggest  troubleshoot steps?

    Thanks

  • January 24, 2018 at 8:58 pm

    #1977243

    adisql - Wednesday, January 24, 2018 4:29 PM

    Hi,

    We have a Analysis Services cube that we process in Full on a weekly basis and have noticed recently that it takes a lot longer to process than it did before.
    We haven’t changed the structure of the cube.

    Can you please suggest  troubleshoot steps?

    Thanks

    Please check on the dims and facts in your model, whether the tables have been blocked by other processes. Process full drops and recreates the

    objects inside SSAS cube. So please  check on the dim / fact structure changes.

  • January 25, 2018 at 9:16 am

    #1977371

    subramaniam.chandrasekar - Wednesday, January 24, 2018 8:58 PM

    adisql - Wednesday, January 24, 2018 4:29 PM

    Hi,

    We have a Analysis Services cube that we process in Full on a weekly basis and have noticed recently that it takes a lot longer to process than it did before.
    We haven’t changed the structure of the cube.

    Can you please suggest  troubleshoot steps?

    Thanks

    Please check on the dims and facts in your model, whether the tables have been blocked by other processes. Process full drops and recreates the

    objects inside SSAS cube. So please  check on the dim / fact structure changes.

    Thank you !!

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

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