Skip to Content

Error while extracting and loading material hierarchy

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 20, 2017 at 10:41 PM

    If you want an answer, please correct your post to a readable format!

    Also provide:

    Full transformation file

    All conversion files used

    Data sample.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 21, 2017 at 05:09 AM

    Where in the transformation file are you assigning the new hierarchy name ?

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 26, 2017 at 06:30 PM

    I fixed assignment of hierarchy by trail and error.

    However I have a relatively simple question: When you set the prompt based on dynamic filter in package link as shown below, can I keep the members dynamic based on dynamic filter.

    What is happening is, system is hard coding the members retrieved based on the filters at that time and doesn't change with time. i.e. say if there are 3 members at the time of setting up the prompt. Later when the members are changed to 5 or something else, the list doesn't get dynamically updated. Anyone faced same issue?

    Note: Vladmir, the message screen is not friendly enough to format the message correctly. I am doing the best given the limitations on answers.sap.com page.

    Add comment
    10|10000 characters needed characters exceeded