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.
(http://i49.tinypic.com/9fungm.jpg)
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?
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.