5 Replies Latest reply: Jul 29, 2011 8:00 AM by Roland Kunle RSS

    Generating sequence number

      Hi,

       

      How to create a sequence number for the Weeks available in calendar table from start to end date....

       

      Calendar dimension have 2 years(2010 and 2011) of data and I need to generate the week number for these years...

       

      Week numbers of 2010 will be from 1 to 52...for 2011 it should be start from 53... So week numbers of 2011 should be 53-104...