Hierachy load Error in SAP BPC

[Former Member]

Hi

I am loading Master data hierarchy for HR Org Unit ParentH1. I am using Import Master data Hierarchy from InfoObj. But while loading the data I am getting error as "Member 20002003 does not exist".

As my BW Org Unit data is having member id as 20002003" and I uploaded master data by using pre fix to org unit data as OU_20002003. Hence while loading the data for hierarchy the system is not able to determine OU_20002003 for updating PARENTH1. It is searching for Member id 20002003 which is not available in BPC org unit data.

I tried giving conversion for the transformation file while loading data, but it is not recognizing. Can anybody have suggestions on the load on what I should do on the conversion file?

See below my transformaton file:

first conversion file:

Second conversion for the node;

Error message:

Records rejected

Master data from the dimension:

Your help in this regard would be appreciated...

Thanks,

[former_member186338]

Not related tag:

SAP Business Planning and Consolidation, version for the Microsoft platform

please delete!

[former_member186338 · Accepted solution]

Another option - without separate conversion sheet (to skip empty parent) is to use in mapping the line like:

PARENT=*IF(PARENT=*STR() THEN PARENT; *STR(OU_)+PARENT)

Both ways will do the same.

[Former Member · Accepted solution]

Issue resolved

Thanks for your help.

[former_member186338 · Accepted solution]

Please accept the correct answer!

https://www.sap.com/community/about/rules-of-engagement.html

Rule 8

[former_member186338 · Accepted solution]

It's absolutely strange to accept as correct answer "Issue resolved Thanks for your help."

I will stop answering your questions (black list). Sorry!

[mynynachau · Accepted solution]

I have marked your answer as accepted, Vadim. I hope, Themba appreciates your help as much as we do. Thanks Vadim.

Best regards,

Mynyna (SAP Community moderator)

[Former Member]

Hi,

I profusely apologize for my conduct.

Issue has been resolved. Thank you very for your assistance

[former_member186338]

Easy:

In the conversion file for PARENT

add single line:

OU_ *skip

to skip empty parent

[Former Member]

Hi,

As per your suggestion, I only have one conversion file. Should I add another one?

Please advise,

Thanks,

Themba

[former_member186338]

Yes, use another sheet in the same file for PARENT conversion. With one line. It will skip processing of empty parent.

[former_member186338]

Why do you need conversion to append prefix???

Use mapping in transformation file:

NODENAME=*STR(OU_)+NODENAME

HIER_NAME=HIER_NAME

PARENT=*STR(OU_)+PARENT

ORDER=ORDER

P.S. use conversion only for HIER_NAME

[Former Member]

Hi,

I have changed my transformation file as suggested and I am using one conversion file but I am getting an error as

below:

but with different rejected records: