Hierachy

[Former Member]

Hi All,

I have a relationship like this.......

Field1 Field2 Field3

a -

---

b----

---

c

a--

---

b--

---

d

p--

---

x--

---

y

p--

---

x--

---

z

l--

---

m--

---

n

Means A is relate to b and

b is relate to c and d.......

How can I approach this situation?

Whether to use Hierachy or simply flat lookup or any other?( Here the values are from 3 diff fields)

Also if the user select say value 'b' in MDM, he should see all the records which have the value 'b'.

Regards,

Nikhil

[Former Member · Accepted solution]

Hi Nikhil,

for your case please go through "Relationships" in data manager document. it will help you.

regards

Rupesh

[Former Member]

Hi,

For your Destination side i mean in MDM Repository side ( Data Modeling) you can create a field in Main table and look up to a Hierarchy table which i mean best meets your requirement. So you should have or create a hierarchy table and from main table a field shud be lookup to your this Hierarchy table. If further you feel to link Attributes then you shud go for Taxonomy table. Maintaining Records in Hierarchy form is Possible either by creating Hierarchy or Taxonomy table.

Now comes to Source file:

( Here the values are from 3 diff fields). you can have three fields in your source file as you said

Field1 Field2 Field3

a -

---

b----

---

c

a--

---

b--

---

d

p--

---

x--

---

y

p--

---

x--

---

z

l--

---

m--

---

n

Here you can achieve this using Partioning Concept where you use Field1 as Partion by and add field2 to field1 and then add Field3 to Field2 means look like

Field1

Field2

Field3

then in your Source file you will get one more field Field1 map this with your target Destination Field when selecting Hierarchy Taqble as your current Destination table.

Please Refer this link for more Details,

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/c0e122d4-40ab-2a10-4a82-fe7db431...

Hope it will Help you,

Rewards if found Useful......

Thanks,

Mandeep Saini

[Former Member]

Hi Nikhil,

Means A is relate to b and

b is relate to c and d.......

You need to firstly understand whats the relationship between the three Fields.

- If the three values are related in hierarchy in the sense there is a level difference in between each then this kind of data can be stored in a Hierarachy table

eg:Circle->Subcircle->Unit

- If there is realtion such that based on A ,B or C is decided then youw ill ahve to go for Qualified tables options.

But as in your case i do not think this would be the best option as B is both the deciding and the decided Factor As A is deciding B and B is deciding C so B cannot be both Qualifier as well as Non qualifier so i feel this case would be ruled out here.

- Look up Doesnt seem a suitable option here as lookups are jsuta set of legal values which do not have any interdependencies between other fields.

- The last option is you can use them in a relationship table where the feilds are having some realtion between them however as far i know Even relationships are saved as Hierarchy so you will have to analyse your data well before selectinga any form of tabel.

You can have a look on the eblow links which will help you categorize your data well

MDM Tables:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e8d76c89-0a01-0010-b4b7-e1ae2ece...

For Realtionships Table:

For Hierarchy Tables:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/80fc0a2e-6561-2910-839e-8ff3e36d...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a0f3057f-a2f1-2a10-d091-ffb7fd35...

For Qualified tables:

Hope It Helped,

Thanks & Regards

Simona Pinto