Hi all,
I have been trying to write up this .LGF file to transfer transaction data from model named "NL_EE_Planning_RES" to model named "EE_Planning_RES_TK"
Here are the dimensions in the models:
and
And this is the .lgf code in NL_EE_Planning_RES model that I am trying to use:
*DESTINATION_APP = EE_Planning_RES_TK
*SKIP_DIM = L_ENTITY, N_BUDGET_OBJECT, AUDIT_TRAIL, NL_ACCOUNT
*ADD_DIM FUNCTIONAL_AREA = FA_NONE
*ADD_DIM COFOG = NONE
*ADD_DIM TECH_DATA_CHECK = L_BASE_ENTITY
*ADD_DIM BUDGET_OBJECT = NONE
*ADD_DIM BUDGET_VERSION = CURENT
*ADD_DIM TRADING_PARTNER = I_NONE
*ADD_DIM BUD_ACC_DT_A = NONE
*WHEN AUDIT_TRAIL
*IS IN
*WHEN L_ENTITY.INSTITUTION_ATR
*IS <>""
*WHEN NL_ACCOUNT.PARENT_ACC
*IS <>""
*REC( BUDGET_ACCOUNT = NL_ACCOUNT.PARENT_ACC, INSTITUTION = L_ENTITY.INSTITUTION_ATR)
*ENDWHEN
*ENDWHEN
*ENDWHEN
*COMMIT
...
When I try to validate (click "Validate" button in BPC interface) this code, I get the following error message:
Error line: 22 ; Error Description: Unknown Dimension Name in Keyword: "BUDGET_ACCOUNT:
This was the strange part. The enigmatic part is that when I set BUDGET_ACCOUNT to constant "NONE", I get no problems, while the INSTITUTION dimension keeps on receiving the Dynamic values L_ENTITY.INSTITUTION_ATR
That is: I use this code instead:
*DESTINATION_APP = EE_Planning_RES_TK
*SKIP_DIM = L_ENTITY, N_BUDGET_OBJECT, AUDIT_TRAIL, NL_ACCOUNT
*ADD_DIM FUNCTIONAL_AREA = FA_NONE
*ADD_DIM COFOG = NONE
*ADD_DIM TECH_DATA_CHECK = L_BASE_ENTITY
*ADD_DIM BUDGET_OBJECT = NONE
*ADD_DIM BUDGET_VERSION = CURENT
*ADD_DIM TRADING_PARTNER = I_NONE
*ADD_DIM BUD_ACC_DT_A = NONE
*ADD_DIM BUDGET_ACCOUNT = NONE
*WHEN AUDIT_TRAIL
*IS IN
*WHEN L_ENTITY.INSTITUTION_ATR
*IS <>""
*WHEN NL_ACCOUNT.PARENT_ACC
*IS <>""
*REC( INSTITUTION = L_ENTITY.INSTITUTION_ATR)
*ENDWHEN
*ENDWHEN
*ENDWHEN
*COMMIT
So, this is my problem 😕. Any help at all would be appreciated so much!!!