Skip to Content
0

Defaulting a dimension member if not available in BW cube

Dec 14, 2017 at 04:24 PM

40

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Dec 14, 2017 at 05:48 PM
0

Something like:

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you very much Vadim.

Got expected results with this.

Best Regards,

Manohar

0