cancel
Showing results for 
Search instead for 
Did you mean: 

Import Master Data ParentH1

brian_tyson2
Explorer
0 Kudos

All,

I am using a transformation file to upload master data via ImportMasterData package.

In the transformation file I am including the following Insruction for my Comany Code (COMP_CODE) dimension

*MAPPING

ID=*COL(1)

EVDESCRIPTION=*COL(2)

PARENTH1=*NEWCOL(WORLDWIDE)

My issue is with the parenth1 instruction, the member "WORLDWIDE" does not exist in my upload data, I have added "WORLDWIDE" manually through the admin console.

I have set VALIDATERECORDS=NO in the options section and the validation works, however when i run the actual job i get the error:

Dimension COMP_CODE's member 100 has a invalid hierarchy parent 'WORLDWIDE',

This seems to imply that the parent's (even if they only exist in BPC) have to exist in the upload file, and that the upload data is validating with only the members that are uploaded and not validating with existing members in the dimension.

I am hoping to find a solution without having to add parent members to the source data, thanks in advance for any assistance.

Accepted Solutions (0)

Answers (1)

Answers (1)

brian_tyson2
Explorer
0 Kudos

I think i figured it out,

set MAXREJECTRECORDS=999999 in Options section, looks like that worked.