Workaround Birst TRIM behavior on dashboard filters

In LN, there are multiple fields that can have leading spaces on a database level. This causes filtering problems in Infor Birst, because before a filter is applied in Infor Birst, the values used for filtering are trimmed. An example of such a problem is tcibd001.item. When you try to filter the Item.Item column in Infor Birst, which is sourced by tcibd001.item, the filter does not work for non-project items because these items have leading spaces. When you try to filter non project item ' ABC', the applied filter will be 'ABC' and therefore there is no match. Trimming these attributes in the ETL is not an option because this can lead to non-unique values.

On how to work around this issue, see KB article 2150346 on the Infor Support Portal.