Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
automap new source members to suspence/ignore

.Iain.
Member Posts: 15 Blue Ribbon
Hi,
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?
Thanks,
Iain
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?
Thanks,
Iain
Tagged:
Answers
-
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.