I have a requirement to load Hier in to Hyperion Planning using ODI and this Hier replaced all the time
it mean, every time when we run a Hier load in to Hyperion Planning it will should be replace but not Merge..
but I did not find any option which will do replace of Hier
ODI Version: 11.1.1
Hyperion Planning Version: 11.2.3
I think this article will be useful for you Dynamic Integrations for Multiple Hyperion Planning Applications
If you want to merge dimension elements tree, you have to prepare table with difference between planning dimension and source table.
For example our solution:
1. we created view in the hyperion app database which generates dimension hierarchy with elements and it attributes and properties
2. loaded data from view to the staging database
3. compare elements properties and attributes with the new source
4. insert/update/delete only differs between element lists