*DESTINATION_APP with RENAME does not work

[Former Member]

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

[Former Member · Accepted solution]

Hi Dries,

One thing I noticed was that you have 2 COMMIT statements. This statement is specific to XDIM_MEMBERSET. This means that after the first commit statement, the script doesnt have any restriction for the second set of commit statement.

So, I would request you to tweak the code

*WHEN TIJD
*IS %TIJD_SET%
   *WHEN BUDGETPOSITIE.ACCTYPE 
   *IS "INC","LEQ"
      *REC(FACTOR=-1)
   *IS "EXP","AST"
      *REC(FACTOR=1)
   *ENDWHEN
*ENDWHEN
*COMMIT

Hope this helps.

[Former Member · Accepted solution]

Hi,

In the meantime we solved the issue and indeed as you were saying the additional COMMIT statement resulted in the error.

grtz

Dries

[Former Member]

Hi Dries,

apart from the problem you mentioned, I guess that in the statement

*WHEN BUDGETPOSITIE.ACCTYPE

*IS "INC","LIQ"

is a small typo in the end ("LIQ"). I guess it should be "LEQ", as this would be the standard. This could lead to wrong results.

But that's maybe not relevant for the core problem

Only a short remark from my side...

Regards.

Wolfgang

[Former Member]

indeed not relevant, since we do not use this type of accounts but thanks for noticing