MDM Validation on the whole table data - Please help
I am a new to MDM validations. So I want to know approach for validations like below. Say I have a Employee Table with fields
RecordID | Emp. Number | Name | Unit | Date Join | Date Resign
Validation requirements are
1. Say in case employee resigns and joins again there is going to be new entry added. In this case 'Date Join' should be greater than 'Date Resign' of previous record of his.
2. Employee should be assigned to only one 'Unit'
3. Employee number can not be duplicate. etc
Is this possible with validation within Data Manager? Your help/links/pointers are very much appreciated.
Edited by: Sagar Lipare on Apr 14, 2010 1:51 AM
Shiv Prashant Dixit replied
As I said, i doubt if your first two requirements can not be fulfilled using standard MDM data manager validations.
In case you are using portal, for creating a new record you can fetch and compare new record data with other records in MDM for same employee and can throw error as per your validations.
Please check [MDM JAVA API guide |http://help.sap.com/saphelp_nwmdm71/helpdata/en/72/d36e1ed3ce43028adc851b8fed5668/MDM_Java_Net_API_Guide.pdf]from page no 30 to 33 for explanation and code sample for creating a new record and retrieving existing records from MDM using Java API.
Hope this helps. Kindly revert if you have any query..