Hi,
I have developed a script to load department and account hierarchies (using Entity as Department) using Outline load that is executed on a daily basis so that if there are any updates in the source system then that can be updated in Hyperion Planning app. We also have planning unit hierarchy defined by Departments and Accounts. Also, we have web-forms defined where we have departments and accounts are used for data entry.
There is an option /R which will delete all members but as per documentation this will delete all approval statuses. Also, as members are defined in web-form, system doesn't allow to delete the members.
One of the main issue faced is that due to frequent changes to department and acc hierarchy it is observed that few members that were deleted in source system remains in Hyperion Planning.
Any help / suggestion is appreciated.
Version: Hyperion Planning 11.1.2.2
Thanks,
VManek