Skip to Content
author's profile photo Former Member
Former Member

Hierarchy questions

I have 2 questions related to hierarchy :

1. How do I assign a record say individual product record to an hirarchy e.g.

All Product ->Electrical Products->Fan->4 blade fan , 230 V AC

->Motors-> 3 phase induction motor , 415 V AC

->Mechanical Products->Compressor-> 1000 cc air compressor

2. Also how can i assign attribute to specific node of an hierarchy say Fan in this case .

Guess above can be achieved using taxonomy but how to do it in the hierarchy

Can some one provide the steps , thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2007 at 07:38 AM

    Hi Amit

    For your 2nd Question:- We cant assign attributes to a node if your table type is hierarchy. Assigning attributes to a particular node is only possible if your table type is taxonomy.

    I am not able to under stand your 1st question. Can you elaborate some more on that.

    Dilmit Chadha

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2007 at 09:33 AM

    Hi amit,

    you can record,

    in the hierarchy mode, in the records pane, right click - in the context menu you can find add option, click on that it will create new node in hierarchy pane.

    hope this may help you



    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 29, 2007 at 11:39 AM

    Hi Amit,

    If i understand you properly than you have created hierarachy and now you want to assign records to the hierarchy. If yes than if the hierarchy is made according to the field name than For Ex: Comm Group->ElectricalProducts ->Fan.

    For this select the main table, than select the commodity group field in the Search Parameters select electrical products, once you select electrical products you will get many records corresponding to the import you did. select all the records which are fan than in the records details pane in the Hierarchy tab select the hierarchy node you want to assign to the records or a single record.

    Its very simple check if it works

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Prasad ,

      What you suggested works but I was not looking for this . What I need is say if I got product project for example : 20 W electric bulb . Now I want to assign this product object to the hierarchy/taxonomy say All Products->Electric Product->Bulb . After adding this product to the hierarchy/taxonomy when I go to Hierarchy/Taxonomy view can i see this product (20 W electric bulb ) as

      All Products->Electric Product->Bulb->20 W electric bulb

      All Products->Electric Product->Bulb->40 W electric bulb ( if there are 2 products)

      I do not want to see All Products->Electric Product->Bulb in the hierarachy/taxonomy field that I may have for product objects say 20 W electric bulb , 40 W electric bulb.

      I have seen this kind of product being managed in similar way as described and looking at SAP MDM as to how can I achieve this .



  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 02:55 PM

    Hi Amit,

    Replying to ur first query:

    This u can do in the hierarchy mode of the data manager.

    Note:Although you can view, add, edit and delete the records of a hierarchy table in <u>Record mode</u>, you should usually edit a hierarchy table in <u>Hierarchy mode</u> so that you can view and edit the hierarchical relationships in addition to the other fields of each record.

    MDM supports inner node assignments indirectly , while preserving the rule that a hierarchy lookup field be assigned only to a leaf node in the hierarchy – using an internal leaf node .

    You can then make inner node assignments to the parent by assigning records to the internal leaf – which acts as a proxy for the parent for assignment purposes – just as you would assign records to any other leaf node .

    When you use the Create Internal Leaf command to create an internal

    leaf for a parent node, MDM creates a duplicate of the parent node as

    its first child


    To create an internal leaf node for a hierarchy tree item:

    1. In the hierarchy tree, select the parent node for which you want to

    create an internal leaf.

    2. Right-click on the node and choose Create Internal Leaf from the

    context menu, or choose Tree > Create Internal Leaf from the main


    3. MDM adds an internal leaf node named “[parent]” as the first child of

    the selected node.

    NOTE &#9658;&#9658; The name of the internal leaf node is the name of the

    parent node in square brackets ([]).

    NOTE &#9658;&#9658; You cannot edit the node name nor any of the fields of the

    internal leaf, which are auto-populated with the values of the parent

    when the internal leaf record is first created. This means that if the

    name of the parent changes, the internal leaf will continue to display

    the old parent name in square brackets.

    NOTE &#9658;&#9658; A normal leaf node cannot be converted into an internal

    leaf node nor can an internal leaf node be converted into a normal leaf

    node. Instead, you must create a second node, reassign records from

    the first node to the second node, and then delete the first node.

    Create Internal Leaf Constraints

    Operation Constraints


    Internal Leaf

    &#56256;&#56451; Must be in Hierarchy or Taxonomy mode

    &#56256;&#56451; Tree must have focus

    &#56256;&#56451; Exactly one node must be selected

    &#56256;&#56451; Root node cannot have internal leaf node child

    &#56256;&#56451; Node cannot be an alias

    &#56256;&#56451; Node cannot have an alias

    &#56256;&#56451; Node cannot have a matching set

    &#56256;&#56451; Node already has internal leaf

    &#56256;&#56451; Node is an internal leaf

    Please reward me with points if u find this information useful.

    Thanks & Regards


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.