Skip to main content
R
Rams_2022
October 29, 2024

create replication Hierarchy

  • October 29, 2024
  • 3 replies
  • 0 views

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?

3 replies

R
rhankey
October 29, 2024

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.

J
JakeSteinberg
October 29, 2024

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.

R
Rams_2022Author
October 29, 2024

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?

 

J
JakeSteinberg
October 29, 2024

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.

Terms & ConditionsAccessibility statement