Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DimTime table help Expand / Collapse
Author
Message
Posted Thursday, January 3, 2013 10:14 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, August 17, 2014 3:50 AM
Points: 329, Visits: 858
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.
Post #1402467
Posted Friday, January 4, 2013 7:23 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:51 AM
Points: 815, Visits: 2,028
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.



Post #1402872
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse