I have a requirement in which I need to automate the hierarchy for only the least nodes for the dimension members. When I run the hierarchy data package in BPC, the existing hierarchy which is maintained manually in BPC dimension (Top level members) gets changed and the new data overwrites the hierarchy.
How can I solve this in automation. Is there any option to make the existing data or existing hierarchy as it is in the dimension and only the new data which ever I am loading should populate the hierarchy.
Thanks in advance.....!!!!!
Mohan Kumar M