​pDimension allows the Turbo Integrator Process to be generic and used with any dimension. (If rebuilding the hierarchy, pDimension can be omitted and the name of the dimension can be hard coded into the TI Process.)

pParent  is the Top Level Parent from which you want to remove all children. Even if this Turbo Integrator Process will be Dimension specific, skipping this parameter is not recommended since even a Top Level Parent can change. (You can populate the Default Value with the Top Level Parent.)

pYN is an optional parameter to determine if any parent elements below pParent should be deleted.

Parent/child relationships may be used in more than one hierarchy.  In the example shown below, 1st Half and 2nd Half exist in both the TOTAL YEAR and YEAR hierarchies.

If a parent/child relationship exists in the hierarchy with which you are working as well as another hierarchy, the relationship must be removed intact from the hierarchy with which you are working.

• Determine the Level of pParent.
• Set pLevelIndex to one less than the pParent pLevel.  You are looking for the children of pParent so the level of any children would be less than pParent.  So, start at the top and work your way down.  If you were to start at the bottom, you could potentially break other hierarchies as it would be difficult to know at what level the parent/child relationship starts.
• Cycle through the elements in pDimension.

• Does the level of the element equal the current index level?
• Is pParent an ancestor of the element?
• Does the element have more than one parent?

Multiple Parents:

If the [pDimEle] element has more than one parent, the assumption is it belongs to more than one hierarchy.

• Set the pLevelIndex2 to one higher than the current pLevelIndex.  You need to determine to which parent of the hierarchy the element with multiple parents belongs.
• Cycle through the elements in pDimension.
• Does the level of the element equal the current pLevelIndex2?
• Is pParent an ancestor of the element?
  
• Delete the element with multiple parents from the current parent.  (DeleteDirect is used so that, if needed, the dimension can be rebuilt as part of the TI Process.)

Because you only need the level above the current pLevelIndex, there is no need to increment pLevelIndex2.

• pLevelIndex is decreased by one each time.  You need to work your way DOWN the levels of pParent.

Removing  Elements from TM1 Alternate Hierarchies:

Once all parent/child relationships that exist in other hierarchies are removed, the remaining relationships/elements can be removed from your hierarchy.

• Reset pLevel to the Level of pParent.
• Set the LevelIndex to 1.  You are working from the bottom UP.
• Cycle through the elements in pDimension.
• Does the Level of the element equal the current LevelIndex?
• Is pParent an ancestor of the element or does the element equal pParent?

• Determine the number of Children of the parent element.
• Determine the Child based on the pChildCount.
• Delete the Child from the parent element.  (DeleteDirect is used so that the child is removed immediately.)
• pChildCount is decreased by one each time as the number of children decreases each time one is removed.

• If the element type is "C" and the number of children is zero and pYN parameter is set to "Y", delete the parent element.