COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: Kattrix on 23 Nov 2005 12:55:47 PM

Title: 53 week year - extra days not working
Post by: Kattrix on 23 Nov 2005 12:55:47 PM
Transformer 7.2

In 2003, we had a 53 week fiscal year starting with 12/29/2002.
I cannot get Transformer to recognize this properly.
Year and Qtr are lunar, Months are 4-4-5 with extra week set at 4 or more.

If I choose a year start date of 12/29/2002, it recognizes the 53 week year, but it labels all dates for 2003 as 2002, 2004 as 2003, and 2005 as 2004.

If I choose a year start date of 01/04/2004, it doesn't pick up the 53 week year for 2003.

We have a strong need for relative time dimensions, so I cannot use special categories.

Any ideas?
Title: Re: 53 week year - extra days not working
Post by: Opher on 05 Dec 2006 06:34:27 PM
I beleive that if you set "Enable Lunar Fiscal Labeling" under File / Preferences that will solve your problem.

Good luck,
Opher