Your super close to the answer. In your data hub you'll want to create a saved view that has one line item, CODE. Then use that saved view in your import to your spoke application. When you try to import the saved view there will be two columns to choose from. ITEM and CODE. The Region should use the ITEM and the CODE should use the CODE.
So in your example all you need to change the mapping. Region should be column1 and Code should be column 2.
Thank you for your help. I must have an issue with my saved view. When I created the saved view in the Data Hub I highlighted the code line item and clicked on show selection. But it doesn't get rid of the region dimension.
I think I might know what the issue is. In SYS05 my codes are Americas, Europe, Asia Pacific. I just deleted everything in my Region flat list. I am going to remap the download. Is this the correct way to import the flat file?