Weeks calculation from the date

[Former Member]

Hi BW mates,

I am currently working on SCM Queries. I have a report where I have to display the sales for 16 weeks from the date of release of cinema.

For eg.

In rows, Title and Release date are displayed in rows. In columns data is displayed with Wee1, Week2,,,,,,,,,up to Week 16.

Generally using Off sets we can achieve using current week. But here I have to consider the release date. The release date is nothing but the equals to current week from there it has to show all 16 weeks invidually

<b>Title</b> <u>Week1 Weekk2 Week3 Week4</u>

<b>Release date</b>

<b>Actual Sales</b>

<b>Target sales</b>

Please suggest me how to do this.

Thanks,

Sudhakar.

[Former Member]

hi,

you can use use a flag in the update rule with 16 values e.g. A,B,C.....L for 16 weeks. pupulate the flag based on the release date.There is a function module which convert date to week. Once this is done create a restricted Key figure in BEx restricting the sales based on the flag i.e A for WEEK1, B for WEEK2.

Hope this helps.