cancel
Showing results for 
Search instead for 
Did you mean: 

Combination for Assignment and Validation

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member182007
Active Contributor
0 Kudos

Thanks.

Edited by: Deepak Gupta on Oct 8, 2011 11:55 AM

Former Member
0 Kudos

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

former_member188878
Active Contributor
0 Kudos

Hi Deepak,

Please try Clculated field where you can dynamically populate the values enter by the user.

Regards,

Shankar

Former Member
0 Kudos

Hello Deep,

You can call validation into assignment directly, provided the validation is marked as callable.

Regards,

Shaailesh.

former_member182007
Active Contributor
0 Kudos

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

former_member182007
Active Contributor
0 Kudos

I am closing this thread ..assuming no further ideas on same.

Former Member
0 Kudos

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

former_member182007
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

former_member208981
Contributor
0 Kudos

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