KeyNotFound Element (ASSL)
Applies To: SQL Server 2016 Preview
Specifies how Microsoft SQL Server Analysis Services responds when it encounters a referential integrity error.
|Data type and length||String (enumeration)|
|Cardinality||0-1: Optional element that can occur once and only once.|
Referential integrity errors occur when a foreign key value in a dependent table does not have a corresponding entry in the parent table. This error occurs when Analysis Services processes a dimension in which the fact table references a foreign key value that does not exist in the dimension table for that dimension, or when Analysis Services processes a partition when the dimension main table for a dimension that is included in the partition references a key value that does not exist in another associated dimension table. (In the case of dimensions with parent-child hierarchies and parent attributes, this can also occur when the dimension main table for a dimension that is included in the partition references a key value that does not exist in the same dimension table.)
The value of this element is limited to one of the strings in the following table.
|IgnoreError||Processing should ignore the error and continue.|
|ReportAndContinue||Processing should report the error and continue.|
|ReportAndStop||Processing should report the error and stop.|
The enumeration that corresponds to the allowed values for KeyNotFound in the Analysis Management Objects (AMO) object model is ErrorOption.