How Can I Automatically Identify and Delete Childless Hierarchy Items?

Options
red11
red11 Member, ALL USERS, Community Member Posts: 5 Occasional Contributor
in Anaplan Community

Hello,

I have a constantly shifting hierarchy in place which consists of 8 levels, level 1 (top) through level 8 (bottom).  Within this hierarchy it's necessary to delete members of L7 when they have no L8 members which roll up to them.  This scenario plays out regularly as L8 members are often realigned to roll up under different parents.

 

My Question:  Is there some way to automate the identification and deletion of L7 members which don't have children?  If I could run an action to clean the hierarchy it'd save me a meaningful amount of time pruning my hierarchy.

Tagged:

Categories