Skip to Content

Multiple Hierarchies mapping in BPC from BW in transformation.

Hi Experts,

With respect to multiple hierarchy scenario,

Following is mapping section of my transformation file:

*MAPPING
ID = ID
PARENTH1 = *IF( ID=*STR(NO_PC) THEN *STR(TOTAL_PC); ID=*STR(QRN_FUNC) THEN *STR(TOTAL_PC); ID=*STR(UNASSIGNED_PC) THEN *STR(TOTAL_PC); 
PARENTH1=*STR() THEN *IF(PARENTH2 = *STR() THEN *IF(PARENTH3 = *STR() THEN *IF(PARENTH4 = *STR() THEN *STR(UNASSIGNED_PC))));PARENTH1)<br>

In addition to above, I am having the requirement that to also update PARENTH2 = "UNASSIGNED.2017" wherever there are blank member in PARENTH2.

Provide your suggestions.

Thanks,

Karan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 02, 2017 at 03:05 PM

    Sorry, but not clear... please explain the process in details: what is the source? What is the required result? Provide some sample...

    Add comment
    10|10000 characters needed characters exceeded