SAP BPC Transformation file Multiple field

[former_member291708]

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.

[former_member186338 · Accepted solution]

Final:

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

[former_member291708]

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

[former_member186338]

Now explain the required logic once again:

"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" - absolutely not clear!

List all possible variants!

[former_member291708]

I am writing this transformation file for Country Dimension (i.e. DUMMY_COUNTRY)

Info Provider is of BW

Scenario 1

If value is present in ZSENTITY_ZTFICTRY then bring that value. So in this case value would be fetched to member IE

Scenario 2

If value is not present in ZSENTITY_ZTFICTRY then look for ZSCNTRY_ZTCNTRY and bring the value against that member. hence value would be fetched to member IN.

Scenario 3

If value is not present in ZSENTITY_ZTFICTRY and ZSCNTRY_ZTCNTRY then bring the value against C_NONE. hence value would be fetched to member C_NONE

[former_member186338]

Do you understand my question?

Provide something like:

If ZSENTITY_ZTFICTRY is empty 
Then 
  If ZSCNTRY_ZTCNTRY is empty
  Then DUMMY_COUNTRY=C_NONE
  Else DUMMY_COUNTRY=ZSCNTRY_ZTCNTRY
Else DUMMY_COUNTRY=ZSENTITY_ZTFICTRY

Is it correct?

[former_member291708]

yes correct

[former_member186338]

Please post transformation file TEXT, not picture!