KB46078: Attribute form data type in a freeform SQL report does not get automatically updated after changing its type through the attribute editor, in MicroStrategy Desktop 9.3.1 onwards.

SYMPTOM:
Attribute form data type in a freeform SQL report is not automatically updated after changing its type through the attribute editor, in Strategy Desktop 9.3.1 onwards.
 
STEPS TO REPRODUCE:
These are the steps to reproduce the issue in Strategy Tutorial:
 

• Edit any freeform SQL report, and add a new attribute form called test, whose type is Text and data type Varchar.
   
  

• Press OK; the report editor will appear. The new managed object displays in the Report Objects window.
• Edit attribute test. Modify the ID form and change its type from Text to Number. Save and close and upate schema.
   
  

• Open the freeform SQL report again and check its definition: the type has been correctly updated but not the data type.
   
   

 The same behaviour is observed with standard project attributes.
 
 
CAUSE:
This is working by design.
 
WORKAROUND:
The attribute form data type can be modified manually through the freeform SQL report editor.