11-30-2022 03:08 PM - last edited on 05-03-2023 09:12 AM by JackLacava
Hi
I am looking for a way to restructure a part of our UD1 hierarchy but there over 1,600 lines to move so I don't really want to copy and move them individually to their new locations.
Is there a way to upload the new structure and overwrite the old one, or a faster way of copy/move the base levels.
Thanks
Simon
11-30-2022 08:57 PM
There are a few approaches:
Whatever you do, remember that data is stored against base members; so don't remove those, don't turn them into parents, and don't leave them orphan. Also keep an eye on constraints and channels, if you use them in combination with UDs.
12-01-2022 10:12 AM
@JackLacavasummarized your option well. I have reorganized some large (~5,000 members) UD hierarchies recently and did it by modifying the XML manually (Notepad ++). Here are my steps that can be modified for your situation:
1) Use Excel to create the relationship lines to move base entities to temp parent and load.
<relationship parent="Temp_Parent" child="Base1" aggregationWeight="1.0" />
2) Export relationship metadata to be replaced. Add Action="delete" to each relationship and load back into OS. This should remove the old hierarchy, while keeping the base members in a temp location.
<relationship parent="Old_Parent" child="Base1" aggregationWeight="1.0" Action="delete"/>
3) Load new hierarchy
4) Remove relationships under the Temp_Parent member direction in the dimension hierarchy.
5) Delete "Temp_Parent" member