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

WebI: Show all months whether they have data

Sometimes you want to display all values of a dimension in your report, even when there is no data inside

SAP BusinessObjects WebIntelligence - all versions

In WebI you can of course only show the data, that you retrieve from your query. That means, when you want to display your measures based on months in a diagram, you will see only the months on your x-axis you get from your query.

Because that doesn't look very nice, I use the following very simple method to always show all 12 months of a year.

I create a new query in the query panel with two simple dimensions inside: YEAR, MONTH.

Afterwards you can merge those dimensions from the Query 'Date' with the YEAR and MONTH dimensions from your original query. When you use the merged dimension in your report, it will always show all 12 monnths.