Forum Discussion

Rams_2022's avatar
Rams_2022
New Contributor II
2 months ago

create replication Hierarchy

Hi OS Experts:

I have an existing hierarchy called "ControlMgt Hierarchy," which has several rollups underneath it. I need to recreate a new hierarchy named "ControlMgt Hierarchy_ALTERNATE," where "_ALTERNATE" will be added to all the rollups. The base elements will remain the same between the two hierarchies.

I’m considering exporting the "ControlMgt Hierarchy" and updating it to include "_ALTERNATE" for all rollups in the XML file, and then importing it into the entity dimension. Is this possible? Will this create a new hierarchy, or will it overwrite the original hierarchy?

Could you please suggest the best approach to accomplish this?

Metadata
  • rhankey's avatar
    rhankey
    Contributor
    2 months ago

    Yes, exporting/editing/importing will work, and I use this method a fair bit.  Keep in mind that the Export will be the complete dimension of Members & Relationships.  To minimize mistooks, I usually only include the members and relationships I am adding (or updating, which you are not doing).  The import will overlay the adds/changes onto your existing hierarchy, leaving everything else alone.

  • JakeSteinberg's avatar
    JakeSteinberg
    New Contributor III
    2 months ago

    Hi Rams,

    In your case, using an XML is the easiest solution. Assuming all parent levels in the hierarchy are named with "_ALTERNATE" and the base members retain the same names, performing this XML manipulation will create a new hierarchy with "_ALTERNATE" parents and each base member will have two parents - one in your original hierarchy and one in the alternate hierarchy.

  • Rams_2022's avatar
    Rams_2022
    New Contributor II
    2 months ago

    JakeSteinberg rhankey Thanks for prompt response. Do I need to find and replace with new name for all the rollups of that hierarchy, or do I need to add the new hierarchy info along with existing hierachy in the xml? please suggest?

     

    • JakeSteinberg's avatar
      JakeSteinberg
      New Contributor III
      2 months ago

      Rams,

      You can just do a find and replace. Since the new hierarchy names are different, a new hierarchy with new names will be loaded while the old one will remain unchanged.