Best practice approach to adding a custom dimension to an existing FCC application

Summary:

We need to add a custom dimension to an existing FCC application which means we will have to recreate the application from scratch. Are there any best practices regarding this?

Content (please ensure you mask any confidential information):

I'd especially be interested in finding a simple way to import all those prior years without having to recalculate them which can be a hastle with changing mappings, business rules etc.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):