Forum Stats

  • 3,872,827 Users
  • 2,266,483 Discussions


automap new source members to suspence/ignore

.Iain. Member Posts: 15 Blue Ribbon
edited May 13, 2010 11:32AM in Financial Data Management

I am loading data to HFM, in my source load file the entity/acct members match that of the target HFM application but there can be instances where a new entity or acct may have been added to the source system before the HFM app is updated. I am using the 'Like' mapping where source = * and target = * to get a one to one match but where a new source entity/acct is encountered these appear as invalid members on the validation intersection report.

What I would like if possible is for the new members that do not have an HFM match to be loaded to a suspense or ignore account so that we can continue the dataload, then analyse the suspense account at a later time to add the new members and then reload data.

Any suggestions?



  • TonyScalese
    TonyScalese Member Posts: 1,108 Bronze Trophy
    You would need to write an event script to accomplish this.

    Another option is to have all explicit maps and then a like map that moves everything unmapped to ignore. I doubt this is something that you would want to maintain but it is an option.
This discussion has been closed.