Quarters labeled as Q2 2006 created under year 2005

[SueC]

I have never seen this happen before.  I've generated a date dimension and Q2 thru Q4 under 2005 are labeled as Q2 2006, Q3 2006 and Q4 2006.  Q1 is fine.  The months and weeks under that are fine.  The same thing is happening under 2006!  What's going on?  Anyone ever seen this before?

I've attached the mdl if anyone wants to take a peek.  (It's probably something really stupid......)

Sue

[Draoued]

in the "Order by" tab in the Quarter level properties , try using Alpha Sort instead of Numeric .

[SueC]

I changed the sort but it didn't make any difference.    :'(

[rcube50]

Is the Times dimension created manually or did you let transformer build it up for you.

[SueC]

I've done it both ways with same results.

[bt2133]

I've only seen this happen when the date is not correct in the diagram "drill category". If you edit the properties of the date in what i believe is the "drill category"Ã,  then that should dictate what months appear in each folder (year/quarter/month.

Brian