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'll find it in Best Selling page. Please help me to find out the mistake.
4 Replies
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.
Is there any way to fill up this blanks using a calculated column?
Not really a clean way, no. The easiest thing to do is make sure that all DimProduct entries have a ProductSubcategoryKey that can map to DimProductSubcategory table.
This is Adventureworks DW SQL Database. This is the limitation.
