Calmonth calculation from week

[Former Member]

Is their any way I can calculate month from the week.

Week number is maintained in the fiscal year variant.

I didn't received month value in the input file.I am getting only the calweek value.

Please advise on this

Thanks

[Former Member]

In the Transfer rule Formula.

Hope this helps

[Former Member]

Thanks SAPBW D

kedar

[Former Member]

0calmonth -created formula

DATE_MONTH( ( WEEK_TO_1ST_DAY( Calendar Year/Week ) ) ).

I am getting exact month.

Thanks for all help

[Former Member]

Hi SAPBW 😧

Can u plz tell me where did u created that formula.

do u mean in UR?

thanks

kedar

[Former Member]

I have asigned in the transfer rule,

0calmonth -0calmonth

0calweek -0calweek

0FISCVARNT - 0FISCVARNT

Input file I am getting value only for 0calweek.

I try to execute report from cube and ODS .Calmonth displays only # value

Do I need to assign something like this for month

0calmonth -0calweek

[edwin_harpino]

hi,

you can try add 0calmonth in your infoprovider

and populate with 'time distribution'

http://help.sap.com/saphelp_nw2004s/helpdata/en/af/ad259f84cf11d5b2fe0050da4c74dc/frameset.htm

hope this helps.