copy package with duplicated copymoveinput

[Former Member]

Dear Experts, we have an issue with BPC copy package after upgrading from 7.5 to 10 NW. The idea of the package is to force the user to make a selection for one specific dimension. After that selection, he can make a more detailed selection. Therefore, we used the standard copy package and duplicated the copymoveinput statement. This then prompts the user twice. In the 10 version, this doesn't work any more. Any ideas? The reason is probably that the variable gets an entire text string, which after concatenating is wrong. There is no package error, but no data is being sent PROMPT(MESSAGE,"Deze functie kopieert een budget van een bronversie naar een andere doelversie binnen dezelfde applicatie") PROMPT(COPYMOVEINPUT,%VERSIEBRON%,%VERSIEDOEL%,"Selecteer de bron en doelversie","%CATEGORY_DIM%") PROMPT(COPYMOVEINPUT,%SELECTION%,%SELECTIONTO%,"Selecteer bedrijfsnummer, profitcenter en tijd","BEDRIJFSNUMMER,%ENTITY_DIM%,%TIME_DIM%,ORIGINE,DOELST1,%ACCOUNT_DIM%,BUDGETPLAATS,SUBSIDIE") 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,%VERSIEBRON%%SELECTION%) TASK(/CPMB/CM_CONVERT,TOSELECTION,%VERSIEDOEL%%SELECTIONTO%) TASK(/CPMB/CM_CONVERT,CLEARDATA,0) TASK(/CPMB/CLEAR_SOURCE_CUBE,CHECKLCK,1) TASK(/CPMB/CLEAR_SOURCE_CUBE,SELECTION,%VERSIEDOEL%%SELECTIONTO%) TASK(/CPMB/APPEND_LOAD,INPUTNO,%TEMPNO1%) TASK(/CPMB/APPEND_LOAD,ACT_FILE_NO,%ACTNO%) TASK(/CPMB/APPEND_LOAD,RUNLOGIC,0) TASK(/CPMB/APPEND_LOAD,CHECKLCK,1) TASK(/CPMB/APPEND_LOAD,CLEARDATA,0) TARGETMODE = No RUNLOGIC = No CHECKLCK = No VERSIEBRON = /BUDGETOPMAAKTOOL/MAAND_1/PRIVATEPUBLICATIONS/EX01455/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:VERSIE|BUD_WIJZIGING1 VERSIEDOEL = /BUDGETOPMAAKTOOL/MAAND_1/PRIVATEPUBLICATIONS/EX01455/TempFiles/TO.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:VERSIE|BUD_WIJZIGING2 SELECTION = /BUDGETOPMAAKTOOL/MAAND_1/PRIVATEPUBLICATIONS/EX01455/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:BEDRIJFSNUMMER||DIMENSION:BUDGETPLAATS||DIMENSION:BUDGETPOSITIE||DIMENSION:DOELST1||DIMENSION:ORIGINE||DIMENSION:PROFITCENTER|PC_502|DIMENSION:SUBSIDIE||DIMENSION:TIJD| SELECTIONTO = /BUDGETOPMAAKTOOL/MAAND_1/PRIVATEPUBLICATIONS/EX01455/TempFiles/TO.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:BEDRIJFSNUMMER||DIMENSION:BUDGETPLAATS||DIMENSION:BUDGETPOSITIE||DIMENSION:DOELST1||DIMENSION:ORIGINE||DIMENSION:PROFITCENTER|PC_504|DIMENSION:SUBSIDIE||DIMENSION:TIJD| [Message] -------------------------------------------------------------- Task name CONVERT FOR COPYMOVE: Reject count:                                                0 Record count:                                                0 Skip count:                                                0 Accept count:                                                0 Task name CLEAR SOURCE DATA: Submit count: 0 Reject count: 0 Task name APPEND LOAD: Submit count: 0 Reject count: 0 model: MAAND_1. Package status: WARNING

[former_member186338 · Accepted solution]

Hi Christophe,

The issue is here:

PROMPT(COPYMOVEINPUT,%VERSIEBRON%,%VERSIEDOEL%,"Selecteer de bron en doelversie","%CATEGORY_DIM%")

PROMPT(COPYMOVEINPUT,%SELECTION%,%SELECTIONTO%,"Selecteer bedrijfsnummer, profitcenter en tijd","BEDRIJFSNUMMER,%ENTITY_DIM%,%TIME_DIM%,ORIGINE,DOELST1,%ACCOUNT_DIM%,BUDGETPLAATS,SUBSIDIE")

...

TASK(/CPMB/CM_CONVERT,SELECTION,%VERSIEBRON%%SELECTION%)

You are trying to combine variables coming from 2 COPYMOVEINPUT! It will not work in both 7.5 and 10.

Variables filled by COPYMOVEINPUT, SELECTINPUT, etc... have the following format:

/BUDGETOPMAAKTOOL/MAAND_1/PRIVATEPUBLICATIONS/EX01455/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:VERSIE|BUD_WIJZIGING1

Where in red you can see prefix followed by DIMENSION:DIMENSIONNAME|MEMBER1|MEMBER2...

As a result you can't combine it here:%VERSIEBRON%%SELECTION%

Instead, you can have 2 COMBOBOX with manual list of VERSIE members at the beginning:

PROMPT(COMBOBOX,%VERSIEBRON%,"Selecteer de bron:",1,,{VER1,VER2,VER3,VER4})

PROMPT(COMBOBOX,%VERSIEDOEL%,"Selecteer de doelversie:",1,,{VER1,VER2,VER3,VER4})

And then:

TASK(/CPMB/CM_CONVERT,SELECTION,%SELECTION%|DIMENSION:VERSIE|%VERSIEBRON%)

Vadim

[Former Member · Accepted solution]

Hi Vadim,

thanks for your reply. I must state however that it did work in the 7.5 version for 3 years now.

I am indeed aware of this kind of solution, but I wanted it to be dynamic as it was before. I guess I'll have no way of this and go for the combobox option. In reality, I guess it's a quite stable dimension.

kind regards,

Christophe

[former_member186338 · Accepted solution]

Ups, just tested!

Looks like it was a bug in BPC 7.5 string parser

It was able to parse string like:

/BUDGETOPMAAKTOOL/MAAND_1/PRIVATEPUBLICATIONS/EX01455/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:VERSIE|BUD_WIJZIGING1/BUDGETOPMAAKTOOL/MAAND_1/PRIVATEPUBLICATIONS/EX01455/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:OTHER|OTHERMEMBER...

It was corrected for BPC10

Now only COMBOBOX!

Vadim