Creating new hierarchy based on existing r/3 hierarchy & loading
We have an existing hierarchy in BW which we bring in from SAP R/3.
I want to use the majority of this hierarchy but I need it in a different sequence. If I copy this existing hierarchy and then re-structure it to how I need it, I assume that whenever any changes are made to the existing hierarchy, that these changes won't filter through to the hierarchy I need to create.
If my assumption is correct, does anyone have any suggestions as to what, if anything, I can do in order to make any changes in the existing hierarchy come through to the new one without any manual intervention.