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