Originally posted by Andy Moore
Entity dimensions are assigned to cubes. so when you refer to move entity ABC to another cube you mean to another entity dimension assigned to a different cube. Is not possible to move entity member within entity dimensions, you can only share (not move) entity members of different dimensions to the entity dim in the ""top cube"" where cube references is set up. So in your case, as you mentioned, you will need ABC_New and perhaps move historical data (if needed) via DM job or connector
Approach 1: leave the old entity in the location it was but suffix with _old. Set the ""in use"" property on the old and new entities for the appropriate time periods to prevent and enable data loads/inputs.
Pros: Dimension setup is easy
Cons: just like an acquisition mid year you'll have to make sure the Beginning balances, activity calc used on roll forwards and other flow members are calculating correctly for that first period of the ""_New"" entity. This will affect cash flow generation if you don't properly handle the starting points. You could make this dynamic in the flow rules or create a IF this new exception in the specific month of that flow member formula.
Approach 2: Prefix the old entity with ""Old"" so you can reuse the original name in the other entity dimension and move historical data.
Pros: one time DM extract and load of historical data, minimal impact to current rules. Can document this process for future moves. Approach is more admin friendly
Cons: anytime you move data you need to validate it.