Composite vs general organization hierarchy
I'd like to hear experiences from others of modelling complex organization hierarchies. Often the decision is to choose between composite hierarchy and general hierarchy in one list. Usually I prefer composite hierarchies but always it is not wise, right? Case that I'm thinking is an organization that has quite a many levels and the hierarchy is ragged and changes very often. For example, there is a cost center directly after the top level and once in a while organization changes so that members might jump from one level to another. This is why I'm leaning into using only one list instead of converting the organization in data hub so that each cost center has equal number of predecessors (composite hierarchy). What kind of experiences do you have of using one list only for organisation? You miss the option of inputting figures to higher levels and the option of "reselecting levels" in dashboards changes quite a lot but what else? What kinds of challenges have you had? All experiences appreciated!