KB39184: Big Decimal attributes that have ID form with negative values cannot be used in an In-List filter in MicroStrategy Developer 9.x

SYMPTOM:
A user has an attribute with an ID form mapped to a column with a type that Strategy stores as Big Decimal. These attribute elements contains both positive and negative values and the user wants to filter on a subset of these. When creating an attribute element filter qualifying on ID with values copied to a list, the negative values are not filtered.
 
 
STEPS TO REPRODUCE:
 

• Consider a database table that has a column type that Strategy stores as BigInt and contains (at least some) negative values as shown below:
  
• Create an attribute mapped to this column as shown in the image below:

• Executing the report will generate correct results as shown below:
  
• Create an attribute element filter based on the attribute created before.
  
• Select qualify on ID and Operator: In List> Type the values into the list box as shown in the image below:  

• Execute the report again and notice that the negative values are not displayed in the grid:

 
CAUSE:
This is a known issue with Strategy Developer 9.x.
 
ACTION:
Contact Strategy Technical Support for an update on the status of this issue.