on 10-05-2015 8:28 AM
Hi,
We are integrated the TCURR table from ECC to BPC to load the exchange rates. As as a part of the same, since we have no rates in ECC for group currency and as the same has to be maintained as 1 in BPC we are trying to write a default logic for bringing the USD rates as 1.00000 for the account type AVG. Dont know if we have any other work around.
But the below issue appreas while running the DMP.
Model Dimensions:
CATEGORY
TIME
R_ENTITY
R_ACCOUNT
INPUTCURRENCY
Logic is as below:
*XDIM_MEMBERSET CATEGORY= Actual
*XDIM_MEMBERSET TIME = %TIME_SET%
*XDIM_MEMBERSET R_ENTITY = Global
*XDIM_MEMBERSET INPUTCURRENCY = USD
*WHEN R_ACCOUNT=AVG
*REC(EXPRESSION =1.00000)
*ENDWHEN
The DMP runs successful with no records updated in the data base.
Kindly Suggest.
Regards,
Shilpa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Vadim,
I tried the below code as suggested. The DMP becomes succeefull, but no records are written back,
Script:
*XDIM_MEMBERSET CATEGORY= Actual
*XDIM_MEMBERSET R_ENTITY = Global
*XDIM_MEMBERSET INPUTCURRENCY = USD
*XDIM_MEMBERSET TIME = <ALL>
*WHEN_REF_DATA = MASTER_DATA
*WHEN R_ACCOUNT=AVG
*REC(EXPRESSION =1.00000)
*ENDWHEN
Kindly suggest.
Regards,
Shilpa
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
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.