EPM Customize Data Manager Package /CPMB/COPY

[ChristianSass]

Hi,

I would like to use a customized /CPMB/COPY Data Package within my BPC application.

All the information I've found so far explained that I've to place a variable after the "TASK(/CPMB/CM_CONVERT,SELECTION,%SELECTION%" since I can't change the %SELECTION% variable because it contains some other string for the correct selection. I've tried many different scenarios but the attached string is not taken into account within my selection. I've checked the the behavoir with the debugger and my string doesn't even appear .... has there been a major change to the concept of Data Packages?

Thankful for any hint!

CPMBPC 810 SP7

PROMPT(RADIOBUTTON,%TARGETMODE%,"Handling of records",0,{"Copy records with match key","Copy by replacing data in same data region of Entity, Category, Time and Audit ID"},{"0","2"})

PROMPT(RADIOBUTTON,%RUNLOGIC%,"Select whether to run default logic for stored values after copying",0,{"Yes","No"},{"1","0"})

PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",1,{"Yes, check for work status settings before importing","No, do not check work status settings"},{"1","0"})

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

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%|DIMENSION:VERSION|ACTUAL|)

TASK(/CPMB/CM_CONVERT,TOSELECTION,%TOSELECTION%|DIMENSION:VERSION|PLAN|)

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

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

TASK(/CPMB/CLEAR_SOURCE_CUBE,SELECTION,%TOSELECTION%|DIMENSION:VERSION|PLAN|)

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%)

[former_member186338 · Accepted solution]

Can you explain the exact requirements? What do you want to be selected by user and what - to be fixed?

Vadim

[former_member186338 · Accepted solution]

P.S. The issue is in bold:

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

Instead of %DIMS% you have to list the required dimensions you want the user to select. Not including VERSION!

Vadim

[ChristianSass · Accepted solution]

Hi Vadim,

I would like to offer selection screen for Time, Version, and Account.

The Data Management Package is preselected for Version (Actual --> Plan)

I've used a new "Standard" Model with Dimension "TIME,ACCOUNT,CATEGORY,ENTITY" to try my customized data management package...

##############################################################

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

INFO(%SOURCE%,DIMENSION:CATEGORY|Actual|)

INFO(%TARGET%,DIMENSION:CATEGORY|Plan|)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

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%%SOURCE%)

TASK(/CPMB/CM_CONVERT,TOSELECTION,%SELECTION%%TARGET%)

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

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

TASK(/CPMB/CLEAR_SOURCE_CUBE,SELECTION,%SELECTION%%TARGET%)

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

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

TASK(/CPMB/APPEND_LOAD,RUNLOGIC,1)

TASK(/CPMB/APPEND_LOAD,CHECKLCK,1)

TASK(/CPMB/APPEND_LOAD,CLEARDATA,0)

here is the result:

as you can see the static selection is not taken into account

[former_member186338 · Accepted solution]

"I would like to offer selection screen for Time, Version, and Account.

The Data Management Package is preselected for Version (Actual --> Plan)"

You can't have version preselected - it can be fixed or user selectable!

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

is correct for fixed Version!

INFO(%SOURCE%,DIMENSION:CATEGORY|Actual|)

INFO(%TARGET%,DIMENSION:CATEGORY|Plan|)

What is your real CATEGORY dimension name? If VERSION then

INFO(%SOURCE%,|DIMENSION:VERSION|Actual|)

INFO(%TARGET%,|DIMENSION:VERSION|Plan|)

And in the result screenshot you have the value of %SELECTION% variable without Version - it's correct!

Vadim

[ChristianSass · Accepted solution]

Hi Vadim,

"Preselected" was not the right word. As you already mentioned - I want to have CATEGORY in a fixed selection. The user can only copy from "Actual" to "Plan".

I used a very minimized Standard-Model with the delivered dimensions "ACCOUNT, CATEGORY, ENTITY, TIME" to test the data package.

The CATEGORY dimensions carries the members-IDs: "Plan" and "Actual"

I've tested the package on to different BPC Systems with the same behaviour. Even is the selection is wrong I should see the attached string during debugging, don't I?

[former_member186338 · Accepted solution]

Then (Look on |DIMENSION):

INFO(%SOURCE%,|DIMENSION:CATEGORY|Actual|)

INFO(%TARGET%,|DIMENSION:CATEGORY|Plan|)

"Even is the selection is wrong I should see the attached string during debugging, don't I?" - no, as I already told you in the log you see contents of %SELECTION% variable without CATEGORY suffix!

Test copy results!

Vadim

[ChristianSass · Accepted solution]

Now I get it ....

I thought that I need to see the suffix during debug but it works as you said!

Great!

Thank you!

[ChristianSass]

No one? Any hint?