Skip to Content
0
Former Member
Sep 10, 2010 at 08:21 AM

*DESTINATION_APP with RENAME does not work

26 Views

Hi,

We are on BPC NW 75 and we use a *DESTINATION_APP statement to transfer data from appilcation MAAND_2 to MAAND_1. The only difference between the two application is a switch of one dmension for which we use the *RENAME_DIM statement. The problem we have is that the *RENAMI_DIM statement requires that ALL dimension members of the source dimension have to exist in the target dimension, from the moment data has been posted to it in the source dimension. Thing is we only want to transfer a small portion of the data (being DOELST2 = DOELST_NR), which is specified by means of *XDIM_MEMBERSET statements. Apperantly the *RENAME_DIM statement looks at all dimension members posted in the source dimension, and not just the one want to transfer. The member DOELST_NR exists in both dimensions ...

The error we get: "member xxx of dimension DOELST1 is not a valid member in". Thing is member xxx should not be considered at all ...

Here the script:

*XDIM_MEMBERSET BEDRIJFSNUMMER = %BEDRIJFSNUMMER_SET%

*XDIM_MEMBERSET BUDGETPLAATS = BPL_NR

*XDIM_MEMBERSET BUDGETPOSITIE = ENV_INV_IN,ENV_INV_OUT,ENV_EXPL_IN,ENV_EXPL_OUT,ENV_LIQ_IN,ENV_LIQ_OUT

*XDIM_MEMBERSET IC_BELEIDSDOMEIN = ICBD_NR

*XDIM_MEMBERSET IC_BUDGETPLAATS = ICBPL_NR

*XDIM_MEMBERSET IC_BUDGETPOS = ICPOS_NR

*XDIM_MEMBERSET IC_PROFITCENTER = ICPC_NR

*XDIM_MEMBERSET IC_SUBSIDIE = ICSUB_NR

*XDIM_MEMBERSET IC_TIJD = IC0000.TOTAL

*XDIM_MEMBERSET ORIGINE = BUD_RESULTAAT

*XDIM_MEMBERSET PROFITCENTER = %PROFITCENTER_SET%

*XDIM_MEMBERSET SUBSIDIE = SUB_NR

*XDIM_MEMBERSET TIJD = %TIJD_SET%

*XDIM_MEMBERSET VERSIE = ENV

*XDIM_MEMBERSET DOELST2 = DOELST_NR

*XDIM_MEMBERSET IC_DOELST2 = ICDOELST_NR

*DESTINATION_APP = MAAND_1

*RENAME_DIM DOELST2 = DOELST1

*RENAME_DIM IC_DOELST2 = IC_DOELST1

*WHEN TIJD

*IS %TIJD_SET%

*WHEN BUDGETPOSITIE.ACCTYPE

*IS "INC","LIQ"

*REC(FACTOR=-1)

*ENDWHEN

*ENDWHEN

*COMMIT

*WHEN TIJD

*IS %TIJD_SET%

*WHEN BUDGETPOSITIE.ACCTYPE

*IS "EXP","AST"

*REC(FACTOR=1)

*ENDWHEN

*ENDWHEN

*COMMIT

Edited by: Dries Paesmans on Sep 10, 2010 10:22 AM