giuseppeminasola
IS-IT--Management
Hi everyone; i used the IBM document "Modeling Relative Time as Measures" to succesfully manage current and previous year.
The problem is that if i select February 2010 i correctly see also February 2009 as previous year period; if i select February 2009, i get wrong values in February 2008 because it was a leap year with 29 days in February.
I want Cognos to compare the 2 months, even if in 2008 we had 29 days and in 2009 28 days.
How to do it? I also have a time table where i have a field to obtain "leap years".
Thanks a lot!
The problem is that if i select February 2010 i correctly see also February 2009 as previous year period; if i select February 2009, i get wrong values in February 2008 because it was a leap year with 29 days in February.
I want Cognos to compare the 2 months, even if in 2008 we had 29 days and in 2009 28 days.
How to do it? I also have a time table where i have a field to obtain "leap years".
Thanks a lot!