.png)
KeyNotFound Element (ASSL)
Specifies how Microsoft SQL Server Analysis Services responds when it encounters a referential integrity error.
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.
Value | Description |
|---|---|
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.
