Last Day in Calender Week for all the weeks

[former_member190390]

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

[Former Member]

if you can with this functional WEEK_GET_FIRST_DAY to get the firstday, then you need only to add 7 days to get lastday.

[Former Member]

Hi,

Have you thought about attribute of 0CALWEEK -> 1st day of week (you can fill it in 0CALLWEEK transfer routine)?

Then you can use it in any query (as display or navigational).

Regards,

DL