Defaulting a dimension member if not available in BW cube

[former_member238777]

Hi,

I want to default to 'ZZZ' if the member is blank in the cube.

If currency is available in the cube,DMP should fetch the value,if the field is blank in BW cube,it should update with 'ZZZ' value.

Current transformation:

CURRENCY=ZBPCEPCUR

We are on BPC10.1;SAPK-75005INSAPBW

Thanks,

Manohar

[former_member186338 · Accepted solution]

Something like:

CURRENCY=*IF(ZBPCEPCUR=*STR() THEN *STR(ZZZ); ZBPCEPCUR)

[former_member238777 · Accepted solution]

Thank you very much Vadim.

Got expected results with this.

Best Regards,

Manohar