DimTime table help

  • I have a time table that got created through SSAS but it has only data upto 2012. I need to load the data for 2013. How can I do this without messing up my cube? Otherwords, I don't want to re-deploy the cube or re-process the cube.

    I am on 2008 R2 and time table was populated using dimension wizard.

    Thanks for your help.

  • I create my date dimensions manually, but my hunch is the wizard will not help you at this point. You will need a script to add the date values. As you are adding information, there is no way to avoid reprocessing the dimension or all the cubes attached to it (which might be all of them).

    Sorry, as that's not what you want to hear, but you just have to dig in.

    BTW it may be what the wizard gave you for a name, but DimTime usually refers to hours and minutes. DimDate is a better name for a dimension that includes dates. I don't use either, but it helps with consistency.

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

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