Skip to Content
0
Former Member
Apr 07, 2013 at 07:21 AM

Help on Script

37 Views

I need some help on script. I have written this script where I want to copy the value from 1 year to another with inflation of 3%. I am not sure what is wrong in it. Can you pls go through it and let me know if there is something I am missing.

*XDIM_MEMBERSET TIME=BAS(%YEAR%.TOTAL)

*XDIM_MEMBERSET COMPANY_CODE=CO_AB01

*XDIM_MEMBERSET FLOW= F_NONE

*XDIM_MEMBERSET FUNCTIONAL_AREA=FA_NONE

*XDIM_MEMBERSET TRADING_PARTNER=TP_NONE

*XDIM_Memberset ACCOUNT=%ACCOUNT_SET%

*XDIM_MEMBERSET VERSION = %VERSION_SET%

*XDIM_MEMBERSET AUDIT_TRAIL = BPC_INPUT

//*XDIM_Memberset PROFIT_CENTER=%PROFIT_CENTER_SET%

//*XDIM_Memberset COST_CENTER=%COST_CENTER_SET%

//*XDIM_MEMBERSET TIME=%YEAR%

//*SELECT(%YR%,"[YEAR]",TIME,"[ID]='%TIME_SET%')

*FOR %MONTH%=01,02,03,04,05,06,07,08,09,10,11,12

*WHEN ACCOUNT

*IS *

*REC(EXPRESSION = [TIME].[%YEAR%.TOTAL] / 12 * 103%, TIME= "%YEAR%(+1).%MONTH%")

*REC(EXPRESSION = [TIME].[%YEAR%(+1).TOTAL] / 12 * 103%, TIME= "%YEAR%(+2).%MONTH%")

*REC(EXPRESSION = [TIME].[%YEAR%(+2).TOTAL] / 12 * 103%, TIME= "%YEAR%(+3).%MONTH%")

*REC(EXPRESSION = [TIME].[%YEAR%(+3).TOTAL] / 12 * 103%, TIME= "%YEAR%(+4).%MONTH%")

*ENDWHEN

*NEXT

*COMMIT

Now it is giving the below error.

LOG BEGIN TIME:2013-04-06 22:47:12

FILE:\ROOT\WEBFOLDERS\FIN_PLANNING\ADMINAPP\Planning\INFLATION_3.LGF

USER:BASIS

APPSET:FIN_PLANNING

APPLICATION:Planning

[INFO] GET_DIM_LIST(): I_APPL_ID="Planning", #dimensions=12

ACCOUNT,AUDIT_TRAIL,COMPANY_CODE,COST_CENTER,CURRENCY,FLOW,FUNCTIONAL_AREA,MEASURES,PROFIT_CENTER,TIME,TRADING_PARTNER,VERSION

#dim_memberset=9

ACCOUNT:6000001,1 in total.

CURRENCY:LC,USD,2 in total.

TIME:2013.01,2013.02,2013.03,2013.04,2013.05,...12 in total.

COMPANY_CODE:CO_AB01,1 in total.

FLOW:F_NONE,1 in total.

FUNCTIONAL_AREA:FA_NONE,1 in total.

TRADING_PARTNER:TP_NONE,1 in total.

VERSION:PLAN,1 in total.

AUDIT_TRAIL:BPC_INPUT,1 in total.

REC :[TIME].[2013.TOTAL] / 12 * 103%

REC :[TIME].[2014.TOTAL] / 12 * 103%

REC :[TIME].[2015.TOTAL] / 12 * 103%

REC :[TIME].[2016.TOTAL] / 12 * 103%

1

[TIME].[2013.TOTAL] / 12 * 103%

var $2$=4.0999999999999998E-01;var $1$=6.6800000000000004E-01;$1$ / 12 * 103%;

LOG END TIME:2013-04-06 22:47:12

File path: \ROOT\WEBFOLDERS\FIN_PLANNING\Planning\PRIVATEPUBLICATIONS\BASIS\tempfiles\20130406224712\INFLATION_3.LOG

Please suggest