Post reply

Deployment Wizard for SSAS

  • August 14, 2017 at 10:21 am

    #149494

    Hi,

    I used the deployment wizard to deploy some changes to an OLAP database.(SSAS)

    The changes were

    Two new dimensions
    A new Fact
    A new measure group

    I purposely retained existing partitions and roles beacause there are quite a few partitions

    However I noticed when I did this although it retained the structure of the partitions it left them all in an unprocessed state so I have to process them all anyway!
    Has anyone else noticed this or is it something I am missing?

    Nat

  • August 14, 2017 at 6:18 pm

    #1955240

    So keep in mind the options you selected didn't say "keep my partitions processed no matter what".
    Most likely the new structures invalidated the current data and if its an MD cube then the dimensions themselves would have done it.

    Here is a link that can explain all of this much better than myself.

    http://www.jamesserra.com/archive/2012/05/being-careful-in-ssas-to-not-make-a-cubedimension-unprocessed/

  • August 17, 2017 at 3:39 am

    #1955627

    Thanks. That was a useful read

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

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