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). |