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.