Data Cube / Crosstab: Empty rows not showing

jakoby84

Hi,

I attach a sample report using the Classic Models Database. It has a data cube with 2 dimensions: Year / Week Of Year and CUSTOMERNUMBER (table PAYMENTS). I created a measure which counts the number of entries in the given aggregation. The crosstab shows time horizontally and customer numbers vertically. So the measure shows payments per week per customer.
So far so good.

The problem is: I activated the option "Show empty colums: Week Of Year". From my understanding this should result in a crosstab which shows a column for every week from 1 to 53. I followed the exact steps of BIRT - A Field Guide. Nevertheless, the columns of weeks 15, 23, 24, 41, 42 are not shown.

Is this a bug or did I miss something?

Thanks in advance for having a look at the report! Cheers Jakob

kclark

If the dataset doesn't have the date values then the crosstab will still be blank for those dates like your example. One way to get around this is to create a scripted dataset and then add the date range from script. You could then join that dataset with the other and create your cube. <a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/1006-add-missing-dates-to-chart-category---table/'>Here's a devshare</a> with an example showing how to do this with charts. It will work for what you're trying to do though.