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?