How to handle null values for dimensions

[cristian2]

Hi all!
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?
My result:

Dimension1, Measure
Null, 123
Dim1, 234
Dim2, 567

I do a left join between fact and dimension.

Cheers,
Cris