Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS PowerPlay => Topic started by: SueC on 20 Feb 2006 06:23:43 PM

Title: Quarters labeled as Q2 2006 created under year 2005
Post by: SueC on 20 Feb 2006 06:23:43 PM
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
Title: Re: Quarters labeled as Q2 2006 created under year 2005
Post by: Draoued on 23 Feb 2006 10:36:57 AM
in the "Order by" tab in the Quarter level properties , try using Alpha Sort instead of Numeric .
Title: Re: Quarters labeled as Q2 2006 created under year 2005
Post by: SueC on 24 Feb 2006 09:33:03 AM
I changed the sort but it didn't make any difference.    :'(
Title: Re: Quarters labeled as Q2 2006 created under year 2005
Post by: rcube50 on 24 Feb 2006 02:01:24 PM
Is the Times dimension created manually or did you let transformer build it up for you.
Title: Re: Quarters labeled as Q2 2006 created under year 2005
Post by: SueC on 24 Feb 2006 02:04:07 PM
I've done it both ways with same results.
Title: Re: Quarters labeled as Q2 2006 created under year 2005
Post by: bt2133 on 12 Apr 2006 01:35:50 PM
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
Text only | Text with Images