Unbalanced Parent Child Hierarchy with changing level of deepness

[csand0]

Hello all. I have a an unbalanced hierarchy that is currently in the parent/child structure.  I have figured out how to flatten the hierarchy, It currently goes to a specific level of deepness, let's say 5 levels currently.  However I was informed that it could change periodically.  For example, it could be 7 levels deep next week, and then 4 after that, and so on.  The way I have flattened it out is somewhat static and doesn't take this into account.  Has anyone had this issue before, and if so how have you addressed it?  Please let me know if you need more details.

[bdbits]

Surely there is some maximum depth it will reach? Typically that is what I have seen/used - you just create it deep enough to accommodate the maximum.