WebI: Report Filter not working

If you use a report filter in Web Intelligence and no data is shown, although it matches the filter condition

SAP BusinessObjects WebIntelligence - all versions

The problem might be that your text contains invisible special characters like new line. These characters are not working with report filters, you don't get any data in that case.

I remove those special characters in the database layer/semantic layer and replace them with a space (' ') - character. For Oracle Databases your SQL statement could look like this:


REPLACE (
             REPLACE (REPLACE (description, CHR (10), ' '),
                      CHR (13),
                      ' '),
             '   ',
             ' ')
             AS description