Forum Discussion
Blank rows due to data modeling problem
Hi, I am very ameature in finding mistakes. Look at the Adjustable Race and Chain, no value is showing here. I've given you the link of this file https://1drv.ms/u/s!AtNgJBWI0wXOddMheymYlp08Ci0. You...
It's because the 'DimProduct'[ProductSubcategoryKey] is empty for some entries. The DimProductSubcategory table must have the blank row added to it. All the records from the DimProduct table that do not have a ProductSubcategoryKey map to the blank row in the DimProductSubcategory table.