Bpc script logic fo month

[Former Member]

Hi,

*XDIM_MEMBERSET  TIME AS %TEST_LIST%=%TIME_SET%
*XDIM_MEMBERSET  ACCOUNT=BAS(ALB10ISC)
*XDIM_MEMBERSET  CATEGORY=%CATEGORY_SET%

*XDIM_MEMBERSET  GROUPS=EQP
*XDIM_MEMBERSET  MARKET=BAS(M_ALL_MKT)
*XDIM_MEMBERSET  RPTCURRENCY=USD
*XDIM_MEMBERSET  TIME = TMVL(-12,%TIME_SET%)
*XDIM_MEMBERSET  MEASURES=YTD

*WHEN CATEGORY
*IS ACTUAL

*REC(FACTOR=1, ACCOUNT=ALLOCINC, CATEGORY=%CATEGORY_SET%, DATASRC=FACTOR,  TIME=%TEST_LIST%)

*ENDWHEN

i need to calucalte the time period for factor dynamically in the script code.

suppose i pass 2012.OCT the factor time period has to be 2011.OCT.(The scipt is working perfectly)

if i pass 2012.DEC the factor also has to calucalte 2011.OCT.

morever the month should be OCT and ther year should be -1.

Thanks,

Mmishra

[former_member186338]

See answer in the second post.

Vadim