KB11040: An invalid data type is used to create the warehouse column when generating a datamart table through running a MicroStrategy Report.

SYMPTOM:
 
When creating a data mart table from a report, an incorrect data type is used to create a column for an attribute on the report.
 
CAUSE:
 
This issue occurs because an incorrect data type is specified for the column alias of the attribute form referenced in the SQL.
 
ACTION:
 
To resolve this issue, perform the following steps:
 

• Open the attribute in the Attribute Editor:
  

• Select the necessary attribute form and select Modify, as below:
  

• Select the Column Alias tab:
  

• Click Modify:
  

• Select the appropriate column from the table, as shown below, or create a new column alias that is appropriate for the data:
  

• Click OK and then Update Schema: