Summary:
This article troubleshoots an error that occurs when importing CSV file in Data Warehouse manager
Article Sections:
Symptoms:
When a user attempts to import a CSV file, they receive the following error message:
"Cannot find column data warehouse dimension code"
Causes:
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.
Resolution:
The workaround would be to either use Excel files to import rather that the .csv file or upgrade to 4.0 Data Warehouse or newer.
Properties:
Data Warehouse 3.7 and 3.8 with 64-bit operating system