HI GURUS,
I had a requirement that user enters a data for JAN month, and i need to copy the data in to next months.
my script logic code is:
*XDIM_MEMBERSET ACCOUNTL=0000110171,0000111171
*XDIM_MEMBERSET CONSGROUP=LC
*XDIM_MEMBERSET C_CATEGORY=PLAN
*XDIM_MEMBERSET C_DATASRC=UPLOAD
*XDIM_MEMBERSET FLOW=F_NONE
*XDIM_MEMBERSET P_LOCATION=DEL
*XDIM_MEMBERSET RPTCURRENCY=LC
*XDIM_MEMBERSET U_ENTITY=CO_1004
*XDIM_MEMBERSET U_INTCO=I_NONE
*XDIM_MEMBERSET TIME=2011.JAN,2011.FEB,2011.MAR.....
*WHEN ACCOUNTL
*IS 0000110171
*REC(EXPRESSION=%VALUE%,TIME=NEXT(1),ACCOUNTL=0000111171)
*ENDWHEN
*COMMIT
For this i added a property NEXT in time dimension with the following memberset
ID .... NEXT...
2011.JAN 2011.FEB
2011.FEB 2011.MAR
I Tried with many logics.. but not able to rectify
*XDIM_MEMBERSET TIME=%TIME_SET%
TIME=[%TIME_SET%].CURRENTMEMBER.PROPERTIES("NEXT")
To copy the data in to 2011.FEB,2011.MAR......
please give me a solution.
Points will be awarded for good answers
Thanks & Regards
Swathi Roy