Skip to Content
avatar image
Former Member

Defaulting a dimension member if not available in BW cube

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 14, 2017 at 05:48 PM

    Something like:

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

    Add comment
    10|10000 characters needed characters exceeded