Script Logic

Dear Experts,

I am working on a BPC 10.1 NW implementation and we have a below requirement.

Operating plan (PLNV01) for future year starts in current year Aug month and is seeded from July FC (up to July Actual values and July to
Dec plan values).

For above requirement I prepared script logic as below.

*SELECT(%YEAR1%,[YEAR],TIME,ID =%TIME_SET%)

*SELECT(%SM%,"[STARTMNTH]",VERSION,"[ID]='%VERSION_SET%')

*SELECT(%FCSTMNTH%,"[ID]",TIME,"[ID]>='%YEAR1%.%SM%'")

*SELECT(%ACTMNTH%,"[ID]",TIME,"[ID]<'%YEAR1%.%SM%'")

//To copy FORECASTXX we use

*XDIM_MEMBERSET VERSION= %VERSION_SET% //%PRIVFCST%

*XDIM_MEMBERSET TIME=%YEAR1%.%SM%,%FCSTMNTH%

*WHEN VERSION

*IS *

*REC(EXPRESSION=%VALUE%,VERSION=PLANV01)

*ENDWHEN

//To copy ACTUAL we use

*XDIM_MEMBERSET VERSION=Actual

*XDIM_MEMBERSET TIME=%ACTMNTH%

*WHEN VERSION

*IS *

*REC(EXPRESSION=%VALUE%,VERSION=PLANV01)

*ENDWHEN

With the above logic am able to get the values for required Category (PLANV01) of Current Year but not for the Future Year.

Please help me in modifying the logic to fulfill my above requirement.

Thanks,

Niranjan