Skip to Content
0
Former Member
Jun 02, 2011 at 04:50 AM

TIME=NEXT(2) NOT WORKING IN SAP BPC NW

40 Views

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