Data Loading from one model to another model in BPC.

[karan_kothari2]

Hi Everyone,

I am having following business scenario:

Source Model Dimensions:

1. H_ACCOUNT

2. H_AUDITTRAIL

3. H_CATEGORY

4. H_COSTCENTER

5. H_CURRENCY

6. H_KF_TYPE (Needs to be skipped)

7. H_TIME

Target Model Dimensions:

1. H_ACCOUNT

2. H_AUDITTRAIL

3. H_CATEGORY

4. H_COSTCENTER

5. H_CURRENCY

6. H_KF_TYPE

7. H_TIME

8. H_COSTINOUT (Additional dimension- Constant value = COST_IN_OUT_NONE)

9. H_PARTNERCCTR (Additional dimension- Constant value = NONE_PTNR_CC)

10. H_SEQUENCE (Additional dimension- Constant value = SEQ_NONE)

Please suggest me the standard script logic code that will help me in transfer the data from above source model to target model.

[former_member186338 · Accepted solution]

Easy:

*DESTINATION_APP TargetModelName

*SKIP_DIM=H_KF_TYPE

*ADD_DIM H_COSTINOUT=COST_IN_OUT_NONE, H_PARTNERCCTR=NONE_PTNR_CC, H_SEQUENCE=SEQ_NONE

*WHEN H_ACCOUNT

*IS *

*REC(EXPRESSION=%VALUE%)

*ENDWHEN

P.S. It's also necessary to scope the skipped dimension before destination_app:

*XDIM_MEMBERSET H_KF_TYPE=<ALL>

[karan_kothari2 · Accepted solution]

Hi Vadim,

Thanks for your prompt reply.!

Further, I want to know that why we are using the following:

*WHEN H_ACCOUNT

*IS *

*REC(EXPRESSION=%VALUE%)

Note: I want to transfer All the data of source model to target model.

[former_member186338 · Accepted solution]

*WHEN H_ACCOUNT

*IS *

*REC(EXPRESSION=%VALUE%)

*ENDWHEN

Means:

For any member of H_ACCOUNT copy data to destination.

Instead of H_ACCOUNT any other dimension can be used.