User receives error "Cannot find column data warehouse dimension code" when importing .CSV file in Data Warehouse manager.
When importing dimension codes into the Data Warehouse Manager with a .csv file, the user receives the error below:
This error message will always reference the last column you have set in your file. The issue is both version and bit specific. Users will experience the error if they try importing dimension codes into the Data Warehouse Manager with .csv files and have both a 64 bit operating systems and 3.7 or 3.8 DWM installed.
The work around would be to either use Excel files to import rather that the .csv file or upgrade to 4.0 Data Warehouse or newer.
Data Warehouse 3.7 and 3.8 with 64 bit operating system