on 10-21-2010 9:52 AM
Hello Experts
I am looking for some insights on particular assignment-
Condition: In my MDM box if I have a field calles S field (source field) and a look up field L field - here both represent for the same master data object .
suppose from some front end if user putting "valid" data for S field then respective "valid" data should be assign to L .
Here can I make a combo for validation as in the "Valid" Data for S. I think for that separate Validation needed. and directly I cannot call this validation into Assigment.
Can somebody put more light..as in how the formula should be.
TIA
Deep
Thanks.
Edited by: Deepak Gupta on Oct 8, 2011 11:55 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Just one point.
You cannot assign a value look field other than lookup values ie.e in assignment you cannot assign a user defined value neither any other field as you described in first post.But you cando other way around by checking whether lookup value contain valid value then assign source value to look up field value.
Thanks,
Sudhanshu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Deepak,
Please try Clculated field where you can dynamically populate the values enter by the user.
Regards,
Shankar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Deep,
You can call validation into assignment directly, provided the validation is marked as callable.
Regards,
Shaailesh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Here Is this possible if my value L doesn't find valid Data by any user then this will get lock into a workflow ??
Here I checked with same flow as suggested but no luck further, may be this expression for assignment is not correct.
as in I have also set validation as callable , but then how it will reflect into its relevant assignment expression ..??
any input is appriciable
Thx
Deep
Hi Deepak,
as in I have also set validation as callable , but then how it will reflect into its relevant assignment expression ..??
Please refer this blog: /people/mandeep.singhsaini/blog/2010/09/13/mdm-expressions-use-of-callable-function-in-search-capabilities-part-1
As per your requirement, i feel that you can achieve it easily using MDM Workflow on record creation, update, import.
Start>Branch(contains Validation)>if valid data (pass) Assign-->Stop1
-
>If Not-valid(fail) Stop2.
Kindly mark thread as answered if this solves your query.
Regards,
Madneep Saini
Hello Mandeep,
Thanks for input. Really helpful
Here for this assiignment I was looking in such a way
I have some Legacy Status field in main table and its mapping as well . here same for Mapping in MDM
so I want in a way
if my source system ID is "X" then it should assign MDM id "Y" . here both are legal set of values and I dont want them to hardcode. as in future it may change
looking forward .
Thx
Deep
Hi Deepak,
if my source system ID is "X" then it should assign MDM id "Y" . here both are legal set of values and I dont want them to hardcode. See, i don't see any harm in writing values as hardcode if this solves your concern, Like i suggested in above workflow branch step (Condition). You can write following expression in Validation
Status ID = "X"
So when this validation pass, it will go to Assign step where assign step have expression as Y and then move to step stop1. If status ID is different than "X" it will not pass (means fail) thus should move to step stop2 without Assign step.
as in future it may change. Ideally it should not change even if it changes then before reaching this file in MDM, you can also handle this thing in PI/XI (Msg Mapping) So as such it will not impact your MDM system.
Also, if you don't want to handle this thing in PI, changing Expression in MDM does not take more than 1 minute to rectify it.
Regards,
Mandeep Saini
Hi Deepak,
This is possible as below:
In the assisgnment, please select the assignment field as L
In the expression for assignment write the validation which will check if field S = valid value 1 or S = valid value 2 THEN valid . only when is true the assignemt will work.. else no value will be assigned.
you can call the validation too.
Thanks,
Priti
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.