Skip to Content
0
Former Member
Jun 04, 2013 at 09:19 AM

Bpc script logic fo month

27 Views

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