Managing Hierarchy with members moving between levels
What are the ways of Hierarchy Managemnet when, list member are moving between levels? For e.g. the file we recieve from Third Party system, is used to create the hierarchy. This Data Module contains line items referring to various Levels L1, L2….. First Iteration of Data Import gives us say an L7 item with its respective parent/children mappings and second iteration of the load gives us the same L7 Item code under L8 Column. That is, we see a new level is inserted as L7 item now. How do we manage such situations?
Answers
-
@Nipsa That is something which should not happen ideally. You need to have stable hierarchies for a system to work.
If members move from one level to another, I believe you are going to lose all the input data at that level - To fix that you will have to load all the new children of this member which moved from being a child to parent to get the data back. And if the data is end user input then end users need to re input their data.
Thanks,
Misbah
1
