I have a datawarehouse with cube in it.

The problem is that we also want to show results in different date ranges
where stores have not sold certain items. The report itself shows sales by
item and that works fine.

But we also want to show items that have no sales in that time period. But
since there are no records in the fact table, that item doesn't show up.

How do we handle a report like that?

Thanks,

Tom