2 Replies Latest reply: Aug 19, 2013 7:41 PM by sheilaO RSS

    DRM Hierarchy Design

    Singh_Shashank
      Hi All,

      I have a design issue in DRM.
      I have 4-5 hierarchies having some codes, now as per business, all codes of these hierarchies are related to each other with many-to-many relationship.
      Is there a way to configure this design using a single hierarchy.

      I thought of doing it by having a main hierarchy and rest of them as attributes of this hierarchy, but it is not possible as maintenance will be a issue then.
      Next is to use Assnodes/groups but this could have worked if we have 2 hierarchies , maintaining this in 5 hierarchies will again be a maintenance issue.

      Any thoughts on this desgin?

      Thanks
        • 1. Re: DRM Hierarchy Design
          N Truelove
          A specific example would be helpful. Keep in mind that some many-to-many relationships will not conform to hierarchical referential integrity rules. In DRM those cases will have to be handled with attribution.
          • 2. Re: DRM Hierarchy Design
            sheilaO

            Many to many relationships can be facilitated with a 'global' node and it's local members, which may be the same node, but have a different prefix based on it's downstream requirements.  Each of the 'sub' nodes can be related to the same node as it's parent (associated node).

             

            If there are no real shared ancestors, then alternate hierarchies are built.  Since the same node (named the same) is 'linked' in each hierarchy, it will carry the same global property relationships as the first instance of the node.