I’m sure most of the BI developers have the experience of having a customer ask about why there are null values in their report and what they mean. It’s very common to have unknown values in a data warehouse solution and there are a number of reasons to cause it. Sometimes developers take action to fix or hide the unknowns but sometimes we decide it’s OK to just leave it as is. It all depends...