Net entities balances because of a split

Summary:

Content (please ensure you mask any confidential information):

Hi All,

We are splitting some entities in our FCC application and to achieve this, we have created a new member in "Custom 2" dimension to move all the balances from existing member to the new member. Basically we would like your opinion on how to make this cleaner. Starting from P5, we will need to move the Closing Balance from "No Custom 2" to "New No Custom 2"→"FCCS_OpeningBalanceAdjustment" and we also need to offset/net existing opening balance in the entities we are moving. We have built some On Demand Rules code to achieve this, but we are not 100% sure that