Last Day in Calender Week for all the weeks

Hello Experts,

I have one requirement to show lastday of the calender week. I have one key figure in rows, and 0CALWEEK in columns.

We are using this report in the graph, graph is displaying the weeks in rows and key figure values in columns, because i used column graph in WAD.

My requirement is to replace all the week values with lastday in that corrending week. For example we have weeks in the graph 39/2009, 40/2009, 41/2009 and 42/2009. These should be replaced with lastday of that weeks like 09/21/2009, 09/28/2009, 10/05/2009 and 10/12/2009. To get these values i used the FM WEEK_GET_FIRST_DAY, if i get the firstday, I can get the lastday easily. We have only Calender Week, Fiscal Year and Fiscal Period, we dont have 0CALDAY in the CUBE. I have to achieve without 0CALDAY.

How can i get the solution?

Any help?

Thanks in advance,

Venky

Edited by: Venkatesh S on Sep 11, 2009 10:56 AM