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

[Former Member]

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

[former_member186338 · Accepted solution]

Correct prompt will be:

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

without %KEYDATE%

Vadim

[former_member186338]

P.S. And for the rest - please show the report with data in the source scope!

[Former Member]

Hi Vadim,

Thanks for your reply. I tried by removing the %KEYDATE%. Now the package is getting succeeded.

I thought only if we give the %KEYDATE% in that prompt we will get the KeyDate selection in the Run package screen.

But without that also, it works.

The above was the report I was using. Wanted to move the value in PLAN_VER1 and append it to PLAN_VER2.

Its working now.

Thanks,

Deepika G S