Author Topic: Date Dimension has got jumbled  (Read 2249 times)

Offline noscog

  • Associate
  • **
  • Join Date: Jun 2012
  • Posts: 4
  • Forum Citizenship: +0/-0
Date Dimension has got jumbled
« on: 07 Dec 2012 03:51:52 am »
Our cubes have historically always been fine, but all of a a sudden, in our date dimension, the week for week 1 of december 2012 shows as being November 2011.

I have a feeling that these dates are actually key'd into Powerplay Transformer manually, so the question is, how do I alter the date value for that week? The dates at the "Day" level are correct (2012), but the date that appears in the week level is wrong, it should read 30-Nov-2012.

Any ideas?
« Last Edit: 07 Dec 2012 03:56:30 am by noscog »

Offline nmcdermaid

  • Senior Consultant
  • Community Leader
  • *****
  • Join Date: Apr 2010
  • Posts: 76
  • Forum Citizenship: +1/-0
Re: Date Dimension has got jumbled
« Reply #1 on: 21 Jan 2013 09:31:26 pm »
You need more than a feeling! You need to go into Transformer and work out how the dates are generated - are they supplied from the datasource, built from a wizard or created manually?

Once we know that we can help.