I have a fact and dimensions table. The fact table have a measure. When I group the measure by a dimension from the dimensions table I could get a null value if the dimension doesnt have a key to the fact table. Is there a way of giving this null value a default value?
Dimension1, Measure Null, 123 Dim1, 234 Dim2, 567
I do a left join between fact and dimension.