Hierarchy table extract

[former_member184753]

Hi,

Can anyone help me with the steps to pull out the hierarchy table extract from SAP MDM data manager / syndicator. Able to pull the extract from main table where hierarchy table is looked up, but I am looking for the complete data set from hierarchy table which I need to import in other environments.

Kindly note that data maintained in hierarchy table is multi nested.

Ex-

GNP Hierarchy Code [1] GNP Hierarchy Code [2] GNP Hierarchy Code [3] GNP Hierarchy Code [4] GNP Hierarchy Code [5] GNP Hierarchy Code [6] DE, Systemtechnik 01, Ericsson 01, BSS 01, Neubau-Pakete 100, BTS1800 010101100100, Konfiguration DE, Systemtechnik 01, Ericsson 01, BSS 01, Neubau-Pakete 100, BTS1800 010101100110, TMA DE, Systemtechnik 01, Ericsson 01, BSS 01, Neubau-Pakete 100, BTS1800 010101100120, Install./Dienstl. DE, Systemtechnik 01, Ericsson 01, BSS 01, Neubau-Pakete 100, BTS1800 010101100130, Stromversorgung

[gabor_molnar]

Hi Nilesh,

Please attach some screenshot of how your Hierarchy Field looks like.

Also about if you can Hierarchy Split option in Syndicator. And if it is disabled, then how you try to split the field.

Regards,

Gábor

[former_member211341]

Hi Manfred,

Table type is hierarchy. And the screenshots which you have provided it seems that you are pulling an extract from main table where hierarchy has been used as lookup.

But my ask is, how to take an extract direct from hierarchy table not from the main table where it is look up.

Even though repository is multilingual, but in my case we are not maintaining any description in multiple languages. So multi lingual is not an issue for my case.

Thanks,

Preetesh

[manfredKlein]

Ah, now I understand.

Excel Export is disabled if you are in Hierarchy Mode. You need to open an hierarchy in Record Mode in order to use the 'File->Export To->EXCEL...' feature. Syndicator does the same. You don't have the search hierarchy there neither. If you want to export specific nodes of your hierarchy, proceed as follows:

1. Change to Hierarchy Mode and choose your Hierarchy table.

2. Take an unused field and mark the desired nodes by setting the field to a common value(have obsolete Sorting Field which I mostly set to 69 ;-)).

3. Change to Record Mode and select your hierarchy. Use your common value to narrow the search to your desired nodes(going to free form search and enter '69' at field 'sorting').

4. Go to menu File->Export To->EXCEL...

5. Then you can use my screenshots from my previous post.

If you marked your nodes that way you can use the same mechanism/search in Syndicator.

Have fun,

Manfred

[former_member211341]

Hi Manfred,

Have the same query.

Trying to pull out the extract from hierarchy flat table not from the main table where it is referred so that can load the hierarchy structure in other environments.

1. Is your repository multilingual? - Yes

2. Is your lookup hierarchy multivalued(Screenshot from Console;main table field referencing lookup hierarchy)? - No

3. What are the field properties of your hierarchy display field(Screenshot from Console)? No other property has been set. There are 2 display fields name and code. but in this case it does not matter since my ask it to pull the extract from Hierarchy table itself not from the main table where it is lookup

4. Is your export format text or XML(Schema file of the XSL)? - text

5. Which fields do you want to export(list of fields with their types and origin(maintable/lookup hierarchy))? - There are 4 fields in my hierarchy table and I want all those 4 fields.

[manfredKlein]

Hi Preetesh Karwa,

sorry, your information leaves some questions. With some screenshots from console with the table/fields definition I could provide you a better response. You speak of a 'hierarchy flat table'. In NW MDM a table is either hierarchy or flat. Do you mean the table is defined flat in MDM but reflects an hierarchy? You mentioned 2 display fields. This would suggest that case. On the question for field properties you replied, that no other properties have been set. Does that mean, that all 4 fields are of type 'text', 'multilingual' and 'not unique'(default values)? A 'multilingual' and 'non-unique' code would be unusual.

Ok, these are details, that would be beneficial for exact instructions, but are not necessary for a generic approach.

NW MDM has no easy means to export an hierarchy. Neither Data Manager built in EXCEL/Text Export nor via Syndicator. If you want the full hierarchy with all fields in all languages you need to make use of an API. Did this many times with the Java API. But this is way too much to discuss this here.

With the UI Tools(Data Manager/Syndicator) you need to reconstruct the hierarchy the target system, anyway. This is facilitated if your hierarchy has one display field of type text non-multilingual and unique. Second a calculated text field which concatenates the hierarchy levels of the unique text field(see my other post in this question).

With what we have right now, I would suggest the following: use Data Manager Export->EXCEL.

That's the easier way.

In Syndicator you can define 4 target fields for your 4 repository fields under 'Destination Items'. Place your mouse cursor over the blank white field and add fields by right-click->'Add Destination Item' (4x). Entering names is necessary. The other properties are mostly not necessary. Afterwards change to 'Item Mapping'. In the left list you see the fields of your source table. In the right list you see your 4 destination items. Now highlight one item on the left and the corresponding destination item on the right and hit the 'Map' button in the middle.

Data Manager Export is faster, but Syndicator Export you can save and reload next time.

wish you success.

[manfredKlein]

Hi Nilesh Hatkar,

not sure what you want to achieve exactly. If you want the looked up hierarchy table itself, why not select it as root table directly?

Keep in mind that MDM Syndicator is not suited to export the hierarchy structure itself. If you want total freedom of what to export I suggest the Java API. If you want to use MDM Syndicator you can export the data records of the hierarchy as a flat file(txt). If you are skilled with XSL Schema files you can use XML as export format. In both cases it is good practice to have a single language unique text field as the display field of the hierarchy. To ease external recreation of the hierarchy I advise a calculated text field, that concatenates the unique names from root to current node level(root;level1node3;level2node6, for instance).

You mentioned split hierarchy. Please avoid that. If my memory serves me right, you have to select the depth of levels as a fixed number. That's not nice if your hierarchy has dynamic depth.

If my guess was wrong, please provide more details of your environment:

1. Is your repository multilingual?

2. Is your lookup hierarchy multivalued(Screenshot from Console;maintable field referencing lookup hierarchy)?

3. What are the field properties of your hierarchy display field(Screenshot from Console)?

4. Is your export format text or XML(Schema file of the XSL)?

5. Which fields do you want to export(list of fields with their types and origin(maintable/lookup hierarchy))?

That's a lot of factors that can influence what Syndicator can do and what not.

Hopefully any of this helps you.

Cheers,

Manfred Klein

[former_member184753]

There is no option to split the field.

[former_member184753]

Hi gabor,

As requested.

Thanks.