Show blank combinations in Pivot Table based on MS SQL

[karaoan]

Hi,

I am using a relational star scheme with fact and dimension tables (facts containing sales, product table contains product details etc.). Based on that I would like to use a pivot table that shows all products in rows or columns even if there is no record in the underlying fact table for that product. This is no problem with other sources e.g. PowerPivot as there is an option to "show blanks" in the Pivot table. This option is unfortunately not available with relational tables. Would appreciate if anyone has ideas apart from loading everything into a PowerPivot model.

Thanks!

Martin