cancel
Showing results for 
Search instead for 
Did you mean: 

Get %year%.DEC

monica_marquez2
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

cecilia_petersson2
Active Participant
0 Kudos

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
Active Contributor
0 Kudos

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