Skip to Content
0
Former Member
Jul 01, 2015 at 01:03 PM

Customising Standard Package - For Model where time dependent hierarchy is enabled

32 Views

Dear all,

I want to Customise the standard copy packages to hardcode the dimension members in a model where the Time dependent hierarchy is enabled.

Reference used: http://scn.sap.com/docs/DOC-34892m.

I have used the below script inside the package. Making changes as suggested by the link mentioned above.

PROMPT(COPYMOVEINPUT,%SELECTION%,%TOSELECTION%,"Select the members to COPY and where to","%KEYDATE%,%TIME_DIM%,%ENTITY_DIM%",0)

'PROMPT(SELECTINPUT,%SELECTION%,,,"%TIME_DIM%,%ENTITY_DIM%")

INFO(%SUFFIX1%,DIMENSION:T_AUDITTRAIL|Input|)

INFO(%SUFFIX2%,DIMENSION:T_FLOW|CLO|)

INFO(%SUFFIX3%,DIMENSION:DEMO_TEST_ACC|A|)

INFO(%SUFFIX4%,DIMENSION:T_RPTCURR|INR|)

INFO(%SUFFIX5%,DIMENSION:T_CATEGORY|PLAN_VER1|)

INFO(%SUFFIX6%,DIMENSION:T_CATEGORY|PLAN_VER2|)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

INFO(%SELECTION_KEYDATE%,)

TASK(/CPMB/CM_CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/CM_CONVERT,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/CM_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/CM_CONVERT,SAPP,%APP%)

TASK(/CPMB/CM_CONVERT,SELECTION,%SELECTION%%SUFFIX1%%SUFFIX2%%SUFFIX3%%SUFFIX4%%SUFFIX5%)

TASK(/CPMB/CM_CONVERT,TOSELECTION,%TOSELECTION%%SUFFIX1%%SUFFIX2%%SUFFIX3%%SUFFIX4%%SUFFIX6%)

TASK(/CPMB/CM_CONVERT,KEYDATE,%SELECTION_KEYDATE%)

TASK(/CPMB/CM_CONVERT,CLEARDATA,%CLEARDATA%)

TASK(/CPMB/CLEAR_SOURCE_CUBE,CHECKLCK,%CHECKLCK%)

TASK(/CPMB/CLEAR_SOURCE_CUBE,SELECTION,%TOSELECTION%%SUFFIX1%%SUFFIX2%%SUFFIX3%%SUFFIX4%%SUFFIX5%)

TASK(/CPMB/CLEAR_SOURCE_CUBE,KEYDATE,%SELECTION_KEYDATE%)

'TASK(/CPMB/CLEAR_SOURCE_CUBE,DUMPLOADMODE,3)

'TASK(/CPMB/APPEND_LOAD,PREPROCESSMODE,0)

'TASK(/CPMB/APPEND_LOAD,TARGETMODE,%TARGETMODE%)

TASK(/CPMB/APPEND_LOAD,INPUTNO,%TEMPNO1%)

TASK(/CPMB/APPEND_LOAD,ACT_FILE_NO,%ACTNO%)

'TASK(/CPMB/APPEND_LOAD,RUNLOGIC,%RUNLOGIC%)

'TASK(/CPMB/APPEND_LOAD,CHECKLCK,%CHECKLCK%)

TASK(/CPMB/APPEND_LOAD,KEYDATE,%SELECTION_KEYDATE%)

TASK(/CPMB/APPEND_LOAD,RUNLOGIC,1)

TASK(/CPMB/APPEND_LOAD,CHECKLCK,1)

TASK(/CPMB/APPEND_LOAD,CLEARDATA,0)

If I give the KeyDate in the SELECTINPUT prompt, I'm not getting the Key Date in Run package screen.

From and To copy combination:

Getting a warning status as below,

Please help with modifying the script.

Regards,

Deepika G S

Attachments

Warning_Screen.png (27.5 kB)
Combinations.PNG (13.9 kB)