Issue in the script logic for writing a value

[Former Member]

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

[former_member186338 · Accepted solution]

Hi Shilpa,

Please read:

Vadim

[Former Member · Accepted solution]

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

[former_member186338 · Accepted solution]

In general this script with *WHEN_REF_DATA = MASTER_DATA has to work correctly. Please test it again in UJKT and provide screenshots:

And read also:

Vadim

[former_member186338 · Accepted solution]

Ups, definitely an error:

*WHEN R_ACCOUNT=AVG - incorrect!

Correct:

*WHEN R_ACCOUNT

*IS AVG

Vadim

Or:

*XDIM_MEMBERSET R_ACCOUNT=AVG

*WHEN R_ACCOUNT

*IS * // * - scoped - AVG

[Former Member · Accepted solution]

Thanks a lot Vadim.

It worked.