Relationship Table

[Former Member]

Hi,

Can anyone tell about the Relationship table?

Hw can we add records to it and its benefits ?

Any Business case where we can implement this?

Regards

Nisha

[Former Member]

Hi,

Can anyone tell about the Relationship table?

Relationship table: These tables are used to define relation between Records. For Example we have three Records in Data Manager as:

Name ProductID

GeometryBox 1000

Pencil 1001

Rubber 1002

So here we want to maintain relationship b/w these records as:

GeometryBox as Parent Record and Pencil, Rubber as child to

GeometryBox where we maintain Pencil and Rubber too as Sibling Relationship.

Hw can we add records to it and its benefits ?

Firstly Go to MDM Console>Connect to Repository->Relationships Table --->Add Relationship of type Parent/Child fill Property Name=Parent Item Name Is= Parent, Name2=Child Item and Select Parent Table and Child Table as Main Table.

Now, After loading repository Go to MDM Data Manager---> A Relationship Qualified table will get display over Masks: In Relationships you will get two Relationships as:

Parent Item<Child Item>

Child Item<Parent Item>

Now for your Record Geometry Box click on Child Item<Parent Item> in Relationships table a new pop up window will open here for Children of Anchor Parent you can either select the Record Pencil first and then Pick and Drag to Children of Anchor Parent similarly for Rubber. OR you can also add relationships as from Main Menu Relationships then Add to group.

Any Business case where we can implement this?

Yes, in SRM-MDM Catalog you can define such kind of relationships which on selecting a record say PC further show the child records say Keyboard define as child Relationship for this record which you done in MDM Data Manager.

So further you can define relationships as Substitute Items which will Display Substitute items on the behalf of absent Item if you have defined relationship between records purely depends what kind of relationship you define in MDM console..

Hope it will Help you,

Rewards if Useful......

Mandeep Saini

[Former Member]

Hi,

The above steps can be done manuaaly in data manager.

Is it possible to establish relation through import manager?

How is that done?

Regards

Nisha

[Former Member]

Hi Nisha,

Yes it is possible to import relationships using Import Manager. You wil get the Name or your relationship(appears in the bottom) created in the drop down list of Destination tables.

If you want to try importing, export the relationship from the Data Manager into Excel modify one or two records and then Import that file using Import Manager.

Regards,

Jitesh Talreja

[Former Member]

Hi,

Is it possible to establish relation through import manager?

How is that done?

Relationships are of two types:

Parent/Child and Sibling which you can define using Console.

For Type Parent/Child Relationship you can import and export relationships using MDM Data Manager and can Import using MDM Import Manager.

For Type Sibling Relationship you can import and export using MDM Data Manager but can not import using MDM Import Manager.

you can try this after defining relationships b/w records in Data Manager then you export file in txt format and then delete these relationships in MDM Data Manger , then Relationship of type Parent/Child can be imported either using Import manager or using Data Manager. you can get the same relationships which you have maintained earlier but for type Sibling you need to import through Data Manager only.

Note: Display Fields play Significant Role in Maintaining Relationships as you export relationships it only contain Display Fields.

Hope it will Help you,

Rewards If Useful......

Mandeep Saini

[Former Member]

Hi,

this Drag and Drop option works if the no of records is less then I can search the related records

If I more records hw can I find related Items?

Can I use Matching mode in this case?

If Yes How is it done?

Regards

Nisha