This has now occurred for two clients in the past few months, so I thought of posting this idea for consideration.
In both cases, the clients moved from one ERP system to another; and updated the GL Codes or Item Master codes - and the expectation is that Board will use the new codes and historical data in Board is not lost.
Of course the solution is to extract all cubes - modify the codes in those files, clear entity, reload entity with new codes, etc. However, this is high risk , time-consuming solution especially if the solution is complex (many cubes) and the rollout is in phases.
We can manually change the codes one-at-a-time within the Entity Content screen. The benefit here is that all selections in screens, procedures, etc. are maintained intact. The suggestion is to provide an automated way to modify the entity codes either way a DR or on the screen (import code mapping). This is particularly helpful in cases where there are thousands of members.
