Cannot Import Deep Hierarchy into MDM?

[former_member343107]

Hi All,

According to the MDM online document of importing source data into

hierarchy table, it seems that the maximum number of levels of the

hierarchy is fixed. The example used by the document is like the

following:

Field1___Field2___Field3

A

A________B

A________B________C

That means, the maxium number of levels would only be 3. If we use the

following table in the data source to represent a deep hierarchy, it seems

that MDM cannot import it correctly:

Name___Parent

A

B______A

C______B

D______C

E______D

......

Can you confirm whether this is the fact? If not, how can we import a

deep heirarchy into MDM?

Thanks + Best Regards

Jerome

null

[Former Member · Accepted solution]

A pair of source data fields can be used to import multilevel hierarchy (any levels) in MDM.

Example:

<b>Parent Field</b> <b>Child Field</b>

A

A B

B C

C D

D E

In the above example, A is the root. It does not have any parent.

A is the parent of B.

B is the parent of C.

C is the parent of D. and so on.

Here we will use "Parent Child value pairs without node name" while using the "Create Hierarchy Field command"

[former_member343107 · Accepted solution]

Thanks a lot for your information, guys! The problem is solved by Adhappan's approach.

Best Regards

Jerome

[Former Member]

Hi Jerome,

You can Import hierarchy with more than three levels. I tried Importing four levels once and was able to do it.

You can refer to Import Manager Reference guide for SP04: PART 7 Splitting Fields and PART 8 Classification Import and perform them simultaneously.

I think you will be able to import hierarchy.

<b> Import Manager reference guide:</b>

https://websmp204.sap-ag.de/~sapidb/011000358700006291632006E

Thanks and Regards,

<b>Sagar Sonje

Mark Helpful Answers</b>

[Former Member]

Jerome,

I'm not an expert in this, but I have been able to create more than 3 levels of hierarchy using a code structure (for example):

<u>CODE DESC</u>

1000000000 FOOD

1010000000 DRINKS

1010200000 ALCOHOLIC

1010201000 BOTTLED

1010201010 HEINEKEN

1010201020 SHIRAZ

1010202000 CANNED

1010202010 CARLSBERG

1010202020 KRONENB

1010202030 TIGER

1010300000 NON-ALCOHOLIC

I was able to create a Hierarchy Field within Import Manager which derives the parent-child relationship from the above code structure.

Or import file with structure:

HIERARCHY01

FOOD 1000000000

FOOD\DRINKS ....

FOOD\DRINKS\ALCOHOLIC ....

FOOD\DRINKS\NON-ALCOHOLIC

FOOD\DRINKS\ALCOHOLIC\BOTTLED

FOOD\DRINKS\ALCOHOLIC\CANNED

FOOD\DRINKS\ALCOHOLIC\BOTTLED\HEINEKEN

FOOD\DRINKS\ALCOHOLIC\CANNED\KRONENB

FOOD\DRINKS\ALCOHOLIC\CANNED\CARLSBERG

FOOD\DRINKS\ALCOHOLIC\CANNED\TIGER

FOOD\DRINKS\ALCOHOLIC\BOTTLED\SHIRAZ

and use Split into Hierarchy

Just my 2 cents!

Cheers,

Foh