Get %year%.DEC

[monica_marquez2]

Hi all!

I need to transfer from forecast dicember, AAAA.DEC (cube Forecast) to actual AAAA.INP (cube Planning), Regardless of the time choice. This is my script any idea why doesnt work?

Part 1: ( this code doesnt include *DESTINATION APP, because I need this part works ok)

*SELECT(%cta_find%,ID,AccountFC,"MAPEO='FIND'")

*XDIM_MEMBERSET AccountFC= %cta_find%
*XDIM_MEMBERSET Category=%CATEGORY_SET%
*XDIM_MEMBERSET EntityFC=
*XDIM_MEMBERSET Time=%YEAR%.JAN,%YEAR%.FEB,%YEAR%.MAR,%YEAR%.APR,%YEAR%.MAY,%YEAR%.JUN,%YEAR%.JUL,%YEAR%.AUG,%YEAR%.SEP,%YEAR%.OCT,%YEAR%.NOV,%YEAR%.DEC 
*XDIM_MEMBERSET VersionFC=%VERSION_SET%

*WHEN ACCOUNTFC
*IS %cta_find%           
*REC(factor=GET(Time=%YEAR%+".DEC"),Category= "PLAN",TIME=TIME.ANNUAL,VERSIONFC="V_BAS")
*ENDWHEN
*COMMIT

So for example:

If the user select "2014.JUN", my script must collect 2014.DEC and store to 2014.INP

Any suggestions?

Thanx in advance

[cecilia_petersson2]

Hi Monica,

Try the syntax GET(Time="%YEAR%.DEC"), i.e. with quotation marks around the whole time period and without the + sign.

/Cecilia

[former_member186498]

Hi Monica,

please explain better what is 2014.INP, it is the year\month passed through PROMPT?

Is this all your script?

Have you solved your previous thread http://scn.sap.com/thread/3593031? If so please close it otherwise please answer.

Thanks

     Roberto