How to update an Entity Value on all Intersections in HCP cube?
I'm on Planning 11.1.2.2.303.
I need to figure out a way to do a mass update of the Entity Dimension in the HCP cube due to a reorganization. Planning delivers the whole Position Transfer process but it is completed Position by Position and if the position is filled, you have to transfer the employee out first, then move the position, then move the employee back in. This will be too manually labor intensive and I'm hoping someone might have some other ideas on how to update the Entity Dimension.
I have a spreadsheet that has the Position, Employee, Original Entity, and New Entity dimension member values. Now I need to figure out how to update just the Entity dimension member value with the New Entity dimension value for all Position and Employee intersections.