2

I have a Date Dimension called Dim_Date in my Data Warehouse. Now the issue is that my Date Dimension is only populated till 31st Dec 2011. My cube is built in SSAS. Is there any way I can populate my Date Dim for another 5 years? When I try to Process my Date Dimension from SSAS it does not populate any values. SO what is the best way to insert 5 years value into my date dimension?

Please Help

Cheers Rushir

JotaBe
  • 38,030
  • 8
  • 98
  • 117
ace_mccloud
  • 497
  • 1
  • 8
  • 25
  • I'm not sure what your problem is, presumably you can use the same script that you used to populate the existing data, but just change the end date? A search on this site for "populating calendar table" or similar should give you a solution. – Pondlife Feb 02 '12 at 08:07

1 Answers1

1

You could use an ETL tool (e.g. MS SSIS) for generating data for date dimension table. There is multiple examples for this, google is your friend.

jrara
  • 16,239
  • 33
  • 89
  • 120