Skip to Content
0
Apr 20, 2017 at 10:36 PM

Error while extracting and loading material hierarchy

133 Views

Hello

We have materials already loaded into material dimension in BPC. Some of these materials need to be assigned to a certain hierarchy. Hence I first downloaded these materials to a flat file and then try loading those materials with a new hierarchy. However it is failing with error:

Member xxx of dimension MATERIAL has an invalid hierarchy parent 'PARENTH1'

Flat file has data in below format

ID, Description, PARENTH1

I am uploading the same file with below Transformation file which maps PARENTH1 to a hierarchy called: H1

*MAPPINGHIER_NAME=HIER_NAMEORDER=ORDERPARENT=*IF(PARENT=*STR() THEN *STR(ALL_MATERIALS);PARENT)*CONVERSIONHIER_NAME=MAT_HIER_CHEMCAT.xlsNODENAME=REPLACE_SPECIAL_CHARACTERS_MATERIAL.XLSPARENT=REPLACE_SPECIAL_CHARACTERS_PARENT_MATERIAL.XLSCan anyone let me know what I am doing wrong?
Thanks!