on 09-30-2011 11:06 AM
HI,
We are embarking on a new proj, and unable to figure out how to ensure that one customer record has only one company code of its kind. Eg: customer XYZ can have company code US01 assigned to it only once.
Need this validation during both manual entry in Data Manager and also in Import Manager.
Need this issue resovled urgently, any help would be immensely appreciated.
Thanks,
Veena
Hi Veena,
Please set the company code field property as Unique using MDM Console which should ensure that one customer record has only one company code of its kind. Just try and revert with your findings.
If still need some more inputs, please elaborate lil bit more on your data modelling. Kindly revert with result.
Regards,
Mandeep Saini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ravi,
Yes I racked my brains to do a count on the Tuple, like you mentioned it is not possible. We are able to ensure that no duplicate tuple fields are created through Import Manager but manual entry needs the human eye to ensure the same Quality.
Regards,
Veena
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Veena,
There can be a validation which can be called in a WF.
This WF can be triggered on Import/Record add.
You basically need a validation which says no of rows in Tuple/Qualified table for Comp Code data should be = 1.
I guess you can try using Count function,let me know your findings.
Thanks,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Veena,
What is the current scenario,do you have multiple company codes or not?
Thanks,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.