Missing values

By default, missing values in a database table are assigned the value Not specified during data import into PPM. These missing values can occur when the value of a cell in a database table is NULL. It is normally impossible in Data analytics to link two tables via values that are not specified because a link between missing values is not plausible. A table field without any value specified is usually ignored and the entire record will not be included in an association.

Text dimensions are an exception. For table cells without specified values, a custom default value can be defined that can be identical to an existing value and therefore can be linked to that value. The default value defined will always be imported if a value is missing for a text dimension. Therefore, the value Not specified is never ignored for text dimensions.