KB47385: Unable to filter column when trying to import data via a database connection in MicroStrategy Web 9.4.1.

SUMMARY:
 
This issue has been classified as a defect by Strategy. The impact is limited to the Strategy Web 9.4.1 product when using Data Import with a Netezza database. One workaround exists for this defect. 
 
 
SYMPTOM:  
 
When filtering data in a column during a database connection data import, users are unable to filter as the input box freezes. This issue occurs for some columns but not all.  
 
 
STEPS TO REPRODUCE:

• Import data via a database connection
• Navigate to table with problematic column
• Click on the drop down arrow of the column
• Select Filter > Exactly

• Type in value and click OK                                                                                                                                                     

 
 
CAUSE:  
 
When the column type is a BIGINT in the Netezza database, issue occurs. This is a known issue in Strategy Web 9.4.1.  
 
ACTION:  
This issue has been fixed in Strategy 10. Take advantage of upgrading for a fix. 
 
 
WORKAROUND:
 
Change the datatype accordingly as per the data (i.e - Char, Varchar, Numeric).