Forum Discussion

Alex_Hasan's avatar
Alex_Hasan
Icon for Helper II rankHelper II
4 years ago

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...
Need Help
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
4 years ago

Alex_Hasan 

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.