cancel
Showing results for 
Search instead for 
Did you mean: 

Tuple Member Field Validation - Not Null

0 Kudos


Hi,

We have a requirement to build a validation on a tuple member field. The tuple is a multi valued tuple.

Example below:

A multi valued tuple "ABC" which has a look up Tuple member field "XYZ". This Tuple member field has 20 to 25 values stored as look

up values. Since the tuple "ABC" is a multi valued tuple; We can maintain multiple line items for the same.

The requirement is the Tuple member field "XYZ" should be not null for all the line items in the tuple "ABC". We are able to achieve this

for only one line item maintained in the tuple but for multi values it is not giving the correct result.

Please help regarding this.

Regards,

UG

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi UG,

Please confirm my understanding -

There is a multivalued Tuple ABC with Lookup Flat field XYZ.

You want that XYZ should not be NULL for all sub records in Tuple ABC.

To put it simply - no subrecord in tuple can have XYZ as NULL.

This can be achieved by a simple validation.e.g.Having a If then expression which would be based on Primary key of Tuple and if Primary Key of Tuple is present then XYZ must also be present.

Please confirm if Lookup XYZ is single valued or Multivalued.

Thanks,

Ravi

gabor_molnar
Advisor
Advisor
0 Kudos

Hi,

This is possible as of MDM 7.1 SP10 Patch00. Note 1803476 - MDM Expression editor does not support multi-value
tuples

Regards,

Gábor