Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Copy Data within Model - Using Logic Script

Hi,

I have the following requirement which I have done via a standard copy data package. I want to setup a script to compare.

User should be able to Select Source Category, Seclect Traget Category, Select Time Frame

1. Data first needs to be cleared based on target Cat and Time
2. Then Data needs to be copied from source to Target

I have wrritten the following script. I have a few questions on it

1. I am going to trigger this via a data package so will be prompting time, source and target categories. I am planning to use the SELECTINPUT() function. Is that ok?

2. The scipt contains variables but I am not sure if i should use $$ or %% signs around the variables? Whats the difference?

3. Any improvements in the code below or problems can you see?

 

*XDIM_MEMBERSET TIME=$TIME_VAR$
*XDIM_MEMBERSET CATEGORY=$TARGET_CAT$

*WHEN TIME
*IS *
*REC(EXPRESSION=0)
*ENDWHEN

*XDIM_MEMBERSET CATEGORY=$SOURCE_CAT$

*WHEN TIME
*IS *
*REC(EXPRESSION=%VALUE%,TIME=%TIME_VAR%,CATEGORY=%TARGET_CAT%)
*ENDWHEN

Thanks.

Former Member
replied

Hi Leo,

Answers:

1. Yes: For CATEGORY use COPYMOVEINPUT, for TIME - SELECTINPUT

2. Use MEMBERSELECTION to pass values to $$ variables.

3. Code:

*XDIM_MEMBERSET TIME=$TIME_VAR$
*XDIM_MEMBERSET CATEGORY=$TARGET_CAT$

*WHEN TIME
*IS *
*REC(EXPRESSION=0)
*ENDWHEN

*XDIM_MEMBERSET CATEGORY=$SOURCE_CAT$

*WHEN TIME
*IS *
*REC(EXPRESSION=%VALUE%,TIME=%TIME_VAR%,CATEGORY=$TARGET_CAT$)
*ENDWHEN

Vadim

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question