Value filtering

In the Infor EPM version 11.x, to treat a filter value as a string, you must put double quotes around the value. Otherwise the value is treated as a number.

In the Infor EPM version 12.x, a filter value, that cannot be converted into a number is treated as a string.

When you edit a filter in the user interface, the specified value is converted into a number with the current culture format and store the value in the ListModel. The value is stored in a neutral culture format, en-US. During the transformation from the ListModel into MDX, the stored value is converted with the neutral culture format and then the current culture format. If the conversion is not successful, the value is treated as a string.