cancel
Showing results for 
Search instead for 
Did you mean: 

BPC destination app script issue

former_member844987
Discoverer
0 Kudos
598

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Private_Member_141848
Product and Topic Expert
Product and Topic Expert
0 Kudos

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

N1kh1l
Active Contributor
0 Kudos

srikanthgod1

Do you have a ACCDETAIL dimension in Target model?

Nikhil

former_member844987
Discoverer
0 Kudos

Hi Nikhil,

Yes, we have ACCDETAIL dimension in target.

Regards,

Srikant

msapey
Explorer
0 Kudos

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