Relationship constrains

[Former Member]

Hello

we are on MDM 5.5 Sp06 patch3 Hotfix13.

We have maintained field called u201CBusiness Unitu201D that can have 7 values maintained as lookup.

We have a business process where user should only be allowed to relate records with 2 business units out of 7 possible values.

We have created one Partner Viewer Role where user has view only access in MDM. So that user can view all records.

We have created another role as Testrole there we have maintained constrains for u201CBusiness Unitu201D for 2 business units which user wants to relate. By doing that we want to allow records to be related only if they belong to either of business Units maintained in constrains.

These two roles are assigned to one user u201CTestuseru201D. We could see all records in MDM but Relationship constrain is not working.

Any guidance would be appreciated.

Ken

[Former Member]

Hi Ken,

As per your requirement you need to work with MDM Authorizations and Restrictions.

In MDM these requirements can be fullfilled using one of the below methods in MDM:

- MDM Masks

- MDM Named Searches

- MDM Constraints

- MDM Roles (Functions and Tables settings)

You can refer the below links for futher in detail help:

Named Search:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d068a5ec-4839-2b10-2ebd-8e680165... (named search)

Masks:

/people/sap.user72/blog/2005/08/29/brief-introduction-to-masks-in-mdm-55 (masks)

Constraints:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0ed10b9-768d-2b10-0581-abe366c6...

MDM security:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/703b92a3-9716-2a10-2985-b3e0b0c4...

Hope It Helped

Thanks & Regards

Simona Pinto

[Former Member]

Hi Ken,

Try to achieve this requirement with Named Search functionality of MDM. Set the search criteria so that only those two required Business Units would get selected then save the search as Named Search. Assign this Named Search to the role. Now whenever the user login to Data Manager he can only view the records containing the desired Business Units and hence user cannot relate the records present in another Business Units apart from these two.

Also whenever new records gets created and satisfy the Named Search criteria will be available for relationship.

Kindly update us...

Regards,

Jitesh Talreja

[Former Member]

Jitesh;

User wants to see all the records in repository but should be able to relate only those records with either Business Units.

[Former Member]

hi Ken

Use validations to restrict the lookup values which should not be assigned to records.

regards

Ravi