Week Offsets

[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> Week1 Weekk2 Week3 Week4

<b>Release date</b>

Please suggest me how to do this.

Thanks,

Sudhakar.

<b>Actual Sales</b>

<b>Target sales</b>

[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.

[j_vandersterren]

Hello,

You can create a restricted key figure with sales and week. In the week you can create a variabele type customer exit.

This variabele you can fill in a user exit (ZXRSRU01) with the help of ABAP.

Hopes it works.

Regards,

Jos.