Skip to Content
0

Calendar Year / Week (Current week + Futures weeks)

Mar 09, 2017 at 03:40 PM

311

avatar image

Hi

I am creating a BEx query and i need to show Calendar Year/Week but I only want to show current week and the future weeks till the end of the current years.

For example if current week number is 11 then it show 11, 12 13, 14 ----- all the way till 52.

I dont want to show the past weeks.

How can I achieve this in BEx.

If its not possible in BEx what syntax can i use in the webi to achieve this

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

AMIT KUMAR
Mar 09, 2017 at 04:50 PM
0

do you have calendar date object in BW? if yes then build one bex query on this object and place the condition to brign back date from current date to end of year.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

No I dont have this in the model...

Is this not easier on the webi side, if yes what would be the syntax logic i can use on the webi variable.

Thanks

0
avatar image
Former Member Mar 30, 2017 at 08:51 PM
0

hi,

you can create 2 customer exit. The first variable to derive the current year (it should be a standard one) and the second one to derive the current week. Then in the query filter by calendar year = first variable, cal week >= second variable.

Best regards,

Antonio

Share
10 |10000 characters needed characters left characters exceeded
Koen Hesters Mar 31, 2017 at 12:55 PM
0

Hi,

use calendar year/week restrict it with a range, from is current calendar week (standard SAP variable) and to is the same with offset of +52

use calendar year as well and restrict it with current year (standard SAP variable)

best solution is to do it in BEX, not in webi

grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded