Skip to Content
0

Multiple Hierarchies mapping in BPC from BW in transformation.

Jun 02, 2017 at 11:09 AM

62

avatar image

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

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

1 Answer

Vadim Kalinin Jun 02, 2017 at 03:05 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded