Data360 Govern

 View Only

Relationship Field Type – Field Settings – Is Required, Part of Key & Allow Multiple Items are Blocked

  • 1.  Relationship Field Type – Field Settings – Is Required, Part of Key & Allow Multiple Items are Blocked

    Posted 01-19-2023 03:08

    The configuration of a Relationship field blocks these field settings:

    • Is Required

    • Part of Key

    • Allow Multiple Items

    IDEA

    • Allow the field to be part of the key.

    • Allow the field to be required.

    • Allow to select multiple related artifacts, for that field, also when part of the key.

    WHY?

    Let me give you an example.

    • Assume you have a Data Domain Map established through a Model asset. Model : Data Domain Map

    • Assume you store the Business Glossary in a Business Asset. Business Asset : Business Glossary

    • You want to enable autonomy to manage the business glossary within each data domain. Accordingly, you might have two terms in distinct data domains with identical label, e.g. Name, but with different definitions.

      • The Marketing data domain defines Name as the concatenation of the First Name and Last Name.

      • The Finance data domain defines Name as the Last Name.

    • Accordingly, terms in the Business Glossary are unique by applying the Key on

      • the Relationship field Data Domain that relates an artifact in Model : Data Domain Map – The Data Domain is required! and

      • the Simple Text field Label.

    That is not possible today.

    • Potentially, you want to attach one term of the Business Glossary to many Data Domains, since it is an enterprise terminology. Now, you want to associate many Data Domains in the Relationship field Data Domain.

    This is not possible either.

    Call for Action
    If you have a similar need please vote for the idea.
    Relationship Field Type – Field Settings – Is | Precisely Ideas



    ------------------------------
    Ivan Anckaert
    Elia, Management Consultant at THE SMARTR CURVE
    Brussels
    ------------------------------