Skip to Content
0
Former Member
Jan 20, 2014 at 11:26 AM

BPC Logic Script: enigmatic validation error while using *DESTINATION_APP

106 Views

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!!!

Attachments

NL dimensions.jpg (205.1 kB)
TK dimensions.jpg (231.0 kB)