Skip to Content
avatar image
Former Member

SAP BPC Transformation file Multiple field

Hi Experts,

I have below requirement to be accomplished through transformation file.

Transformation file

In country dimension if value is there in ZSENTITY_ZTFICTRY then that particular value should come or if value is not there in ZSENTITY_ZTFICTRY then the value in ZSCNTRY_ZTCNTRY should come. However if value is not there even in ZSCNTRY_ZTCNTRY then hard code the member to C_NONE

Let me know what error I am doing in the transformation file.

1kfe1.png (5.4 kB)
vurxe.png (4.7 kB)
g3drj.png (4.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 17, 2017 at 11:39 AM

    Final:

    DUMMY_COUNTRY = *IF(ZSENTITY__ZTFICTRY + ZSCNTRY__ZTCNTRY = *STR() then *STR(C_NONE); ZSENTITY__ZTFICTRY = *STR() then ZSCNTRY__ZTCNTRY; ZSENTITY__ZTFICTRY)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2017 at 11:09 AM

    DUMMY_COUNTRY = *IF(ZSENTITY__ZTFICTRY = *STR(XXXX) then ZSENTITY__ZTFICTRY; ZSENTITY__ZTFICTRY = *STR() then ZSCNTRY__ZTCNTRY; ZSCNTRY__ZTCNTRY = *STR() then *STR(C_NONE))

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 17, 2017 at 10:55 AM

    Please post transformation file TEXT, not picture!

    Add comment
    10|10000 characters needed characters exceeded