Hi Celvin,
But there is a hindrance in your suggested approach. We have built certain historical views which will allow top management to see the trended data something like Last Qtr vs Current Qtr. In such case, till M6 data is sitting in San_Jose_213 whereas from M7 it is sitting at SFO_213. Do you see any possible way to link both the ID’s?
We have created functionality called “Action Item” Tracker against each Global account under local entity level say San_Jose_213. If we stop using san_Jose_213 from M7, how to bring the data of the open Action items into SFO_213?