on 2023 Mar 01 6:20 AM
Hello All,
I want to copy data from one model to another model, below is the mapping for GL account from source to target.
GL account Source in Mgmt model Target model (Headcount): GL Account Target model(HC): Accdetail
HEADCOUNT Headcount Closng
HEADC_ADDITION Headcount Joiner
HEADC_TERMINATION Headcount Leaver
.......
I write the below script logic
*XDIM _MEMBERSET TIME=%TIME_SET%
*XDIM _MEMBERSET CATEGORY=%CATOGERY_SET%
*XDIM _MEMBERSET RPTCURRENCY= USD
*XDIM _MEMBERSET COMPANYCODE=%COMPANYCODE_SET%
*XDIM _MEMBERSET PROFITCENTRE=%PROFITCENTRE_SET%
*DESTINATION_APP = HEADCOUNT
//*ADD_DIM ACCDETAIL=CLOSING
*RENAME_DIM DATASRC=AUDITTRAIL
*SKIP_DIM=TRADINGPARTNER
*WHEN GLACCOUNT
*IS HEADCOUNT
*REC(FACTOR=1,GLACCOUNT=GLACCOUNT.HC_TARGET_ACCT,ACCDETAIL=CLOSING)
*IS HEADC_ADDITION
*REC(FACTOR=1,GLACCOUNT=GLACCOUNT.HC_TARGET_ACCT,ACCDETAIL=JOINER)
......
*ENDWHEN
However when i execute this script I am getting this error "unknown dimension name in keyword "ACCDETAIL"
So my question is how do I post the value into target dimension (Accdetail)?
Regards
Srikant
Request clarification before answering.
Hi Srikant,
It seems you have some misunderstanding with *DESTINATION_APP.
When executing the provided script, it first processes WHEN-ENDWHEN statement on the source model and generates records, just like without the DESTINATION_APP. Then processed the generated records with the mapping defined in DESTINATION_APP statement, and posted it to target model. So here, obviously the ACCDETAIL is not available.
As far as I can think of, there are 2 options.
Option 1). define another property in GLACCOUNT dimension to store the value of mapped ACCDETAIL, then *ADD_DIM ACCDETAIL = GLACCOUNT.<property>.
Option 2). split the above into 2 WHEN-ENDWHEN with DESTINATION_APP statement in each. it should be like below. If the account member you mentioned is a parent node, you can generate these statement with *FOR-NEXT.
*DESTINATION_APP = HEADCOUNT
*ADD_DIM ACCDETAIL=CLOSING
*RENAME_DIM DATASRC=AUDITTRAIL
*SKIP_DIM=TRADINGPARTNER
*WHEN GLACCOUNT
*IS HEADCOUNT
*REC(FACTOR=1,GLACCOUNT=GLACCOUNT.HC_TARGET_ACCT)
*ENDWHEN
*DESTINATION_APP = HEADCOUNT
*ADD_DIM ACCDETAIL=JOINER
*RENAME_DIM DATASRC=AUDITTRAIL
*SKIP_DIM=TRADINGPARTNER
*WHEN GLACCOUNT
*IS HEADC_ADDITION
*REC(FACTOR=1,GLACCOUNT=GLACCOUNT.HC_TARGET_ACCT)
*ENDWHEN
Hope the above information helps.
Regards
Annie
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
srikanthgod1
Do you have a ACCDETAIL dimension in Target model?
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I think you should be using "FLOW" rather than ACCDETAIL.
It is the old name for the dimension goign back to when the product was first developed, similar to CATEGORY and Version.
Cheers,
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.