Setting attributes mandatory/optional based on matrix result

[#1]

Hi all,

we have another requirement, straight from the space ...

Our customer want to have the possibility, to mark an attribute ( in by setting an additional flag on attribute level) in a LDM model as mandatory/conditional/optional.

Simply saying, we need to find a way, how we can calculate this flag based on a matrix.

He wants to create a matrix per attribute where he will define the combination of f.e. 2-3 dimensions an the result of the matrix/flag, f.e.:

For attribute Entity1.Attribute2

Dim B

Dim A X Y Z

1 M C O

2 C M C

3 O O M

So, if the configuration for Entity1.Attribute2 is DimA=1 and DimB=X, the flag is set to M (mandatory), if the combination is DimA=2 and DimB=Z, the flag is set to C (conditional).

There is no predefined numbr of possible dimensions and combinations. The logic can't be hard-coded, as the customer want's to have the possibility, to change the matrix at any time and recalculate the flags.

Has anyone ever tried to implement such an requirement in PD? If yes, how to start ...?

BR & thanks in advance!

Rafal

[GeorgeMcGeachie]

I can't quite follow your example, as it's not a real world example, but here goes anyway. 🙂

Could you use Business Rules to represent your 'matrix' connections, and then have a script that populates an extended attribute with different values depending on the Business Rules it is or isn't attached to? You say that you can't hard-code the logic in the script, so, could the result depend on extended attributes defined on the Business Rules? e.g. set value to 'M' if the attribute is attached to more than 3 Business Rules with value 'M'?