Null Processing Property

The Null Processing property specifies which action Analysis Services takes when it encounters a Null value.

The NullProcessing Property on Measures can now be changed from the Edit Measure dialogue.

The possible Null Processing settings are:

Setting	Description
Automatic (Default)	Null values are treated as ZeroOrBlank
Error	Null values are invalid.
Preserve	Specifies that the Null value is to be preserved
ZeroOrBlank	Specifies that the Null value is converted to zero (for numeric data types) or a blank string (for string data types).