locked
Some Basic Questions About Hierarchy RRS feed

  • Question

  • 1. I am trying to create a tree using explicit hierarchy. There are 3 levels, lvl1 and lvl2 are consolidated members and lvl3 are leaf members. My attribute for lvl1 and lvl2 are supposed to be different. Is there any way to do that? The method that I'm using can only allow me to create the same attributes accross all lvls of consolidated members.

    2. Is there a way to export the entitiy in hierarchy form (not table form)?

    3. When viewing entity in the table form, is there a way to easily separate different levels of the consolidated members? Currently, my lvl 1 and lvl 2 are all mixed together in random order.

    4. Is there a way to move around different attribute columns in entity tables? It seemed like it can only be shown in the order user created them.

    5. A GENERAL QUESTION: Is there a way to adjust the height of the entity table when viewing them? It's difficult to view them since I have to keep scrolling down.


    Friday, July 22, 2011 6:21 PM

Answers

  • 1. Since it sounds like your hierarchy is a structured 3 level hierarchy, have you considered creating a derived hierarchy?    You would create 3 entities and use domain-based attributes to define the hierarchy path between these entities.  You could then define specific attributes for each entity which would address your requirement above.  Once you have the entities and attributes defined, you would create the Derived Hierarchy structure in System Adminstration.

    2. You can export hierarchy data by creating subscription views selecting either a Parent/Child or Level-Based structure in Integration Management/ Export.  These subscription views are created as standard sql views in the MDS database.

    3. By creating a derived hierarchy as described above, you are easily able to separate the "consolidated" members since they are maintained in separate entities.

    4. To control the order of attribute colums you can create attribute groups that will allow you to control the column order and group them into tabs for easier access/display in the Explorer grid and for security permission assignment as well.

    5.  The only way to change the number of rows displayed in the grid is by adjusting the resolution of your monitor.

    At the risk of giving you a sales pitch, Profisee has a desktop application called Master Data Maestro that provides the functionality to address exactly the kind of issues you described.  For example, all Maestro screens including hierarchy views are a click away from auto generated Reporting Services reports (i.e. this would give you a hierarchy structure output rather than table or view form). 

    Also with Maestro users have full control over the columns displayed, column order as well as the ability to have multiple entity and hierarchy views open concurrently. Maestro saves these screens with filters and settings as private workspaces, or for distribution to other users—essentially creating mini-master data apps for quick and easy access to frequently used data sets.

    Maestro also leverages the entire real estate of the screen to utilize the maximum number of visible rows both in the entity grid as well as nodes in hierarchy structures.  This link provides more information on Maestro: http://www.profisee.com/Software/tabid/168/Default.aspx

    Pam

     www.profisee.com


    • Proposed as answer by Pam Matthews Friday, July 22, 2011 7:27 PM
    • Marked as answer by SyukiS Friday, July 22, 2011 8:28 PM
    Friday, July 22, 2011 7:27 PM

All replies

  • Hello,

    1. An entity's consolidated members all are defined with the same attributes and those same attributes are used for all levels.  On the flip side, derived hierarchies, by their nature, would allow you to have different attributes for each level.

    2. Within MDS you can create an "Explicit parent child" subscription view that will give you this information.  To do this, from the home screen, go to Integration Management then click the Export menu.  Then click the Add ("+") button.    Enter a name, select the model and entity and for the format select "Explicit parent child".  Then click the create button.

    3. Unfortunately not.  The hierarchy view is the only way to do that.

    4. You can create an attribute group and it allows you to rearrange the order of the attributes.

    5. Unfortunately not.

     

    HTH,

    Brian Barnett

    Profisee, www.profisee.com

     

    Friday, July 22, 2011 7:15 PM
  • 1. Since it sounds like your hierarchy is a structured 3 level hierarchy, have you considered creating a derived hierarchy?    You would create 3 entities and use domain-based attributes to define the hierarchy path between these entities.  You could then define specific attributes for each entity which would address your requirement above.  Once you have the entities and attributes defined, you would create the Derived Hierarchy structure in System Adminstration.

    2. You can export hierarchy data by creating subscription views selecting either a Parent/Child or Level-Based structure in Integration Management/ Export.  These subscription views are created as standard sql views in the MDS database.

    3. By creating a derived hierarchy as described above, you are easily able to separate the "consolidated" members since they are maintained in separate entities.

    4. To control the order of attribute colums you can create attribute groups that will allow you to control the column order and group them into tabs for easier access/display in the Explorer grid and for security permission assignment as well.

    5.  The only way to change the number of rows displayed in the grid is by adjusting the resolution of your monitor.

    At the risk of giving you a sales pitch, Profisee has a desktop application called Master Data Maestro that provides the functionality to address exactly the kind of issues you described.  For example, all Maestro screens including hierarchy views are a click away from auto generated Reporting Services reports (i.e. this would give you a hierarchy structure output rather than table or view form). 

    Also with Maestro users have full control over the columns displayed, column order as well as the ability to have multiple entity and hierarchy views open concurrently. Maestro saves these screens with filters and settings as private workspaces, or for distribution to other users—essentially creating mini-master data apps for quick and easy access to frequently used data sets.

    Maestro also leverages the entire real estate of the screen to utilize the maximum number of visible rows both in the entity grid as well as nodes in hierarchy structures.  This link provides more information on Maestro: http://www.profisee.com/Software/tabid/168/Default.aspx

    Pam

     www.profisee.com


    • Proposed as answer by Pam Matthews Friday, July 22, 2011 7:27 PM
    • Marked as answer by SyukiS Friday, July 22, 2011 8:28 PM
    Friday, July 22, 2011 7:27 PM